CE - Rules Overwriting Data?

Post Reply
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

CE - Rules Overwriting Data?

Post by Kyro »

My clients just had a situation where rules had briefly overwritten cells which previously had data, no data save was done but the data doesn't come back when the rule is disabled. Does early Cognos Express behave any differently to TM1 9.4 in this way?
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: CE - Rules Overwriting Data?

Post by Martin Ryan »

Early Cognos Express is powered by TM1 9.4 (or 9.4.1) so will behave the same way.

Have you tried a server restart? It may be that it's cleared from memory, but it should all still be held on disk.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: CE - Rules Overwriting Data?

Post by Kyro »

Yep we got it, but it seems gone are the days when values simply reappear when the rule is disabled again, hopefully it's just a one off - I loved that 'feature'.
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: CE - Rules Overwriting Data?

Post by Wim Gielis »

But, if I want to clear values in area very easily (for testing purposes mostly), I write a rule that puts 0 on the area and I save.
That would then become impossible in your reasoning... :-)
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: CE - Rules Overwriting Data?

Post by Kyro »

You dont go for the 'Clear' spreading option?
Thats TM1 for ya - a million ways to do anything. I'm pretty sure it used to work the way I previously described.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: CE - Rules Overwriting Data?

Post by lotsaram »

Kyro wrote:Yep we got it, but it seems gone are the days when values simply reappear when the rule is disabled again, hopefully it's just a one off - I loved that 'feature'.
Somewhere after 9.1 this feature disappeared. Certainly in 9.5 if a rule overwrites data then the data is gone regardless of what subsequently happens to the rule.
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: CE - Rules Overwriting Data?

Post by Wim Gielis »

Kyro wrote:You dont go for the 'Clear' spreading option?
Thats TM1 for ya - a million ways to do anything. I'm pretty sure it used to work the way I previously described.
Say, if I need to erase Actuals scenario data for 2011, I will write a rule and save:

['Actuals','2011']=0;

After saving, I delete the rule and save again.

Of course only if saving the rules does not take ages ;-) And in the absence of a generic process to clear a certain scenario and/or year in that cube.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply