OBIEE Selection steps new group member not listed

Question

Hi everyone, this is my first post so if something is missing to be more relevant, just advise me.

Here is my problem.  In the selection steps, I try to create a new group but in my member list I cannot choose some members because they are not displayed in my list.

These members are from a calculated dimension with some nested Case When Then Else.  I tried to put first the "case when" that brings me the values that are missing in my member list but nothing changed.

If you check my dimension values below in the "case when" my values 'HGI - All' and 'HGI - All' are not displayed in the list to create a new group in selection steps.

What is the problem with OBIEE, how can I solve that?

Also, is it possible to manually type my value that I want instead of choosing from a list, those wizards sometimes are very frustating?

Here is the sample of my dimension having the "case when":

CASE WHEN "Company"."Company Number" = '00180' THEN ('HGI - All')

ELSE

(

CASE WHEN "Company"."Company Number" = '00170' THEN ('HGM - All')

ELSE

(

CASE WHEN "Company"."Company Number" = '00100'

THEN

(CASE WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 100' THEN 'HGA - Pétrole'

ELSE (CASE WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 200' THEN 'HGA - Lub'

ELSE (CASE WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 400' THEN 'HGA - Dép' ELSE ('HGA - Autres')

END)

ELSE

('Autre Société')

END

)

END

)

END

Thanks for your help,

Patrick

Patrick Gendron · Answer

Thanks Thomas for your help.

I know that your solution is the best even if it does not solve the mystery in selection steps, why it could not display all my 7 members !!!!!  It drives me crazy that kind of weird problems that should work!

Thomas Dodds · Answer

"don't think someone else will need it." - good luck!

This is not pollution of the RPD - it's logical manipulation of data which is the purpose and intent of the RPD.

As for 3 people sharing a single access to the RPD - this is development mismanagement -- not to mention risky.   I suggest setting up a MUD environment and that way you have a backup and all changes must check in successfully and the MUD Master RPD must be consistent before deployment to development server for IT testing, then it goes on to QA for User Testing, then finally out to Production for General Use.

having said that and going against my own better judgement:

Your case can easily be done in Answers using bins ...

col1 =

CASE WHEN  "Company"."Company Number" = '00100' AND RIGHT("Business Area"."Ligne d’affaire", 4) = ' 100' THEN 'HGA - Pétrole'

WHEN "Company"."Company Number" = '00100' AND RIGHT("Business Area"."Ligne d’affaire", 4) = ' 200' THEN 'HGA - Lub'

WHEN "Company"."Company Number" = '00100' AND RIGHT("Business Area"."Ligne d’affaire", 4) = ' 400' THEN 'HGA - Dép'

WHEN "Company"."Company Number" = '00100' AND RIGHT("Business Area"."Ligne d’affaire", 4)  NOT IN ('100','200','400') THEN ('HGA - Autres')

WHEN "Company"."Company Number" = '00180' THEN ('HGI - All')

WHEN "Company"."Company Number" = '00170' THEN ('HGM - All')

ELSE

('Autre Société')

END

Patrick Gendron · Answer

You are right that should work but I don't have access yet to the RPD (we have one access for 3 person) and it is for a very specific usage of one chart and don't think someone else will need it.

Is there another way to achieve it and not to make pollution in the RPD for something very specific?

Thanks,

Patrick