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
TM1 application validation error on approval hierarchy
- PavoGa
- MVP
- Posts: 622
- 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: Charleston, Tennessee
Re: TM1 application validation error on approval hierarchy
To list the elements of an element something like the following is a simple approach in a TI:
Can also be done with MDX in a subset editor, but this is basic "meet the parents" code.
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;
Ty
Cleveland, TN
Cleveland, TN