Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- Find Partners
- For Partners
losing headcounts while using some columns in parameter FDI - Workforce Core
Hello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core.
below an example when I use this paramater, I get the right headcounts number 2K :
Case @parameter("param")('') when
'Business Unit' then "HCM - Workforce Core"."Business Unit"."Business Unit Name"
when 'Educ' then "HCM - Workforce Core"."Education"."Highest Education Degree Code"
else null
end
but while I use this one, my headcounts got reduced to only 500 which is the wrong number :
Case @parameter("param")('') when
'Business Unit' then "HCM - Workforce Core"."Business Unit"."Business Unit Name"
when 'Educ' then "HCM - Workforce Core"."Education"."Highest Education Degree Name"
else null
end
do you have any idea, why we have this kind of issue ?
Answers
-
As per your question, i am able to see both case statements are same? can you share me which formula is giving an wrong result?
Regards
Arjun
1 -
Thank you @Mallikarjuna Kuppauru-Oracle for the heads-up here is the formula that is giving the wrong result :
Case @parameter("param")('') when
'Business Unit' then "HCM - Workforce Core"."Business Unit"."Business Unit Name"
when 'Educ' then "HCM - Workforce Core"."Education"."Highest Education Degree Name"
else null
endThank you so much,
Ayoub
0
