Page 1 of 1

view - no read access to elements

Posted: Thu Sep 04, 2008 2:03 pm
by 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?

Re: view out of memory

Posted: Thu Sep 04, 2008 2:32 pm
by 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

Re: view out of memory

Posted: Thu Sep 04, 2008 4:16 pm
by 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,

Re: view - no read access to elements

Posted: Thu Sep 18, 2008 4:28 pm
by 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?

Re: view - no read access to elements

Posted: Thu Sep 18, 2008 6:30 pm
by Alan Kirk
ssp wrote: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.

Re: view - no read access to elements

Posted: Fri Sep 19, 2008 7:07 am
by 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.