Lesson 2-4 - Reviewing Cube and Dimension Properties
Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium
After you have defined a cube, you can review the results by using Cube Designer. In the following task, you review the structure of the cube in the SQL Server Analysis Services Tutorial project.
To review cube and dimension properties in Cube Designer
To open the Cube Designer, double-click the Analysis Services Tutorial cube in the Cubes node of Solution Explorer.
In the Measures pane of the Cube Structure tab in Cube Designer, expand the Internet Sales measure group to reveal the defined measures.
You can change the order by dragging the measures into the order that you want. The order you create affects how certain client applications order these measures. The measure group and each measure that it contains have properties that you can edit in the Properties window.
In the Dimensions pane of the Cube Structure tab in Cube Designer, review the cube dimensions that are in the SQL Server Analysis Services Tutorial cube.
Notice that although only three dimensions were created at the database level, as displayed in Solution Explorer, there are five cube dimensions in the SQL Server Analysis Services Tutorial cube. The cube contains more dimensions than the database because the Date database dimension is used as the basis for three separate date-related cube dimensions, based on different date-related facts in the fact table. These date-related dimensions are also called role playing dimensions. The three date-related cube dimensions let users dimension the cube by three separate facts that are related to each product sale: the product order date, the due date for fulfillment of the order, and the ship date for the order. By reusing a single database dimension for multiple cube dimensions, SQL Server Analysis Services simplifies dimension management, uses less disk space, and reduces overall processing time.
In the Dimensions pane of the Cube Structure tab, expand Customer, and then click Edit Customer to open the dimension in Dimension Designer.
Dimension Designer contains these tabs: Dimension Structure, Attribute Relationships, Translations, and Browser. Notice that the Dimension Structure tab includes three panes: Attributes, Hierarchies, and Data Source View. The attributes that the dimension contains appear in the Attributes pane. For more information, see Dimension Attribute Properties Reference, Create User-Defined Hierarchies, and Define Attribute Relationships.
To switch to Cube Designer, right-click the Analysis Services Tutorial cube in the Cubes node in Solution Explorer, and then click View Designer.
In Cube Designer, click the Dimension Usage tab.
In this view of the SQL Server Analysis Services Tutorial cube, you can see the cube dimensions that are used by the Internet Sales measure group. Also, you can define the type of relationship between each dimension and each measure group in which it is used.
Click the Partitions tab.
The Cube Wizard defines a single partition for the cube, by using the multidimensional online analytical processing (MOLAP) storage mode without aggregations. With MOLAP, all leaf-level data and all aggregations are stored within the cube for maximum performance. Aggregations are precalculated summaries of data that improve query response time by having answers ready before questions are asked. You can define additional partitions, storage settings, and writeback settings on the Partitions tab. For more information, see Partitions (Analysis Services - Multidimensional Data), Aggregations and Aggregation Designs.
Click the Browser tab.
Notice that the cube cannot be browsed because it has not yet been deployed to an instance of SQL Server Analysis Services. At this point, the cube in the SQL Server Analysis Services Tutorial project is just a definition of a cube, which you can deploy to any instance of SQL Server Analysis Services. When you deploy and process a cube, you create the defined objects in an instance of SQL Server Analysis Services and populate the objects with data from the underlying data sources.
In Solution Explorer, right-click Analysis Services Tutorial in the Cubes node, and then click View Code. You might need to wait.
The XML code for the SQL Server Analysis Services Tutorial cube is displayed on the SQL Server Analysis Services Tutorial.cube [XML] tab. This is the actual code that is used to create the cube in an instance of SQL Server Analysis Services during deployment. For more information, see View the XML for an Analysis Services Project (SSDT).
Close the XML code tab.