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)