Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ASO MDX member formula - Unable to suppress 0 in SmartView

in Planning 3 comments

Summary:

We have hierarchy that contains a member with a formula. A parent member of the member formula is in Columns. When we turn on suppress rows (Missing & 0) and drill on another dimension in rows, it does not suppress (all) of the rows with 0

How can we enable row suppress with member formula?

Content (please ensure you mask any confidential information):

We seem to be able to use suppress rows if we use NONEMPTYTUPLE in the member formula, however the drill down performance is very slow vs w/o NONEMPTYTUPLE

Version (include the version you are using, if applicable):

Service:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!