I have a virtual cube that has a dimension ([Account]) for who the
corresponding Measure([Measures].[Expense]) value is empty except for

[All Account], so data displayed is like this





[Expense]

[All Account ] 50000

abc1

abc2

abc3

abc4



for all member that expense is empty.

Now I need to assign the same value 50000 that belongs to all account
to all empty cells , how can i do it ?



Please help

Thank you

Nilesh Shrestha


--
Posted via http://dbforums.com

"nileshshrestha" <member38516 (AT) dbforums (DOT) com> wrote

If the measure Expense is coming from the real cube which doesn't have
Account dimension, then the simplest would be to create new calculated
measure with expression ValidMeasure(Measures.[Expense]) and hide the
Expense measure.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================