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.
