TM1 application validation error on approval hierarchy

Post Reply
Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

TM1 application validation error on approval hierarchy

Post by Rtel » 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

User avatar
PavoGa
Community Contributor
Posts: 479
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: TM1 application validation error on approval hierarchy

Post by PavoGa » 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.
Ty
Cleveland, TN

Post Reply