Horas de mi
Páginas: 2 (269 palabras)
Publicado: 2 de septiembre de 2010
How to create an adaptive metric that will choose different metrics for calculation based on an attribute value in MicroStrategy Desktop 8.0.x
Consider the followingscenario using the MicroStrategy Tutorial project. A user wants to calculate the 'Revenue' value when the attribute 'Category' displays the value 'Books' but wants to displaythe 'Profit' value when Category displays any other value.
The user must create an adaptive metric that decides which metric to apply depending on the value of the attribute.To achieve this, follow the steps below:
1. Create a new metric with the following definition:
Sum(Category) {~, Category}
2. Add the level of Category to themetric using standard / standard for filtering and grouping as shown below::
3. Create a second metric with the following case statement to select the appropriate metricbased on the conditions of the attribute:
Case(([sum category] = 1), Revenue, ([sum category] <> 1), Profit)
4. The case statement could have been expanded touse a third metric for specific values of the attribute 'Category' by adding a new case to the statement as:
Case(([sum category] = 1), Revenue, ([sum category] = 2),Profit,([sum category] = 3), [Units Sold])
If the user adds the metric to a report and executes the report, the results will appear as follows:
Notice that the 'casestatement' metric calculates the Revenue value when the attribute 'Category' displays 'Books' and calculates the 'Profit' value for any other elements of 'Category.'
For moreinformation on adaptive metrics, refer to the following MicroStrategy Knowledge Base technical note:
TN11067 (TN5200-75x-0459): What is an adaptive metric in MicroStrategy?
Consider the followingscenario using the MicroStrategy Tutorial project. A user wants to calculate the 'Revenue' value when the attribute 'Category' displays the value 'Books' but wants to displaythe 'Profit' value when Category displays any other value.
The user must create an adaptive metric that decides which metric to apply depending on the value of the attribute.To achieve this, follow the steps below:
1. Create a new metric with the following definition:
Sum(Category) {~, Category}
2. Add the level of Category to themetric using standard / standard for filtering and grouping as shown below::
3. Create a second metric with the following case statement to select the appropriate metricbased on the conditions of the attribute:
Case(([sum category] = 1), Revenue, ([sum category] <> 1), Profit)
4. The case statement could have been expanded touse a third metric for specific values of the attribute 'Category' by adding a new case to the statement as:
Case(([sum category] = 1), Revenue, ([sum category] = 2),Profit,([sum category] = 3), [Units Sold])
If the user adds the metric to a report and executes the report, the results will appear as follows:
Notice that the 'casestatement' metric calculates the Revenue value when the attribute 'Category' displays 'Books' and calculates the 'Profit' value for any other elements of 'Category.'
For moreinformation on adaptive metrics, refer to the following MicroStrategy Knowledge Base technical note:
TN11067 (TN5200-75x-0459): What is an adaptive metric in MicroStrategy?
Leer documento completo
Regístrate para leer el documento completo.