BISM - Creating KPI's

he tabular model and power pivot (CTP) allows the quick creation of KPI's. This quick post looks at how KPI's are created and viewed in Excel.

Creation

Once a measure is defined in the measure grid, a KPI can be created from it. This is done by selecting the cell that contains the base measure (ie the value cell) and selecting 'Create KPI' from the menu bar (or 'Create KPI' from the fast menu (ie, right click à create KPI)). This invokes the KPI manager dialog as below. Note that the base measure is defined and although this is selectable, it is not editable.