Contributor Approval Hierarchy 9.5.2

Post Reply
rfielden
Posts: 122
Joined: Wed Aug 06, 2008 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: Tega Cay, SC

Contributor Approval Hierarchy 9.5.2

Post by rfielden »

I am trying to create my first application in Contributor and having an issue assigning a valid subset.

Overall structure is:

Total (cons element)
Admin (cons element)
Dept 1
Dept 2
Dept 3
Devel (cons element)
Dept 4
Dept 5
Dept 6

I have tried to associate with Admin and Devel levels (consolidated), I get:
ERROR - The hierarchy includes consolidated members but excludes their children.

If I try to load the subset:
Devel (cons element)
Dept 4
Dept 5
Dept 6
ERROR - The hierarchy has more than one top level member.

If you try and just load the n elements:
ERROR - The hierarchy has more than one top level member.

Can anyone shed some light where I am going wrong?
rfielden
Posts: 122
Joined: Wed Aug 06, 2008 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: Tega Cay, SC

Re: Contributor Approval Hierarchy 9.5.2

Post by rfielden »

OK I have resolved. I had to create unique consolidated element not associated under any other parent. When saving it stated associated security will be lost. Is there anyway to create the approval hierarchy under the current dimension structures without having to update security?
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Contributor Approval Hierarchy 9.5.2

Post by Martin Ryan »

Yes, with Contributor your approval hierarchy must have one, clean hierarchy. No multiple parents.

No, you cannot retain TM1 security in the dimension of your approval hierarchy. Contributor over-rides the security on this dimension. All the other dimensions have TM1 security applied to them though.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
rfielden
Posts: 122
Joined: Wed Aug 06, 2008 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: Tega Cay, SC

Re: Contributor Approval Hierarchy 9.5.2

Post by rfielden »

Martin, thank you for the confirmation. We are 'under way', so far so good.
Post Reply