Monday, 23 July 2012

How to add financial dimensions to cubes [AX 2012]

AX 2012 BI is so much easier and enjoyable to use. Seeing how easy it is, I don’t see a reason for not deploying it all clients.

To add a financial dimension
  1. Click Tools > Business Intelligence (BI) tools > SQL ServerAnalysis Services project wizard. Click Next.

  2. Select Update and then click Next.

  3. Select an Analysis Services project to add the financial dimension to, and then click Next. After the project builds, click Next again.

  4. On the Select perspectives screen, click Next.

  5. On the Select Microsoft Dynamics AX dimensions screen, select financial dimensions you want to include in your Analysis Services project.

  6. Complete the wizard.

Cube2012-07-18_0959

Cube2012-07-18_1000

Cube2012-07-18_1001

Select the perspectives

Cube2012-07-18_1002

Select the dimensions

Cube2012-07-18_1003

Select the date diemension/s

Cube2012-07-18_1004b

Select the label translations

Cube2012-07-18_1004c

Then wait for it to finish. This will take some time.

cubes2012-07-18_1005

Once done. Continue with the wizard.

c2012-07-18_1042

 

By the selections we made in the wizard. The “Visual Studio Projects” > “Analysis Services Project” > “Dynamics AX” in the AOT is modified to include the changes.

Final result. My dimensions are available in the cube now.

C2012-07-18_1229

 

Interesting video on BI story in AX 2012

http://www.youtube.com/watch?v=2XKZibvK2cQ

 

Reference:

http://msdn.microsoft.com/EN-US/library/hh128830

No comments: