Database Reference
In-Depth Information
KPIs
You can also specify KPI calculations in tabular models. To create a KPI, perform the
follow steps:
1. Click on the
FactInternetSales
tab.
2. Click on any of the empty cells in the
Measure Grid
.
3. Type the following formula to create a measure that will contain the KPI target:
SalesAmountKPITarget:=[Previous Year
SalesAmount] * 1.4
4. Click on the
Sum of SalesAmount
measure.
5. Then click on the
Create KPI
button.
6. Specify that
SalesAmountKPITarget
is the target for the KPI:
Search WWH ::
Custom Search