Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I exclude some field names in a dimension. For example: I want to present a graph of a Region consist of Europe, North America, Oceania, Asia, Not Relevant and blanc. I want to exclude Not relevant and blanc. I solved this by the following formular:
Sum({<APG_REGION_NAME = {"Europe", "North America", "Oceania", "Asia"}>} MARKET_VALUE_APG_BASE)/1000000
But I want to know how to exclude the names Not Relevant and the blanc field
Thanks in advance
Best regards
Xandro
You already have solved this, right?
Sum({<APG_REGION_NAME = {'Europe', 'North America', 'Oceania', 'Asia}>} MARKET_VALUE_APG_BASE)/1000000
This isn't excluding Not Relevant and blanc?
Yes
But I was wandering if there was an alternative method to exclude the two.
Best regards
Xandro
Are you looking to exclude the fields completely from the data model? This can be done by commenting out the fields i.e //Not Relevant.
Hi,
Sum(({<APG_REGION_NAME -= {'Not Relevant'}>} MARKET_VALUE_APG_BASE)/1000000
Maybe this
Sum({<APG_REGION_NAME ={"*"}-{"Not Relevant"}>} MARKET_VALUE_APG_BASE)/1000000
There is this:
Sum({<APG_REGION_NAME -= {'Not Relevant', 'blanc'}>} MARKET_VALUE_APG_BASE)/1000000
or
Sum({<APG_REGION_NAME = e({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000
The field name Not Relavant and the blanc field name should be excluded from the dimension APG_REGION_NAME.
The field name Not Relevant can be excluded by the formular Sum({<APG_REGION_NAME -= {'Not Relevant'}. Now I am looking how to exclude the blanc field name. Is there a formular to exclude blanc field names.
Thanks in advance.
I found the solution with thanks to all of you. The correct answer is:
Sum({<APG_REGION_NAME -= {"Not Relevant", ""} >} MARKET_VALUE_APG_BASE)/1000000
Thanks again to all of you for your support.
Best regards
Xandro
Hi,
Sunny's second condition below should work :
Sum({<APG_REGION_NAME = E({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000
Only please ensure how the Blank is defined ' ' or Blank or blanc etc... how is it appearing in the source..
Thanks