use dimensionality() in set analysis

[kristof_j]

hi

is it possible to use the dimensionality() function in a set analysis? And how?

something like

sum( {<level = { $(=dimensionality()) }>} sales)

but this doesn't seem to work.

[kristof_j]

So the dimensionality() could be different on each row of the pivot table.

[isingh30]

It's not an ideal thing. What's your requirement?

[big_dreams]

what are you trying to achieve??

[kristof_j]

Idd it's not ideal. But is it possible?

It is nice to know, regardless of what I want to achieve with it.

I'm going to post the real question but I'm not going to mention this post

I want to see your creative minds

[annapochyla]

Hi,

Sets in set analysis are created 'independent' of the table they are used in.

that is why you cannot use for example dimension values in set analysis.

And that could be the reason, why you cannot use dimensionality() in set analysis.

[sunny_talwar]

AFAIK, I don't think this would be possible to do

[big_dreams · Accepted solution]

hmm actually it is interesting,

You can not use ddimensionality() in set analysis but you can use it in if else statement.

Regards,

Edit : forgot to type not.

[Colin-Albert]

Hi Kristof,

It is not possible to use dimensionality() in your set expression. 

This is because the set is evaluated for the chart data as a whole and is not evaluated row-by-row.

Dimensionality is row dependent  so cannot be used in the set expression.

You can use dimensionality in an "if" statement.

      for example     if(dimensionality() > 2, sum(sales))

This post on Dimensionality may help  How to use - Dimensionality()

[MarcoWedel]

please post some sample data and your expected result.