List all KPIs in MDX

(2 posts) (2 voices)

Activate e-mail notification in your profile settings to get updates. [Help ?]

Tags:

davidkp
Member

HI all,

I want to find out whether it is possible to list down all KPI's names by MDX query.

Basically i want to check a perticular KPI is available or not.

Thanks.

Posted 1 year ago #
sqltech56
Member
Hi david,
if you want to check whether the perticular KPI is present or not, you can go with the below query:
```
select KPIValue("Net Income") on 0,
{} on 1
from [Adventure Works]
```
Here "Net Income" is the KPI name. If the KPI is available it will not throw error otherwise it will throw error as below:
```
Executing the query ...
Query (1, 8) The 'Nedt Income' argument passed to the 'KPIVALUE' function must be a Key Performance Indicator (KPI) name.

Execution complete
```
Posted 1 year ago #

Reply

You must log in to post.