Page 1 of 1
How to Freeze data ?
Posted: Mon May 18, 2009 1:43 pm
by iesak
the manager want to freeze the data in order to avoid any data change while he is reading the report.
how can it be done ? TM1 workflow ?
Re: How to Freeze data ?
Posted: Mon May 18, 2009 2:15 pm
by TomBr
Hi,
Open the Subset Editor for the relevant Scenario dimension, right click on the relevant element and select Security\Lock.
Just select Unlock to reset later.
Tom
Re: How to Freeze data ?
Posted: Mon May 18, 2009 3:49 pm
by pobrouwers
Hi,
Is it possible to do this by TI ?
Thx
Re: How to Freeze data ?
Posted: Mon May 18, 2009 5:06 pm
by TomBr
I think the nearest you'll get is ElementSecurityPut which means you will need to have a statement for each security group or loop through them.
HTH.
Tom
Re: How to Freeze data ?
Posted: Tue May 19, 2009 6:06 am
by lotsaram
The other classic "TM1 method" of tackling this problem would be to copy the data to an alternate "reporting" version/scenario which users only have READ access to as opposed to the planning/forecast version and run the relevant reports off that.
Depending on the need the copy could be automated nightly/weekly whatever or could be triggered in specific cases from an action button for given views or slices of cube data.
Re: How to Freeze data ?
Posted: Tue May 19, 2009 1:19 pm
by Steve Rowe
You need to make sure you understand what the manager means by "Freeze".
Sometimes it just that the base numbers should not ever change which is do-able with security.
A harder problem is that reported consolidation values should not change either. i.e. What happens if an account is moved from one total to another. TM1s dynamic recalc can be a bit of a curse in "hard-core" financial accounting type application, though there are workarounds.
Anyway try not to offer the second option as it's a significant piece of work to set it up.
Cheers,