Page 1 of 1

Element missing from dimension

Posted: Tue Jun 26, 2012 11:31 pm
by winsonlee
I have created a view for the purpose of zero it out according to the element selected in the dimension.
Today when i revisited the view, one of the dimension is empty. It is empty not because the element has been deleted. But more like i got to expand All and reselect the element again.

anyone here know what causes the dimension to empty for a view ?

For using ViewZeroOut, i would like to find out if there is any difference between creating a view in a cube manually compare with creating a view using a TI process ?

Re: Element missing from dimension

Posted: Wed Jun 27, 2012 12:38 am
by asutcliffe
I think your problem is to do with with the index of the selected element having changed within your dimension. In short, I'd create the view you want to zero out on the fly within your ti process.

Re: Element missing from dimension

Posted: Wed Jun 27, 2012 6:44 am
by Andy Key
I wouldn't create subsets or views in TI as that will put a lock on the server for the duration of the process, but I would adjust the pre-existing subsets on a pre-existing view in TI, and much as I hate doing it as I think it is coding round an issue that shouldn't exist, I use subsets and views that start with '}' so they are hidden unless the users choose to show Control Objects, and even if they do, then they can't change or delete them. The only thing you then have to be careful of is executing a process for a second time when the first execution is still happening.