Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

HFM Rules : How to pull fx rate present in a different Scenario?

edited Dec 23, 2015 11:19AM in Hyperion Financial Management (HFM) (MOSC) 5 commentsAnswered

Dear Experts,

I have a requirement where in I will have to pull AVGRate present in Budget scenario and use this rate to translate accounts with Actual as pov scenario. I have tried using HS.Getcell and HS.GetRate but both of the functions are not giving the output that is expected.

AVGBUD_Rate = ""

AVGBUD_Rate = HS.GetCell ("A#AVGRate.E#[None].I#[ICP None].V#[None].Department#"& ENT_CURR &".BusinessStream#USD.Product#[None].RFActivity#[None].SourceType#[None].S#Budget")

Above line is not pulling AvgRate present in Budget Scenario. Its pulling AvgRate present in Actual Scenario.

AVGBUD_Rate = HS.GetRate ("S#Budget.E#[None].V#[None].Department#"& ENT_CURR &".BusinessStream#USD.Product#[None].RFActivity#[None].SourceType#[None].A#AVGRate")

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