Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

How to determine all current dimension members in HFM 11.1.2.1 Classic mode script execution?

edited May 8, 2017 5:00AM in Hyperion Financial Management (HFM) (MOSC) 7 commentsAnswered

I have some VB procedure in HFM 11.1.2.1 Classic mode application script:

SUB Calc_BS_CB(parMembers)

With HS

  If parMembers <> "" Then

  If Left(parMembers, 1) <> "." Then

   parMembers = "." & parMembers

  End If

End If

Global_POV = "C3#Calc_Bal" & parMembers

Set varDataUnit = .OpenDataUnit(Global_POV)

For i = 0 To varDataUnit.GetNumItems - 1

  Call varDataUnit.GetItem(i, varAcc, varICP, varC1, varC2, varC3, varC4, varData)

  varPOV = ".A#" & varAcc & ".I#" & varICP & ".C1#" & varC1 & ".C2#" & varC2 & ".C4#" & varC4

    .Exp "C3#Closing" & varPOV & " = C3#Opening + C3#Movement"

Next

  End With

END SUB

I want to know values of C3#Opening and C3#Movement in each iteration of the loop. I can use WriteToFile and HS.GetCell() but HS.Member method supports not all dimensions of HFM. I can GetCell() for C3#Closing because it's POV fully determined, but I can't do this for C3#Opening and C#Movement because I don't know their full POV.

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