Hiding Values - Analysis Services

Learn Microsoft BI Forum Core Servers Analysis Servic... Hiding Values

4/29/2009 8:32 PM

	Qazafi
51 posts

Hiding Values

Hello All

Is there any way so that I can hide my calculated member values if it is =0 to my users

Let example I have values

Job # Months

March

JOb 1 $600

Job 2 $500

Job 3 0

Job 4 $800

Job 5 0

what I would like to have just want to hide those values where it is =0 to my user who are using Excel 2007 to connect to my cube

Please help me if you have any work around.

Many Thanks

Qazafi

5/3/2009 7:32 PM

	cutley
363 posts

Re: Hiding Values

Can you set zero values to NULL and have the users set the NON EMPTY option?

5/4/2009 6:48 PM

	Qazafi
51 posts

Re: Hiding Values

Hi Cutley

I have done this way and It work 100% what I expect. Thanks for your help

iif

(sum(periodsToDate([Dimension FINANCIAL PERIODS].[Years-Month Structure].[Financial Year],[Dimension FINANCIAL PERIODS].[Years-Month Structure].CurrentMember),CoalesceEmpty([Period Actual],0)+CoalesceEmpty([Measures].[Opening Bal],0))<>0,sum(periodsToDate([Dimension FINANCIAL PERIODS].[Years-Month Structure].[Financial Year],[Dimension FINANCIAL PERIODS].[Years-Month Structure].CurrentMember),CoalesceEmpty([Period Actual],0)+CoalesceEmpty([Measures].[Opening Bal],0)),Null

)

Regards

Qazafi

Page 1 of 1

Learn Microsoft BI Forum

Core Servers

Analysis Servic...

Hiding Values