Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Selection steps new group member not listed
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)
END)
END)
ELSE
('Autre Société')
END
)
END
)
END
Thanks for your help,
Patrick
Answers
-
I tried to simplify my expression with no success.
Simplified expression for my dimension:
CASE WHEN "Company"."Company Number" = '00180' THEN ('HGI - All')
WHEN "Company"."Company Number" = '00170' THEN ('HGM - All')
WHEN "Company"."Company Number" = '00100'
THEN
(CASE WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 100' THEN 'HGA - Pétrole'
WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 200' THEN 'HGA - Lub'
WHEN RIGHT("Business Area"."Ligne d’affaire", 4) = ' 400' THEN 'HGA - Dép' ELSE ('HGA - Autres')
END)
ELSE
('Autre Société')
END
Please help,
Patrick
0 -
Why not build a logical column in the RPD that achieves this? Build once -- use many.
0 -
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
0 -
"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
0 -
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!
0