Element missing from dimension

Post Reply
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Element missing from dimension

Post 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 ?
asutcliffe
Regular Participant
Posts: 164
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: Element missing from dimension

Post 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.
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Element missing from dimension

Post 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.
Andy Key
Post Reply