Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

How to use HS.CalculateRate

edited Feb 1, 2023 1:32PM in Hyperion Financial Management (HFM) (MOSC) 6 commentsAnswered

Hello everyone,

I'm stuck on something, possibly someone can help me.

I want to do a calculation where for each base entity the corresponding FX rate should be used as multiplier. This is how the code looks like:

      If HS.Entity.IsBase("", "") = "True" and HS.Value.Member = "<Entity Currency>" Then

         FXEnt=HS.Entity.Member         

         FXRate = HS.CalculateRate ("S#ACT", "Y#CUR", "P#CUR", FxEnt, "V#<Entity Currency>", "A#EOMRate")

   HS.Exp "A#Target= A#Source*1500*" & FXRate &""

      End If

I am getting error message. "(" missing. What am I doing wrong? Does Hs.CalculateRate expect other input variables?

Thanks a lot in advance!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center