TM1 Forum

Posted: **Thu Nov 28, 2013 11:06 am**

Hello, forumers.
I got a problem with saving view with two dimension dynamic subset. MDX expression is

{filter ({tm1subsetall ([Dyn_dimA])}, [Dyn_dimA].[test1] = [Dyn_dimB].[test1])}

I need to filter one dimension by correspondance with another dimension in context. In this case choosing context dimension element will lead to update dynamic subset. Filtering is based on text attributes named 'test1' of two dimensions Dyn_dimA and Dyn_dimB.
Works fine.

In my cube there are four dimensions Dyn_dimA, Dyn_dimB, Dyn_dimC, Dyn_dimD. Two last are dummy dimensions with several simple elements.

When I try to save a view where dynamic subset is placed in context, I got error. But I already have got such view (dynamic subset in context) in another model without any issue.

What may be the reason? I'm admin in the model.

Posted: **Thu Nov 28, 2013 12:16 pm**

deleted and added elements of dimension Dyn dim B (B1,B2...) and all worked

wtf?

Posted: **Fri Nov 29, 2013 7:31 am**

Hello, community.

Could anyone confirm or refute the following idea:

(lets define driver as dimension that drives filtering)

It is not possible to save a view where three conditions obtained:
1) MDX filtering

Code: Select all

{filter ({tm1subsetall ([a])}, [a].[test1] = [1].[test1])}

2) Dimension with dyn.sub. is placed in context
3) The value of default driver equals to the value of the first element of the driving dimension and no other elements.

The example dimensions are:
(pic)

TM1 Forum

No read access to elements, cannot view

No read access to elements, cannot view

Re: No read access to elements, cannot view

Re: No read access to elements, cannot view