dbTalk Databases Forums  

HOWTO: Hide values for a measure based on something else

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss HOWTO: Hide values for a measure based on something else in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christian Hamel
 
Posts: n/a

Default HOWTO: Hide values for a measure based on something else - 08-22-2005 , 02:48 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.