SSAs series-[06] multi-dimensional data (create cube)

1. file type description

Project definition file (. dwproj), Project user settings (. dwproj. user), data source file (. DS), data source view file (. dsv), multi-dimensional dataset file (. cube), partition file (. partitions), dimension file (. dim), mining structure files (. DMM), database files (. database), database role file (. role ). Start for the first time and add a commemorative post.

Figure startup page

Figure content in the default folder

2. Create a data source, data source view, dimension, definition, and deploy a multi-dimensional dataset

Figure SDK-based operation interface

Note: You must select "use service account" for the data source view. Otherwise, the deployment will fail and the SDK does not provide detailed description.

Figure data source simulation Information Page

Figure cube data browsing

3. Modify measurement values, attributes, and hierarchies

A. Add a dimension hierarchy

It's easy. You only need to drag the mouse to complete the setting. After the setting is complete, you need to rename it.

Figure setting Dimension Hierarchy

Figure setting property relationship

The rigid relationship does not change with time:

Figure setting Link Properties

 

B. Add name Calculation

In the data source view, right-click a table and choose new name calculation from the shortcut menu ":

Graph editing name Calculation

C. Define the display folder

Select the dimension value to be placed in the folder (press Ctrl to select multiple values), right-click, attribute

Figure setting attributehierarchydisplayfolder Value

 

D. Define the combined keycolumns

Figure setting keycolumns

Graph combination value

Graph setting display value

E. View changes and deployment effectiveness

Figure OLTP database content update

Redeployment is required after the graph dimension is updated.

Figure cube browsing