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 |