asked on January 4, 2020
Hi Team,
There are some calculated measures in our cube, for example, "Total Amount" that is equal to ("Invoice Amount" + "Taxes"), when we select grand total option in the flexmonster then grand total for "Invoice Amount" and "Taxes" gets displayed but does not display for "Total Amount", please suggest how grand total of "Total Amount" can be displayed.
Thanks
Nagaraj
⋅ January 8, 2020
Hello Nagaraj,
Thank you for your question.
When working with SSAS cube, Flexmonster generates the data queries and sends them to the cube. The received data is displayed in the Pivot Table.
It seems that the necessary "Total Amount" data is not returned from the cube. That is why it is not displayed.
Could you please provide us with the small dump of your cube where the issue is reproducible? It will help us a lot in our further investigation.
Regards,
Dmytro
