Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
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
big_dreams
Creator III
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.

View solution in original post

10 Replies
kristof_j
Creator III
Creator III
Author

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

isingh30
Specialist
Specialist

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

big_dreams
Creator III
Creator III

what are you trying to achieve??

kristof_j
Creator III
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

annapochyla
Partner - Contributor III
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.

sunny_talwar

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

big_dreams
Creator III
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.

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.