How & why corrupted views of a cube is generated?

[habibullah.sayyed]

Hie everyone,
My query is about corrupted view of cube. Please explain it in as simple way as you can and in detail.
Thanking you in advance.

[gtonkin]

In my experience this happens when a view has been saved with static subsets or selected elements.
Someone then deletes these elements effectively returning a null set and the view breaks. Generally on the Default subsets as invalid subsets revert to Default and if Default is broken, cannot render.

There are probably other reasons but the above is probably a frequent occurrence for newer users who do not use MDX and delete elements rather than unwinding hierarchies etc.

[PavoGa]

In my experience this happens when a view has been saved with static subsets or selected elements.
Someone then deletes these elements effectively returning a null set and the view breaks.

There are probably other reasons but the above is probably a frequent occurrence for newer users who do not use MDX and delete elements rather than unwinding hierarchies etc.

This. We need a like button.

[lotsaram]

Hie everyone,
My query is about corrupted view of cube. Please explain it in as simple way as you can and in detail.
Thanking you in advance.

Define "corrupted".

[habibullah.sayyed]

In my experience this happens when a view has been saved with static subsets or selected elements.
Someone then deletes these elements effectively returning a null set and the view breaks.

There are probably other reasons but the above is probably a frequent occurrence for newer users who do not use MDX and delete elements rather than unwinding hierarchies etc.

Thank you so much, i understand the reason but you told about not using MDX and delete element. So how can we use to avoid this issue, will you please explain it with example cause I am new to this.
Thanks Again. Thank you so much for your time.

[habibullah.sayyed]

Hie everyone,
My query is about corrupted view of cube. Please explain it in as simple way as you can and in detail.
Thanking you in advance.

Define "corrupted".

The view does not open and shows view corrupted, and the name of view shows like this "1r_15A.Grinding Aid Usage %_c6109cee-c939-482d-95d3-00a17becc8ec_[}tp_tasks}c6109cee-c939-482d-95d3-00a17becc8ec].[N213 - 5001].CAMID(_Holcim_u_9149d87f5f2360489aadadc5f4631706_)" .

[orlando]

The view does not open and shows view corrupted, and the name of view shows like this "1r_15A.Grinding Aid Usage %_c6109cee-c939-482d-95d3-00a17becc8ec_[}tp_tasks}c6109cee-c939-482d-95d3-00a17becc8ec].[N213 - 5001].CAMID(_Holcim_u_9149d87f5f2360489aadadc5f4631706_)" .

How is the name of the view created? Windows does not allow percent signs in file names. Could this already be part the problem?
The length of the name could also be a problem. Together with the installation path of the database, there is a problem with more than 255 characters.

[habibullah.sayyed]

The view does not open and shows view corrupted, and the name of view shows like this "1r_15A.Grinding Aid Usage %_c6109cee-c939-482d-95d3-00a17becc8ec_[}tp_tasks}c6109cee-c939-482d-95d3-00a17becc8ec].[N213 - 5001].CAMID(_Holcim_u_9149d87f5f2360489aadadc5f4631706_)" .

How is the name of the view created? Windows does not allow percent signs in file names. Could this already be part the problem?
The length of the name could also be a problem. Together with the installation path of the database, there is a problem with more than 255 characters.

Hi orlando,
This view is automatic generated from contributor and this is a private view. How this happens, and how can we avoid this issue?
And after creating a dynamic view through MDX, will this issue gets solve?

[orlando]

Hi orlando,
This view is automatic generated from contributor and this is a private view. How this happens, and how can we avoid this issue?
And after creating a dynamic view through MDX, will this issue gets solve?

Hi!
Sorry, I never worked with the contributer and never saw it running anywhere. Maybe you could ask the IBM support.

Best regards
orlando