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

Finance and Operations/AX Developer Forum
1

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!

2

UPS!

AX 2012 R3 CU10, SQL Server 2012

Everyone can to experience this issue in 3 step:

  • merge CustInvoiceTrans and SalesLine tables by union query

  • fields ItemId, SalesId, Qty

  • view will show data correcly, repeated 2 time per line

  • after implementing it to perspective, SSAS cube will not describe data correctly

Regards.