Hold consolidation via TI

Post Reply
hittony
Posts: 71
Joined: Mon Apr 27, 2015 8:54 am
OLAP Product: TM1
Version: 10.2.2 FP6
Excel Version: 2010

Hold consolidation via TI

Post by hittony »

Hi,

We have a requirement that we need to populate a consolidation and make it uneditable, however users should have the write access on its child members. I think of Hold functionality in Perspectives or in CAFE, but is it possible to meet the requirement via TI on the back-end ? I'm not very familiar with Data Reservation, but can it be a solution ?

Thanks for your ideas

Cheers

TM1 + CAFE 10.2.2 FP6
User avatar
Elessar
Community Contributor
Posts: 352
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Hold consolidation via TI

Post by Elessar »

Hello,

You can grant 'READ' access to consolidation in }ElementSecurity cube (or using Right click on dimension, Security). Also, you can use ElementSecurityPut TI function.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
Wim Gielis
MVP
Posts: 3127
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Hold consolidation via TI

Post by Wim Gielis »

Do you need to maintain the values at the consolidated level because you are talking about a hold functionality ?
Best regards,

Wim Gielis

IBM Champion 2024
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
hittony
Posts: 71
Joined: Mon Apr 27, 2015 8:54 am
OLAP Product: TM1
Version: 10.2.2 FP6
Excel Version: 2010

Re: Hold consolidation via TI

Post by hittony »

Wim Gielis wrote: Tue Aug 29, 2017 3:29 pm Do you need to maintain the values at the consolidated level because you are talking about a hold functionality ?
Yes, they should not be changed by BU, while all leaf members can be changed.
hittony
Posts: 71
Joined: Mon Apr 27, 2015 8:54 am
OLAP Product: TM1
Version: 10.2.2 FP6
Excel Version: 2010

Re: Hold consolidation via TI

Post by hittony »

Elessar wrote: Tue Aug 29, 2017 3:14 pm Hello,

You can grant 'READ' access to consolidation in }ElementSecurity cube (or using Right click on dimension, Security). Also, you can use ElementSecurityPut TI function.
Thanks Elessar for your suggestion, it means that if I have a TI to populate the consolidation, the process have to change the access to "WRITE" first, then put the data, and in the end change the access back to "READ".

But what if I use rules to populate the consolidation ?
User avatar
Elessar
Community Contributor
Posts: 352
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Hold consolidation via TI

Post by Elessar »

hittony,
I think I didn't understand you right. What do you mean by "populate the consolidation"? A screenshot would be useful
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
Post Reply