Monday, 18 April 2016

Deploy the Standard SQL Cubes for Instant Business Intelligence

Deploy the Standard Cubes for Instant Business Intelligence



Dynamics AX 2012 comes pre-configured with 16 reporting cubes that distills the data into a more user friendly view.  You can use these to create your own reports and dashboards from, and because they remove the need to be a database expert in order to understand the data, the general users are able to take advantage of them as well.
You may think that the creation of the cubes would be an arduous task, involving a lot of design & planning, and would require weeks or even months to get them up and running, but it’s not the case.  All you have to do is run a simple deployment wizard and you should be up and running within minutes.
What are you waiting for?
HOW TO DO IT

From the File menu, select the Tools submenu, and then the Business Intelligence (BI) toolssubmenu, and select the SQL Server Analysis Services project wizard menu item.
20131111.1
This will start up the Analysis Services project wizard. When the welcome dialog is displayed click on the Next button.
20131111.2
Select the Deploy option to create a the 16 cubes from the existing project that is already built within Dynamics AX and click the Next button.
20131111.3
Then select the Dynamics AX product from the drop down list and click the Next button to continue.
20131111.4
When the Deployment options are displayed, select the data partition that you want to create the cubes for and then click the Next button.
Note: You may only have one partition.,
Also, check the Process the project after it is successfully deployed checkbox.  This will process the data so that you will be able to report off it right away.
20131111.5
The wizard will then start running, and will probably run for a couple of minutes as the cube is being created and processed.  When it is completed, just click the Next button.
20131111.6
Now you can exit the wizard by clicking on the Finish button.
20131111.7
If you look at the Analysis Services cubes within SQL Server Management Studio, you will be able to see all of the cubes that the wizard just created.
20131111.8
If you also connect them to PowerView then you will be able to create dashboards directly from the data within seconds.
20131111.9
How easy is that!

No comments:

Post a Comment

Labels

#veryusefulcode (1) AIF (8) AOT Maps (1) Args (1) Ax 2009 Reports (2) AX 2012 navigation (1) Ax 2012 Interview Questions (1) AX 7 (2) AX Architecture (1) Ax Backup (1) AX Workflow (2) AX2012 (1) AX2012 R2 (1) Ax2012R3 (1) AX2012R3 Dynamics Connector Step by Step Installation and Configuration (1) AX2012R3 EP Step by Step Installation and Configuration EP R3 (1) AX2012R3 HelpServer Step by Step Installation and Configuration (1) AX2012R3 Rapid Start Connector Step by Step Installation and Configuration (1) AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration (1) AX7 (1) Best practices (1) Blocking user to enter (1) Collection Classes (1) Container (1) D365FO (3) Data Migration Frame Work ax 2012R3 (1) Deleting duplicate Record from Table – Ax2012 (1) Delivery due date notification workflow in Ax 2012 (1) Development Steps EP (1) Dimensions (1) DIXF (1) DMF in Ax 2012 R3 (1) Dynamics Ax 2012 Interview Questions (1) DYNAMICS AX 2012 INTERVIEW QUESTIONS PART 2 (1) DYNAMICS AX 7 (1) EDT relation Migration Tool (1) EP AX 2012 (1) Ep Lookup (1) Error (1) Event Handler (1) F5 (1) File Handling (4) Filter on AX2012 Listpage (1) filtering (2) financial dimensions in AX 2012 (3) form (1) images (1) Installation and Configration (4) Installation and Configuration (11) Installation of Management Reporter 2012 for AX 2012 (1) Interaction class in ax 2012 (1) Interview Question (1) Interview Questions For Ax 2012 (1) Invent DIm (1) Jobs (2) license (1) List page and form menuitem enable code (1) Methods (1) microsoft Dynamics AX 365FO (1) Number Sequence Generation – AX 2012 (5) Number Sequence2012 (1) OLTP-OLAP (1) Passing Args (1) Passing form caller and menu item caller in ax 2012 (1) Passing Multiple Records Args (1) Posting in Ax 2012 (1) POSTING PURCHASE ORDER (1) Query (1) Query Filter Form (2) Query Ranges in X++ (1) Question and Answer (1) Report (1) Reports Controller class (1) RLS in ax 2009 (1) SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF (1) Security (1) security roles (1) Security Sysqueryrangeutil (1) Sharepoint 2016 (1) SQL SERVER (1) SSRS (2) SSRS Reports Controller class (2) Table collections & Virtual company (1) Time (1) TIPS AND TRICKS (1) Web service AIF (3) Web Services on IIS (AIF) Step by Step Installation and Configuration (1) workflow ax2012 (1) Workflow installation (1) Workflow Method (3) X++ (1)