Cube View Corruption

[shinymcshires]

Fellow Forum Members:

First, the particulars:

Excel version is 2003 (11.8320.8221) SP3

TM1 version is 9.0 SP3 (Build 9.0.3.173)

I have a budget input template that is comprised of four different cube views; one view for each view expansion. For the past three days, the view expansions and cube views have been working fine when I initially published them (we use OLAPObjects). The next day, I noticed that the published web page does not expand on any of the four view expand ranges. Based on previous experience, this usually means that the view that the expansion is based on has been corrupted somehow, and I simply need to rebuild it. This may have happened once in a blue moon in the past, but it has been happening for the past three days, and I am not sure what is causing the views to be corrupted. When I attempt to view the offending view, I get the "No Values" error message, then I am taken to a cube view with no values. If I attempt to change any of the dims, I get a "No Read Access" error message. These three symptoms are the signs of a corrupted view, from my experience. Today I made sure that each subnm was saved as a public subset, just in the event that might be the problem. Just to give you an idea of how the page is set up, I have attached the xls template. If need be, I can attach any other files if it will help. Once again, I appreciate your time and any suggestions you may have for me. Thank you.

[Steve Rowe]

Hi Shiny,
What may be happenining is the following.
You have a view defined using subsets.
The subsets are being emptied (i.e. all the elements are removed from subsest).
This means the view no longer works since the subsets are empty and there's no information to display.

So how to the subsets become empty?
The most likely explanation is that you have a dimension build TI that DImensionDeleteAllElements in it. If you delete all the elements in a dimension this will wreck all the subsets even if all the elements are back in the dimension before the TI ends. So check if it's subsets the view refers to that are the problem, rather than the view definition itself.
A good way of reviewing a view without the server getting in the way is to use the right click, Export as Ascii menu option, this will let you see how the view is defined in a more "direct" way.
HTH
Cheers

[habibullah.sayyed]

Hi Shiny,
What may be happenining is the following.
You have a view defined using subsets.
The subsets are being emptied (i.e. all the elements are removed from subsest).
This means the view no longer works since the subsets are empty and there's no information to display.

So how to the subsets become empty?
The most likely explanation is that you have a dimension build TI that DImensionDeleteAllElements in it. If you delete all the elements in a dimension this will wreck all the subsets even if all the elements are back in the dimension before the TI ends. So check if it's subsets the view refers to that are the problem, rather than the view definition itself.
A good way of reviewing a view without the server getting in the way is to use the right click, Export as Ascii menu option, this will let you see how the view is defined in a more "direct" way.
HTH
Cheers

Thanks this really helped me in gaining knowledge.
And as you told(which i have don bold and underlined above), how to do that?

[Steve Rowe]

Hi, this refers to the Perspectives server explorer, on of the older clients. The PA for Excel client does no include this functionality (sadly) though I believe something similar is available from the export option in PAW.

I think you can interrogate the contents of a view in PA for Excel by navigation in the object pane, if drill down in the view eventually you will get to the subsets and their definition.