view - no read access to elements

[ssp]

After re-loading all my dimension elements and loading my data the following error occurs when opening the cube. I have a feeling it is to do with a previously saved default view. However, does this mean all the default views created manually need to be recreated each time after the chores complete?

[Renaud MARTIAL]

Hello,

it looks like the user accessing this view doesn't have 'read' access upon any elements of a dimension (or subset) used for this view.
Thus, the resulting view is empty.

Check the security of elements used by this view.

(BTW, it is not a 'view out of memory' error)

Regards,

Renaud

[Steve Rowe]

This can also happen if you manage to manipulate the referenced subsets of the view such that they are actually empty (as opposed to appearing empty to the user which is the security issue mentioned above).

So if your view references a specific element and you delete that element from the system then you get the error message shown. If the view was saved referencing a subset which is now empty you can recover from it by re-saving the subset with an element(s).
If it was saved just referencing a specific element then I don't think you have any choice but to delete and re-build the view.

You should not suffer from this issue every time you run your chores, only when you delete elements that the view refers to. This normally doesn't happen too often.

HTH

Cheers,

[ssp]

IF I create dynamic subsets and assign to a view, which reference elements based on certain criteria (MDX based), this shouldn't happen either right?

[Alan Kirk]

IF I create dynamic subsets and assign to a view, which reference elements based on certain criteria (MDX based), this shouldn't happen either right?

I suspect the same thing as Steve; and yes, an MDX subset should work as well as long as it will always return AT LEAST one element.

[jim wood]

Guys,

I experienced something similar after updating a dimension. As it turned out, the update I completed seemed to have put the dimension out. Upon setting the dimensino order to automatic the issue went away. Very strange,

Jim.