The end user does not want to see the integer key for product, they would want to see the Product Name. Changing the NameColumn property will enable a different column value to be used. The Product, Category and Subcategory all have keys as the displayed values in this cube. To Deploy, right click the project and select Deploy from the submenu like Figure 4.Īfter the cube is deployed, go to the Browser tab of the Dimension editor and reconnect to browse the changes. If too many changes are made at once, an error during deployment might be harder to catch. It is always good to deploy the project when making changes with Multidimensional Cubes. After renaming, deploy the cube in order to browse the changes. Right clicking on these names and select rename from the submenu will assist in this task. There needs to be some cleaning up of the names used for attributes and dimension name as well as adding new attributes and changing the NameColumn for the keys. The Dimension editor will open to the Dimension Structure Pane, but also note there are 3 other panes (or tabs): Attribute Relationships, Translations and Browser. To update the new dimensions, go to the Dimensions folder in the solution explorer and double click the Dim Product dimension or right click and select Open from the submenu. But, the other dimensions related to the fact table selected were created with the Cube wizard and added as dimensions like Dim Product and Dim Customer in Figure 1.įigure:1 Dimensions Created with Cube Wizard The cube created in the previous article, Initial Attributes and Measures in SSAS Multidimensional Cubes, had the Date Dimension created through the dimension wizard and was completed before running the cube wizard. On the other hand, the Tabular Model will select all the columns in a table or view imported like the older versions SSAS for cubes. If these dimensions are not deselected during the cube wizard, the dimension is built with Keys only. The cube wizard selects dimensions not previously defined but based on relationships built in the Data Source View outside of the Dimensions already built. Multidimensional Cubes (cubes) handle the attribute list differently than the Tabular Model for SQL Server Analysis Services (SSAS). It is a hard path to follow and the seasoned architect’s experience might be the better option. Sometime a developer feels the need to provide everything to end users, whereas seasoned Business Intelligence Architects understand to provide only the attributes from the requirements. In Data Warehouse language, slicing and dicing is done with Dimension Attributes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |