Suppress active form based only on first of 2 row dimensions

[bunchukokoy]

Hi Guys,

May I just ask this. I have two row dimensions. One is store, one is date. What I want my active form to behave like is that it will suppress zeroes based on stores, one measure, and the first date of five dates in the date dimension. This date dimension is a subset always containing 5 elements. But I just want the remaining four elements to be the details (getting from another measure) for past four days. See attachment.

In the active form, I don't want the four dates be hidden because of suppression.

Thanks.

[mattgoff]

Here's what I read, am I correct?

• If a store has a value in the first day in the first measure, show store and all five dates (even if values for the other four dates are zero).
• If a store does not have a value in the first date in the first measure, do not show store at all.

If so, I believe you can do this with the following:

• Use an MDX query in the Store TM1RPTROW function which filters based on value in the store/firstday tuple.
• Disable zero suppress in TM1RPTVIEW. This will force all five dates to display even if value of measure is zero (you'll be getting your zero suppress functionality via the MDX in the last bullet).

Matt

[bunchukokoy]

Thanks Sir Matt. Bloody MDX. .

Great idea. It works nicely.