MS SQL Server OLAP - HOWTO: Hide values for a measure based on something else

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

HOWTO: Hide values for a measure based on something else

Christian Hamel

2005-08-22, 8:24 pm

Hello everyone,
I don't have much experience using Analysis Services (2KSP4) and I would
like to hide the value of a measure (zero it in fact) when the the user is
looking at the 5th & up period. Let me show an example:

Period MyMeasure OtherMeasure
2005-08-08 500 500
2005-08-15 600 500
2005-08-22 800 600
2005-08-29 500 700
2005-09-05 0 800
2005-09-12 0 900
2005-09-19 0 850
.....

How can I obtain such thing considering that MyMeaure is a calculation based
on 3 other measures? Any help would be greatly appreciated. Thanks.

Sponsored Links