What are the major steps for building a cube
- Create a Data Source
- Create a Data Source View
- Design/Build the Analysis Cube
What is the difference between Building a cube and deploying a cube?
Building a cube saves the scripts. Deploying the cube inserts data into the structure.
What’s the difference between a natural and non-natural hierarchy?
Natural Hierarchy: One-to-many relationship
Non-natural Hierarchy: Many-to-many relationship
What are Named Queries?
With named queries you can create a new table in your DSV that doesn’t exist in your source data. Data in the “named query” table is based on data from existing DSV tables, OR from other data sources not in your current DSV.
What are Named Calculations?
New fields. Use named calculations to create derived and/or decoded fields based on existing fields. E.g. fullname, GMAT_rating
Calculated Members
If it’s a new number that will be stored in your fact table, and requires you to reference mathematical operators and/or logical expressions in order to determine the number, create a new calculation.
What are new measures?
If it’s a new number that will be stored in your fact table, and can be determined by using a count, sum, min, or max, create a new measure.
What are KPI’s based on?
- The current Value of a previously-created calculated measure you’re interested in,
- Your business Goal for the measure (typically a constant),
- Status (a comparison of the current value to the goal) depicted visually
- Trend (a comparison of current value to previous time periods), depicted visually. Trend expressions must be time-based.
- MDX is used for KPIs
What are actions?
Actions give users a way to take additional steps during their analysis of cube data. They are events that are user-initiated by right-clicking in cells.
What are the categories of actions?
- Report: invokes a previously-created SSRS report based on the current cube data,
- Standard: a category of five actions that lets you do things like branch to a website specific to the data you clicked on—good for things like linking to a map,
- Drillthrough: provides you with detail-level data that produced that cell in the cube
What is MDX used for?
MDX is the query language for data stored in multidimensional data files. We’ve already seen that MDX is the basis for creating calculated members, KPIs, and actions in SSAS cubes. It is also the basis for general querying of SSAS cubes such as the analyses we do in the cube browser.
