"Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed."

(0) Share

Report

Posted on by Harvinder Singh

Error coming while opening "Top customers by YTD Sales" report. I am using AX 2012 R3 with CU9.

Report path:

Sales & Marketing --> Reports --> Statistics --> Customers --> Top customers by YTD Sales

All responses (4)

Answers (0)

Suggested answer

Hossein.K 6,646 on at

Like (0)

Report

RE: "Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed."

Hi,

You can process the cubes from either SQL server management studio or from BI development studio.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: "Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed."

Hello Harvinder,

Thanks for the update.

As you are on a pretty old CU 9 version, have you checked possible hotfixes on LCS already?

Best regards,

Ludwig
Harvinder Singh 12 on at

Like (0)

Report

RE: "Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed."

Yes, I have processed the cube. This issue is coming since beginning. I have done setup related to Fiscal calendar in General Ledger --> Setup.

But problem is still persisting.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: "Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed."

Hi Harvinder Singh,

Have you processed the cube and/or did the report work fine previously?

Best regards,

Ludwig