Hi Expert,
I would like your help to confirm the below:
1, Zero Suppression doesn’t work if you use full MDX?
2, Is this possible to use calculated member in the dimension itself. It seems only work in FULL MDX
Thank you!
When using Full MDX you’ll need to handle the zero suppression in the query by using Non Empty statements.
Correct, calculated members, other than subset aggregation, needs to use full MDX mode.
If full MDX is used then Apliqo makes no attempt to parse the MDX into on columns, on rows and where sections and separately wrap or remove non empty statements.
If using this facility then how to handle zero suppression is up to the report author (without the zero suppression buttons as they have no effect)
Thank you all!