How to Freeze data ?

[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 ?

[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

[pobrouwers]

Hi,

Is it possible to do this by TI ?

Thx

[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

[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.

[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,