Approval Hierarchy Move From 10.1.1 to 10.2

Post Reply
tgaluskapatterson
Posts: 31
Joined: Thu Apr 25, 2013 1:36 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Approval Hierarchy Move From 10.1.1 to 10.2

Post by tgaluskapatterson »

Using Win 7 on the new TM1 10.2

I started playing with the new 10.2 today and tried to import my old approval hierarchy via performance modeler from 10.1.1 in 10.2.

I received the following error "The approval hierarchy has members missing below the top level member." when attempting to validate in the new 10.2

The approval hierarchy looks clean. I checked to make sure it mirrors what was in 10.1.1.

Could my issue be group or security related?

Any ideas on what my problem could be?
overflow
Posts: 22
Joined: Wed Jan 21, 2009 1:24 am
OLAP Product: TM1
Version: 10.2 9.4 10.1
Excel Version: 2013 2010
Location: Melbourne Australia

Re: Approval Hierarchy Move From 10.1.1 to 10.2

Post by overflow »

Hi tgaluskapatterson

Have you checked that the subset used as the approval hierarchy is fully expanded at the level you wish to use?

I have found this to be an issue also.

Kind Regards
overflow
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: Approval Hierarchy Move From 10.1.1 to 10.2

Post by sander »

I have seen this also, You cant have an 'incomplete' Hierarchy anymore as approval hierarchy.

For Example, the complete hierarchy;
All Salespersons
-Sales A
-Sales B
-Sales C
-Sales D

If you want the following hierachy as the approval
All Salespersons
-Sales A
-Sales B

That is not possible anymore in 10.2. What you can do is make a second Hierarchy and use that as the approval Hierarchy;

All Salespersons (Division X)
-Sales A
-Sales B

Regards Sander
pandinus
Posts: 78
Joined: Tue Mar 18, 2014 8:02 am
OLAP Product: TM1, Cognos Express
Version: 10.2.2
Excel Version: 2013

Re: Approval Hierarchy Move From 10.1.1 to 10.2

Post by pandinus »

Please note that you get this exact same message when you have an hierarchy in your dimension and set your approval subset using subsetisallset(vdim, vsub, 1).
Now when you have an element which is listed in the hierarchy twice the validation of the application will fail! Remove the double parent and you are good to go.
Post Reply