Page 1 of 1

Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 6:00 pm
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?

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 6:11 pm
by tomok
No, and that's not particular to Contributor, all views work that way.

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 6:40 pm
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.

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 9:51 pm
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.

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 9:57 pm
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?

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 10:01 pm
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.

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 10:44 pm
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.

Re: Contributor Stacked Dimensions

Posted: Wed Jan 02, 2013 10:54 pm
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.