You’re offline. This is a read only version of the page.
65
Hello everyone...
I have created an KPI as "CustomerSales" under Accounts Receivable Cube and i have deployed it. And i created one ssrs report [dynamics ax reporting service] and i mapped the DataSet source as DynamicsAXOLAP.
Here is my code which i have added in my dataset,
SELECT
{
KPIValue("Customer Sales"),KPIGoal("Customer Sales"),KPIStatus("Customer Sales"),KPITrend("Customer Sales")
}
ON COLUMNS,
STRTOSET(@Period) on rows
FROM
[Accounts Receivable Cube]
where STRTOMEMBER("[Master Company Reporting Currency].[Currency].&[" + @Currency +"]")
While adding the KPI value of Customer sales in the report design, i am getting the following error as,
Error 1 : 'Fields!Measures_Customer_Sales_Goal.Value' is invalid. Could not find identifier.
Could any one please help me how to rectify this error.?
And also I could not able to add the KPI in standard report designer. Please give me your valuable suggestion.
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
