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
Same cube in different applications
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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
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
-
- 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
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.
-
- 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
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.
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.
-
- 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
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......
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......

-
- 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
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.