Forum Discussion
SSAS Cube Data Impot Mode Issues
Hi Experts!
I'm working with an SSAS Cube data connection building a dashboard in BI. It has multiple calculated fields that when connected to the dashboard as a "Live Connection" work perfectly- but I am unable to customize anything: No measures, columns, title cards, even decimal places cannot be changed.
So I used the Import method and chose the fields I need. The issue I'm currently running into is:
Day Sales Outstanding is a calculated field that when imported SUMs up to horribly wrong amounts, and the closest I've gotten to the right figures are using the Average function for the DSO field but it's still really off.
When I try to create my own measure for Current and Previous DSO it works great!
But when I try to add parameters like "Accrual DSO" = Calculate('DSO_Table[DSO_Measure], Filter(DSO_Table, [X] in {"Parameter", "Parameter_2"}))
and so forth....
I get blank results.
I'm not sure how to fix this issue if anyone can please provide guidance!
2 Replies
When you import from a cube you are freezing the results. You should ignore the DSO field from the cube and create your own measure calculation.
I actually am doing that instead. That's good to know about the import from cube and freezing results though.
So My Measures for DSO and Previous Year DSO are spot on for each month, Product level etc... its the correct formula.
However when I try to break out that DSO Measure to Accrued DSO only I get errors and blanks.
Applying Filters like
Calculate('DSO_Table[DSO_Measure], Filter('DSO_Table,[Account] IN {"Allowances", Accounts Received"}))
This is returning blank results for me when I try to filter the DSO measure by that Account field. In an Excel Pivot I am able to get those results no problem.....
