Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jc17
Partner - Contributor II
Partner - Contributor II

'Ignore' selections in Master Dimension in Set Analysis

Hi everyone,

I have a master dimension in my app and I want to ignore possible selections in this master dimension for a measure with Set Analysis. It is not valid to use 'Dimension_name=' in Set Analysis as this is a master dimension. Is there any way to achieve this?

Thank you in advance

Labels (5)
6 Replies
Taoufiq_Zarra

@jc17  if I understood correctly

to ignore selection add 1 to your set analysis like sum({1<...> MEASURE)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
jc17
Partner - Contributor II
Partner - Contributor II
Author

Thank you for your help. If I use what you say, filters in other fields will not be taken into account, and I only need to ignore filters in this master dimension

agigliotti
Partner - Champion
Partner - Champion

Hi @jc17 ,

What's the field name linked to the master dimension?

jc17
Partner - Contributor II
Partner - Contributor II
Author

The name is 'Week'

agigliotti
Partner - Champion
Partner - Champion

What about the below expression:

sum( {< Week= > MEASURE )

?

Andrei_Faibich
Contributor III
Contributor III

It doesn't work, I have the same issue.