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

Notifications

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) / AX 2012 R3: Issue with...
Microsoft Dynamics AX (Archived)

AX 2012 R3: Issue with SSAS cube - AOT perspective based on union view (union all query).

(0) ShareShare
ReportReport
Posted on by Community Member

Issue with SSAS cube - AOT perspective based on union view (union all query).

Hi, dear colleagues!

Strange situation with SSAS cube based on union view.

So, union query included 3 data - ProdTable, Forecast, CustInvoiceTrans, fields - ItemId, InvoiceDate, InventQty. (manipulated each QTY by  view methods -SalesQty, ProdQty, ForecastQty )

Perfectly creates view and i can get correct data over AOT or SQL query.

After implementing this view into Perspective - SSAS cube, we get only 1 rows 1 date for each item, Production or sales or forecast- which one is first data for each item.

Anybody experienced this issue?

It i so strange!

Thank you very much!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi!

    Did anybody experienced this situation?

    It looks like an simple bug.

    Everyone can experience this issue doing some simple steps:

     - just merge tables CustInvoiceTrans and SalesLine, (union all)

     - fields : ItemId, SalesId, InventQty-QtyOrdered.

     - View will show all data correctly, but Cube not.

    Hope anyone can to explain something logical mind about this.

    A specially i want to listen opinion from some specialists as Lance [MSFT] .

    Thanks! 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Sarvan.

    I know , but I will not tell you :)

  • Community Member Profile Picture
    Community Member on at

    ;) Thank you!

  • Logu CBE Profile Picture
    Logu CBE 20 on at

    Is it is known issue?

    Thanks in advance,

    Loganathan S

  • Logu CBE Profile Picture
    Logu CBE 20 on at

    Dear All,

    Am having a View which developed based on Union Query. 

    It works fine in SQL Brower.

    However, while i use the same in Prespective, Cube having only one record per combination. 

    Is it a known issue OR Am i missing something here?

    Thanks in Advance,

    Loganathan S

  • Suggested answer
    Logu CBE Profile Picture
    Logu CBE 20 on at

    AnalysisIdentifier fixed this issue. :)

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans