Can Parameter values be used in custom calculations?

Caroline Blanchard · Mar 13, 2024 8:59PM

We would like to create a custom calculation that filters a measure by the year number in a parameter.

This parameter will enable us to see data in the ending balance of previous years.

We set up our Fiscal Year parameter in the image above.

The calculation validates, however it does not return the proper values. Any advice or input on this topic would be very much appreciated.

Raghavendra Raghunath-Oracle · Mar 14, 2024 9:43AM

Hi @CarolineAnderson @Mallikarjuna Kuppauru-Oracle I had a similar calculation built in HCM and it does work. I also validated it against the seeded headcount metric with year as filter. The formulas i had was as below

Current HC - IFNULL(FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM - Workforce Core"."Time"."Year" = @parameter("Period Year")(1111)) , 0)

Previous HC - IFNULL(FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM - Workforce Core"."Time"."Year" = (@parameter("Period Year")(1111)-1)) , 0)

The query for the parameter initial value was as below

Period Year - SELECT "HCM - Workforce Core"."Time"."Year" FROM "HCM - Workforce Core" WHERE (("Time"."Year" IN (YEAR(CURRENT_DATE))))

Raghu

BenjaminFusioh · Jul 24, 2014 11:54AM

Hi Kumaran,

That's what I'm trying to do. I tried to wrote query that returns this value but nothing works so far ... any ideas ?

regards,

Benjamin

AshishERPCloud · Jul 25, 2014 6:08AM

Hi,

Did you tried creating a seperate data set and use some query like Select :<xdo_var> as lang_session from dual ;

I tried for username and it works perfectly fine.

Gael Chevallier-4294 · Jul 30, 2014 11:34AM

Hi Benjamin,

If the translation you need is linked to stored data, did you try to use the language table(table name_TL) instead of the base table in your DM ?

Gael.

Gautam Basu-2248 · Aug 25, 2014 6:59PM

Hi Lisa,

You need to have the Administrators role. It will allow you to do it.

Thanks,

Gautam

Lisa Spence · Aug 25, 2014 7:09PM

Thanks Gautam.

I don't suppose you know the exact name of the role? "____ Administrator"? There are so many options.

Does this mean that the general HR user are unable to share templates among themselves?

Gautam Basu-2248 · Aug 25, 2014 7:16PM

/>

Hi Lisa ,

As you can see the name of the role is ADMINISTRATORS. I don't use the HCM application , I use SALES CLOUD , however I know it very well that OTBI is same for every application. You just need to map the role properly.

Thanks,

Gautam

User508102-Oracle · Aug 25, 2014 7:37PM

Hi Lisa,

You should be able to save the reports/analysis in Customer folder under shared. That's the only folder that users can save reports to other than My Folder.

Thanks

Venu

Gautam Basu-2248 · Aug 25, 2014 7:38PM

Hi Venu,

FYI , I have saved my analysis wherever i wanted to save. There is no such rule.

Thanks,

Gautam

Lisa Spence · Aug 25, 2014 7:46PM

Hi Venu,

That worked! Thank you. I'll have to dig deeper to see if there is an additional role required, but for the time being, I am able to post to the Custom folder.

Thanks everyone!

User508102-Oracle · Aug 25, 2014 7:50PM

Lisa,

If you save the reports under shared folders other than custom by getting an admin role, those reports can not be preserved during upgrades and will be over written. the only folder that is preserved during upgrades is the custom folder under shared.

Hope this helps.

Venu

Oracle Fusion Data Intelligence

Categories

Can Parameter values be used in custom calculations?

Best Answer

Answers