Set Analysis,Variable and Dimensionality

[#1]

Hi,

I have created variables as

  Sales as   sum({$<Type ={'Domestic'} >} sales)

And I have loaded in to the variables through the load script.

And i am trying to use this as expression in the Pivot table as below

    = If( Dimensionality()=1, Pname='A' ,$(=Sales),'NA')

It is not showing any values how ever if i am trying to call the variable in the list box. It is showing the correct value.

   $(=Sales)

  Also when i tried to dimensionality in the set analaysis. i am getting the error.

            sum({$<Dimensionality()=1,Type ={'Domestic'} >} sales)

Anyone has faced the similar issues? 

[lironbaram]

hei

i think you sintax error in your first expression it should be

= If( Dimensionality()=1 AND  Pname='A' ,$(=Sales),'NA')

as for tring to use dimensionality in set analysis you cant as set analysis is to make selection

hope its helps you

[#3]

Hi,

  I am not getting the value without using the dimensionality as well, i tried this way as well

   = If( Pname='A' ,$(=Sales),'NA')

Any suggestions

[lironbaram]

try = If( Dimensionality()=1 AND  Pname='A' ,$(Sales),'NA')

[#5]

Can you post the qvw? That can help debugging better.

Regards,

Kiran

[#6]

Thanks for all your responses ,

I have fixed it. It was data issue