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).AmbPin wrote:no elements are deleted and then added back.
Disappearing values
-
- 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
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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
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.
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.
-
- 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
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.
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.