|
Data Warehouse |
|
|
[SSAS] |
|
|
Questions: |
Notes: |
|
What is the Trend Expression? |
The Trend expression is used to compare the current Status value with the value of Status at a previous point in time. As with status, you can assign a graphic to illustrate whether the trend is positive, negative, or neutral. |
|
What if KPIs become complicated and cumbersome? |
Because MDX expressions in a KPI may become complicated, it is useful to create calculated members for the values you need in your KPIs and then just use the calculated members when you create the KPI itself.
For particularly complex calculations, it is a good technique to build simple calculated members and then build other calculations from them. |
|
What are Actions? |
Actions are a functionality in cubes which makes cubes more interactive.
You can have an action occur when a user clicks on a specific member in the browser.
It can perform an action or functionality such as: view in a detailed report, redirect to a ASP.net application that has more robust information, etc.
|
|
What is Drillthrough? |
Drillthrough is a popular action type in which you can implement to provide immediate access to the most detailed data stored in your cube. If you’re using SSRS, you can use the Reporting action to link a report to a cube object. |
|
How do you create an Action? |
The Cube Designer in BIDS includes an Actions tab. In there you can define an action and specifying the action name, action target, the action type, and the action expression that generates a string used to run the action. |
