1 Reply Latest reply: Sep 10, 2012 8:10 PM by 941732 RSS

    Dynamic Entity Member Lists using UD1 and UD2

    961200
      Hello fellow HFM gurus:


      I have created dynamic member lists to get all members of the entity dimension that have a UD1 or UD2 member as specified in the script.

      THe member lists all appear in HFM, but when I try to select them, I get a run-time error. I am trying to select them in the member selection of a data form (in the same drop down with the different system member lists for entiites, like hierarchy, descendants, etc.).

      I believe this is the standard syntax. Please let me know if something is wrong with it.

      ElseIf HS.Dimension = "Entity" Then

      If HS.MemberListID = 1 Then
      ELi=Hs.Entity.List(",")
      For i = Lbound(ELi) to Ubound(ELi)
      If HS.Entity.IsBase("",ELi(i)) = TRUE Then
      If (StrComp(Hs.Entity.UD1(ELi(i)),"DD",vbTextCompare)=0) Then
      Hs.AddEntityToList "",ELi(i)     
      End If
      End If     
      Next
      End if     

      Error in HFM:
      Invalid member selection. Error executing VBScript Microsoft VBScript runtime error, Line 475:Wrong number of arguments or invalid property assignment: 'HS.Entity.List'.Error executing VBScript 0.Error Reference Number: {9A7697E2-75AE-4A06-9A34-B45D58022984};User Name: mark.d.smith@Native DirectoryNum: 0x80042fc2;Type: 1;DTime: 9/10/2012 5:51:16 PM;Svr: VMHODDLPHP4;File: CHsvScriptEngine.cpp;Line: 392;Ver: 11.1.2.1.103.3505;Num: 0x80042fc2;Type: 0;DTime: 9/10/2012 5:51:16 PM;Svr: VMHODDLPHP4;File: CHsvDSMemberLists.cpp;Line: 2722;Ver: 11.1.2.1.103.3505;Num: 0x80042fc2;Type: 0;DTime: 9/10/2012 5:51:16 PM;Svr: VMHODDLPHP4;File: CommonMetadataInternal.cpp;Line: 461;Ver: 11.1.2.1.103.3505;Num: 0x80042fc2;Type: 0;DTime: 9/10/2012 5:51:16 PM;Svr: VMHODDLPHP4;File: CHsvEntities.cpp;Line: 338;Ver: 11.1.2.1.103.3505;Num: 0x80042fc2;Type: 1;DTime: 9/10/2012 5:51:16 PM;Svr: VMHODDLPHP4;File: CCommonDimension.cpp;Line: 1015;Ver: 11.1.2.1.103.3505;