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!