Same cube in different applications

Post Reply
IBERGA
Posts: 3
Joined: Thu Jan 10, 2013 11:36 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Same cube in different applications

Post by IBERGA »

Hello

I'm new in this forum.

I'm working with tm1 version 10.1.1 and I have a question.

I want to create two applications but with same cubes but different approval hierarchy.

Is it possible?

Thanks

Regards
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Same cube in different applications

Post by jim wood »

Yes this is possible but you'll either have to maintain the cubes seperately. Why don't you just have both cubes in the same application with different names? That way you are only maintaining the shared dimensions once.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
IBERGA
Posts: 3
Joined: Thu Jan 10, 2013 11:36 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Re: Same cube in different applications

Post by IBERGA »

Thanks Jim,

But I need the same cube in different application

I have a application with 4 cubes, and these cubes must be in the other application but with other approval hierarchy because users aren't the same.

How can I do it?

Many Thanks

Regards
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Same cube in different applications

Post by tomok »

You can't because the approval hierarchy itself becomes a dimension in the cubes and you can't have two different approval hierarchies in one application.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: Same cube in different applications

Post by moby91 »

An approval hierarchy is a subset of a dimension.

The restriction is not on the subset level, but instead it is on the dimension level:
When a subset of a dimension has already been used as the approval hierarchy for an application, a different subset of the same dimension cannot be used as the approval hierarchy for another application. As the approval hierarchy of the other application you must use the subset of a different dimension.
IBERGA
Posts: 3
Joined: Thu Jan 10, 2013 11:36 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Re: Same cube in different applications

Post by IBERGA »

I have a same cube in two different applications, this cube has six dimensions.

One of the applications uses one subset of dimension as approval hierarchy , but in other application, I want to use other other subset of different dimension, as approval hierarchy.
The problem I have it, when in perfomance modeler when I go to deploy application, appears a warnig:
The view has an dimension that used as approval hierarchy in the other application, but this is because is the same cube in both applications.
I don't know, because I don't can't have two applications with the same cubes but different approval hierarchy...... :evil:
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Same cube in different applications

Post by tomok »

As has already been explained to you twice, you cannot use the same cube in two different applications. It's time to just accept that fact and figure out how you are going to deal with it. Either 1) explain to your boss that it can't be done or 2) explore the alternative of creating a second, almost identical cube, and port the numbers between the two cube with rules or TI.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply