Friday, December 31, 2010

How to Configure OLAP data

There are three steps to configure olap data.
1.       Import data
2.       Update Business Intelligence Data
3.       Deploy the cubes
4.       Process the cube

Import Data:

The normal data is required before the configuration of Olap data, you follow the standard process to import normal data.


Update Business Intelligence Data

Goto à Ax Tools menu à Business Intelligence (BI )Tools à Analysis Servers à Advanced Tab à Checked the “Update BI Data” check box and press the “Update databases” button

Deploy the cubes

Goto à Ax Tools menu à Business Intelligence (BI )Tools à Analysis Service Project Wizard à

Press Next
Select the “Deploy” Radio button and press next
Select Dynamics AX in the first drop down and press next

Choose existing data in the “Analysis Services” database radio button and press next à Next and the will be deployed.

Process the cube

This part will import the data in the cube deployed in the analysis database.
Goto à SQL Server à Connect to the analysis server à Expand the databases à expand Dynamics AX à expand the cubes node à if you want to process all the cube, right click on the Dynamics AX node and click on the process link, or if you want process a specific cube i.e. Ledger Cube select the cube and process it.


No comments:

Post a Comment