TM1 Forum

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.

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.

gtonkin wrote: ↑Wed Aug 21, 2019 11:18 am 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.

habibullah.sayyed wrote: ↑Wed Aug 21, 2019 10:46 am 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".

gtonkin wrote: ↑Wed Aug 21, 2019 11:18 am 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.

lotsaram wrote: ↑Wed Aug 21, 2019 12:42 pm

habibullah.sayyed wrote: ↑Wed Aug 21, 2019 10:46 am 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_)" .

habibullah.sayyed wrote: ↑Wed Aug 21, 2019 12:58 pm 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.

orlando wrote: ↑Thu Aug 22, 2019 8:21 am

habibullah.sayyed wrote: ↑Wed Aug 21, 2019 12:58 pm 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?

habibullah.sayyed wrote: ↑Thu Aug 22, 2019 11:32 am
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