Disappearing values

lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Disappearing values

Post by lotsaram »

AmbPin wrote:no elements are deleted and then added back.
If that's how the dimension maintenance is working then this isn't the cause of disappearing data. That would only happen if elements were deleted or if N was converted to C and back to N or vice versa (which effects a behind the scenes deletion and addition).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: Disappearing values

Post by AmbPin »

I don't see why it should be either but the pick-list values do disappear a soon as I run the process, no other data cubes are affected.
Not sure if I have mentioned that the pick-lists are created by rules on the pick-list cube. My thinking is unloading the cube was that these rules need to be re-triggered for some reason after the dimension maintenance.
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Disappearing values

Post by lotsaram »

Sounds a little bit like Alice through the looking glass.

Definitely something strange going on. String rules are by definition never cached and always on demand. So there must be something going on during the dimension rebuild that invalidates the rule and TM1 is not quite "clever" enough to recompile the rule when the dimension update is finished. My hopefully educated guess would be that a RuleLoadFromFile pointed back at the original .rux for the cube would also restore the picklists.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply