Hello,

I want to display the Accounts and their Key value with the Measure SALES.
Like

"With Member [Measures].[Account Key] As
'[Account].CurrentMember.Properties("Key")'
Select Non Emopty({[Account].[Account Name].Members}) On Rows,
{[Measures].[Account Key], [Measures].[Sales]} On Columns
From Sales"

When I include the Measure [Account Key] on columns, the query displays the
empty cells also and if I don't include the measure [Account Key], I get the
cells having "Sales" value.

Please help me in eliminating the empty cells. Thanks in advance.

Manoj

You can force the text measure to be empty whenever the associated
[Sales] measure is empty:

'[Account].CurrentMember.Properties("Key")'
Member [Measures].[Account Key] As
'iif(IsEmpty([Measures].[Sales]), NULL,
[Measures].[AccountKeyText])'

Select Non Emopty({[Account].[Account Name].Members}) On Rows,
{[Measures].[Account Key], [Measures].[Sales]} On Columns
From Sales

For an explanation of why a second measure is needed:

http://groups.google.com/groups?hl=e...HA.2216%40TK2M
SFTNGP10.phx.gbl


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!