dbTalk Databases Forums  

How to suppress empty value in business scorecard

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


Discuss How to suppress empty value in business scorecard in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
basant.kapri@gmail.com
 
Posts: n/a

Default How to suppress empty value in business scorecard - 03-13-2006 , 01:32 AM






Hi

Please let me know how to supress empty value in business scorecard .I
am using OLAP cube as datasource.

I have checked There is no option to supress empty value in scorecard
view or in KPI(Business Scorecard).Is there amything can be done using
MDX query.

I have my data like this

Measure : Sale
Dimention : SalesExecutive
Dimention: Sale Month
Dimention: Team

When ever I select any team all SaleExecutive get displayed (Team
member with Values and Non team Member without Value)

Same thing happen if I select Month If salesExecutive joined in Febuary
and there is no sale in january but still if I select Sale Month as
January it shows these salesExecutive values with blank values.

Please suggest in this situation.

Thanks
Basant


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.