Microsoft Dynamics 365 Blog

Sometimes I can see following problem. In the CEO role center the financial KPIs give following error:

The error is Query (1, 9) The Total Revenue-Argument for the given KPIVALUE-Function must be a KPI-Name (Key Performance Indicator).

Here problem is quite easy.

For General Ledger KPIs please make sure that Ledger account categories are correctly set up. To learn more please visit Application and Business Processes Help (Applications and Business Processes -> Finance ->Setting up and maintaining Finance -> Setting up and maintaining General ledger -> Setting up the chart of accounts -> Ledger account categories and analysis cubes) To learn more how KPIs are counted please read WhitePaper: Microsoft Dynamics AX 2009 Business Intelligence Cube Reference Guide

To check which exactly Ledger account category has not assigned account to you will need to use BIDS (Business Intelligence Development Studio)

 

 

 

BIDS

 

In above screenshot you can see that Cost of Goods sold is based on Ledger account category with id 35 which is COGS. So you would need to go to General ledger -> Setup -> Ledger Account categories and make sure that group COGS has accounts assigns.

After changes made you will need to process cubes.

 

–author: Czesława Langowska
–editor: Czesława Langowska
–date: 06-12-2010

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!