Contributor Stacked Dimensions

Post Reply
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Contributor Stacked Dimensions

Post by cdhodge2002 »

Was wondering if the following is possible. I have 2 dimensions that are stack in the rows of a contributor view, Department and GL account. Our client is complaining that when they expand on a Consolidation in the GL account dim, like revenue, and expand that to see account level detail revenue then expands for all of the departments that are in the view. They would like to have the expansion only occur on the department/GL account combination they choose to expand on. Is there a setting for this?
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: Contributor Stacked Dimensions

Post by tomok »

No, and that's not particular to Contributor, all views work that way.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Re: Contributor Stacked Dimensions

Post by cdhodge2002 »

I understand that, but is there a way to not have the dimension expends for every element on the other stacked dimension. I have been looking around and have not found anything.
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Contributor Stacked Dimensions

Post by mvaspal »

Hi

If you search this forum for 'Asymmetric views', you can find a few threads that cover this topic. However, Tomok is right about that this is the expected behaviour of standard views in TM1.
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: Contributor Stacked Dimensions

Post by tomok »

cdhodge2002 wrote:I understand that, but is there a way to not have the dimension expends for every element on the other stacked dimension. I have been looking around and have not found anything.
No, and that's not particular to Contributor, all views work that way. Do you want to ask again?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Re: Contributor Stacked Dimensions

Post by cdhodge2002 »

An asymmetric view is not what I am looking for, and I do understand this is typical TM1 functionality. I do not believe what my client is asking for is possible. So to just be more clear and to expand on my example. Dept and GL accounts are stacked in the rows. A consolidated element called revenue from the GL accounts dimension is showing in every department, what my client would like is for when they expand Revenue for Revenue not to expand under every dept, just the dept they want to expand. And again this is in Contributor.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Contributor Stacked Dimensions

Post by Alan Kirk »

cdhodge2002 wrote:An asymmetric view is not what I am looking for
Yes it is.
rmackenzie wrote:An asymmetric view is where you can pick and choose which elements in dimension 2 show up against dimension 1 when they are nested on rows, or columns for that matter.
(Which puts it as well or better than I've ever seen it put.)

The answers in that thread also apply here.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
cdhodge2002
Posts: 90
Joined: Tue Aug 19, 2008 4:56 pm

Re: Contributor Stacked Dimensions

Post by cdhodge2002 »

So basically the answer is no it is not possible in the cube viewer/contributor world that I live in currently. It would be in Active Form but we are currently not using 10 and need the cell to be enter able. Thank you for the information.
Post Reply