Dynamic subset based on current cube view

[pmakulski]

Can a dynamic subset be set up to react to what is currently being looked at in the cube view?

What I have is a dimension (A) where only some of the elements are relevant to an item in another dimension (B).
So, when the cube user is looking at Element B1 they see only A1 A2 and A3
but when they are looking at B2 they see only A7 and A8.

Zero supress almost dopes the job, but I want to show these (A) items even if they are zero, because I want the user to input to this intersect.

Other ideas welcome
9.5.2

[jim wood]

Wouldn't supress zero's do this if you setup the view correctly?

[jim wood]

Apologies I didn't see the supress zero bit. Consider my hand slapped. The other option I can think of is using the filter by view extract in the subset editor. How is the user going to view this? You could do some good subset selection stuff in excel,

Jim.

[Solanna]

Have you tried suppressing only on Columns or Rows?

You can find this functionality within the Cube Viewer under the Options Menu
On many occasions it can solve the issue you have stated

A possible workaround would be to use Element Attributes
Element Attributes are designed in order to manage one to one relationships
So if your dimensions have a static relationship you could build your view so that the user will select the appropriate attribute to get the view needed

For example, for A1, A2, and A3 you would set the "B" text attribute to B1, and for A7 and A8 you would set it to B2
Certainly the concept is a bit manual and there isn't an automatic association with the two dimensions but it will at least give you some thought

Other than that, due to the multi-dimensional nature of TM1 where every dimension in a cube relates to every other dimension in that cube, I can't think of any out of the box functionality that will provide for your requirements

Solanna