web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error when running a report

(0) ShareShare
ReportReport
Posted on by 534

Hi,

When I open this path  as follows:

AUS/Procurement and sourcing/Area page->Rpeort->Statistics/Vendor/Purchases in the past period’ report 

It shows the error as given down while running a report in 2012 R2.

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.

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    47,610 User Group Leader on at
    RE: Error when running a report

    This means your cube that has been deployed on SSAS server is not correct. The AX tried to find a dimension, and was failed to do. Watch your cubes again please. If you have made customizations in those.If you do believe otherwise, that you haven't customised the  cubes, re-dploy those by running AX Wizard. You can delete existing DB from SSAS server, before running the cubes deployment. Generally i would deploy only from AX whereas for processing , I would prefer from SSAS server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans