|
Data Warehouse |
|
|
[SSAS] |
|
|
Questions: |
Notes: |
|
How can you optimize reading from a Cube? |
In order to optimize reading from a cube, you physical normalize the dimensions via attribute hierarchies.
It is also a good idea to create Partitions in the data storage files of the cube. By creating partitions the server can perform parallel processing on the cube’s partition files.
Optimize your MDX queries by using efficient query strategies.
Create aggregations on the partition files which will group duplicate data together to increase performance. |
|
How can you optimize processing on a Cube? |
In order to optimize processing on a cube, you use incremental loading strategies.
This is done by processing only the data from the relational database which differs from the data in the cube. |
|
What is the importance of adding Business Intelligence to dimensions? |
The act of adding Business Intelligence to dimensions means you are setting attributes to match their specific type and function.
For example, setting up an Account dimension to have an Account#, AccountType, and Description while processing the data.
By adding Business Intelligence to dimensions, SSAS can better process and manage the attribute data correctly and automatically perform aggregations, calculations, and hierarchies specific to that dimension type. |
|
What is a Calculated Member? |
Calculated Members are a part of Cubes which allow us to create our own user defined measures.
They can be calculated with arithmetic, if else logic, aggregations, etc.
They also allow for custom formatting in the Cube viewer. |
