SSAS Series--"06" Multidimensional data (cube creation)

Original: SSAS Series-"06" Multidimensional data (cube creation)

1. File type description

The project definition file (. dwproj), the project user settings (. dwproj.user), the data source file (. ds), the Data source view file (. dsv), the cube file (. cube), the partition file (. partitions), the dimension file (. Dim), A mining structure file (. dmm), a database file (. database), and a DB role file (. role). First boot, souvenir sticker.

Figure Start Interface Souvenir

Figure the contents of the default folder

2. Create data sources, data source views, dimensions, define and deploy cubes

Figure by SDK operator interface

Note that the data source view must select "Use service Account", otherwise the deployment will fail, the SDK does not have detailed instructions.

Figure Data Source simulation information interface

Figure Cube Data browsing

3. Modifying measures, attributes, and hierarchies

A, add a hierarchy of dimensions

It's simple, you just need to drag the mouse to complete the setup work, the settings need to be renamed after completion.

Diagram to set the hierarchy of dimensions

Diagram Setting attribute Relationships

Rigid relationships do not change over time:

Diagram Setting Relationship Properties

B. Add a named calculation

In the data source view, select the table, right-click, and select New named calculation:

Figure Edit Named Calculation

C. Define display folder

Select the dimension values to put in the folder (press the CTRL key to choose multiple), right-click, properties

Figure Setting the AttributeHierarchyDisplayFolder value

D, define the combination of KeyColumns

Figure Setup KeyColumns

Graph combination Values

Figure Setting Display values

E. View changes, deployment takes effect

Figure OLTP Database content update

Need to redeploy after diagram dimension update

Figure Cube Browse

SSAS Series--"06" Multidimensional data (cube creation)