TM1 Forum

Posted: **Mon Jan 04, 2021 3:35 am**

Hello, we have upgraded from TM1 10.2.2 to PA 2.0.9.2

After importing the data from Tm1 application in 10.2.2 to 2.0.9.2 when I validate the application I get following error

"One or more members of the approval hierarchy have multiple parents" --- and there is an element value provided (element 1234 - for e.g.).

When I searched for the element (1234) in the "approval hierarchy" subset I find 2 entries in the search.

In 10.2.2 TM1 application this same set up works just fine but I can't validate that in 2.0.9.2

Please let me know how do I proceed ? Also how can I find which two different parents this element is having ?

Thanks

Rtel

Posted: **Mon Jan 04, 2021 1:53 pm**

To list the elements of an element something like the following is a simple approach in a TI:

Code: Select all

dimApprovalHier = 'dimName';
sComponentElementName = 'MyChildElement';
sOutputFile = 'ListOfParents.txt';

nParents = ELPARN(dimApprovalHier, 
i = 1;
While (i <= nParents);
    sParent = ELPAR(dimApprovalHier, sComponentElementName, i);
    AsciiOutput(sOutputFile, sParent);
    i = i + 1;
END;

Can also be done with MDX in a subset editor, but this is basic "meet the parents" code.

TM1 Forum

TM1 application validation error on approval hierarchy

TM1 application validation error on approval hierarchy

Re: TM1 application validation error on approval hierarchy