Lock reporting periods in TM1

Post Reply
Posts: 20
Joined: Mon Sep 16, 2019 12:17 am
OLAP Product: TM1 Planning Analytics
Version: 2.0
Excel Version: 2019

Lock reporting periods in TM1

Post by WayneBo » Wed Nov 06, 2019 11:16 pm

Hi All:

Have a question regarding to the data security.

We have a Financial Reporting cube, made up by dimension: Version (ie, actual, budget, forecast) ,Year, Month, Entities, GLAccount and GLMeasure.
GLMeasure dimension has measurement like: Balance, Opening Balance, Closing Balance, etc.

We upload our trail balances from our accounting system into TM1 after each month end.

How do I lock the previous period results after the final uploading in TM1?
Just like lock the periods in accounting system, the users still able to view the previous results, but just can not make any changes.

Please kindly help and let me know.

Thank you

Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore

Re: Lock reporting periods in TM1

Post by kangkc » Thu Nov 07, 2019 12:25 am

A quick and flexible way, set up a locking cube comprises of Version, Year, Month which allow you to set a string value of 'Lock', 'Unlock'.
Write a Cell Security rule in the Financial Reporting Cube to reference this locking cube. If the intersection of Version,Year,Month is 'Lock', set access to READ , else WRITE.
There may be more dimensions involved but above is just a simple illustration.

Post Reply