Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
