Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for
Did you mean:
Creator III

## use dimensionality() in set analysis

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.

1 Solution

Accepted Solutions
Creator III

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.

10 Replies
Creator III
Author

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

Specialist

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

Creator III

what are you trying to achieve??

Creator III
Author

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

Partner - Contributor III

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.

MVP

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

Creator III

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.

MVP

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()

MVP