Create New SSAS Databases and Cubes

Add New SSAS Databases and Measure groups

1. Right click 'SSAS Databases' and click 'New SSAS Database'.

2014-06-05_09_57_44-Store.png

 

2. Type a name and select a type. Click 'Finish'.

2014-06-05_09_59_50-Store.png

 

3. You should now be able to see your new SSAS Database in the Navigator pane.

2014-06-05_10_03_29-Store.png

 

4. Right click the SSAS Database, and click 'New Cube'. Now right click the new Cube, and click 'New Measure Group'.

2014-06-05_10_10_16-Store.png

 

5. Give the new Measure Group an appropriate name. Click 'Finish'.

2014-06-05_10_11_46-Store.png

 

6. Click on your new Measure Group and go to 'Fact Source Tables'. Click 'New', and select a Fact Source table from the menu. Click 'Save'.

2014-06-10 10_57_23-.png

 

 

Add Dimension Links

1. Go to 'Dimension Usage', and add new Dimension Links.

2014-06-05_10_19_02-Store.png

 

a. Select a dimension from the list, and make sure it's bonded to the right item. Click 'OK'.

2014-06-05_10_21_15-Store.png

 

b. Click 'New Time Dimension Link' under the 'New' tab to add a Time dimension to the list, and follow the same procedure.

2014-06-05_10_23_29-Store.png

 

c. Add all necessary dimensions, and click 'Save'.

2014-06-05_10_25_52-Store.png

 

2. Click on your created SSAS Database and go to 'Dimension Settings'. Make all necessary changes and click 'Save'.

2014-06-05_10_29_46-Store.png

 

Add Business Logic

1. Go to Business Logic, click 'New' and select a type from the list.

2014-06-05_10_33_54-Store.png

 

a. Add a new Name Definition

2014-06-05_10_36_24-Store.png

 

b. Select Category and Data Type, and type in ID and Name. Click 'Save'.

2014-06-05_10_41_18-Store.png

 

c. Add an Expression and click 'OK'. 

2014-06-05_10_43_30-Store.png

 

d. Your added business logic should now appear. Click 'Save'.

2014-06-10 09_53_14-Profitbase Studio 6 (beta).png

 

i. If you have more than one fact table it is beneficial to add Time Function as a business logic, so it automatically adds into all of your tables.

2014-06-10 10_16_18-Business Logic Builder.png


 

Process Module and Build SSAS Database

1. You should now be ready to process your cube. Click 'Tasks and Data'. In the new dialog box; click  'Process Module'. When the module has successfully processed, click 'Delete and Rebuild SSAS DB'.

2014-06-05_10_52_14-Store.png

 

2. Here is an example of a Sales cube opened in Excel 2013: 

2014-06-05_11_13_06-Store.png

 

 

 

Information about Module Management

For more information about module management such as SSAS Database editing, click here: Module Management