Contributor Stacked Dimensions
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Contributor Stacked Dimensions
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?
-
- 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
No, and that's not particular to Contributor, all views work that way.
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Re: Contributor Stacked Dimensions
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.
-
- 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
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.
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.
-
- 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
No, and that's not particular to Contributor, all views work that way. Do you want to ask again?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.
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Re: Contributor Stacked Dimensions
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.
-
- 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
Yes it is.cdhodge2002 wrote:An asymmetric view is not what I am looking for
(Which puts it as well or better than I've ever seen it put.)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.
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Re: Contributor Stacked Dimensions
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.