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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reports using Cubes
Microsoft Dynamics AX (Archived)

Reports using Cubes

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

Some reports in AX use the cubes. I can pull out the list of reports using cubes by querying the reportserver database, but how can I know easily which cubes each report is taking out its data ?

Does it exist a spreadsheet with this kind of information ?

Thank you

*This post is locked for comments

I have the same question (0)
  • venkatesh vadlamani Profile Picture
    venkatesh vadlamani 3,180 on at

    Go by the module , Generally the measure are different in each cube.

    You can check for documentation on each cube in MSDN and find out which reports are available .

  • Lance [MSFT] Profile Picture
    Lance [MSFT] on at

    Reports data sets that connect to the Dynamics AX analysis services database will have a datasource where the name is DynamicsAXOLAP.  To determine the cube it uses, you would have to search the query for the data set.  Somewhere near the end of the query will be a FROM keyword followed by the name of the cube.  Here's an example data set query from one of the workflow reports.  This one selects data from WorkflowCube

    WITH MEMBER [Measures].[ParameterCaption] AS

       [Workflow transactions].[AssociationType].CurrentMember.Member_Caption

     MEMBER [Measures].[ParameterValue] AS

       [Workflow transactions].[AssociationType].CurrentMember.UniqueName

     MEMBER [Measures].[Default] AS

       [Workflow transactions].[AssociationType].[All].UniqueName

    SELECT

     {

       [Measures].[ParameterCaption]

      ,[Measures].[ParameterValue]

      ,[Measures].[Default]

     } ON COLUMNS

    ,{

       except([Workflow transactions].[AssociationType].MEMBERS,[Workflow transactions].[AssociationType].[All].UNKNOWNMEMBER)

     } ON ROWS

    FROM [Workflow cube];

    In the report moxl file (the design for the report) the query is in the Query property on the data set.  In the report rdl file (the file that is set up to reporting services) the query is in the CommandText property for the data set.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans