No read access to elements, cannot view

[ioscat]

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

Code: Select all

{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.

[ioscat]

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

wtf?

[ioscat]

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)