How to determine all current dimension members in HFM 11.1.2.1 Classic mode script execution?
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.