TM1 Forum

Hi Please ignore my last post, just tried it again and my formula works, thanks for the DBSS tip.


Thanks again.

Yes its G4 for this sample, just made a smaller version to demonstrate what I am trying to do. Thanks

ThanksI am quite new to TM1, Thanks very much for your help. Just tried the DBSS as suggested but its now blank instead of error {Value} displayed with the DBS formula. The new formula below, =DBSS(C5,$C$1,$B5,U$4) C5 is the "Write" (string as suggested) C1 is scm:}ElementSecurity_PPL B5 i...

ThanksI am quite new to TM1, Thanks very much for your help. Just tried the DBSS as suggested but its now blank instead of error {Value} displayed with the DBS formula. The new formula below, =DBSS(C5,$C$1,$B5,U$4) C5 is the "Write" (string as suggested) C1 is scm:}ElementSecurity_PPL B5 i...

Please delete the post since you are an adminstrator and I will get the right information when i get to work tomorrow. Mr Kirk

I created a template from a cube slice in the security dimension for the Adminstrator to easily update TM1 security rights using a DBS function but it comes back with an error meassage [Value]. Does anyone know the correct function that can update the TM1 security cube e.g. Read to Write access thro...

Hi All,

How do I stop TM1 automatically uploading data from an input template? Everytime I open an old template while connceted to TM1, it automaticvally uploads the data even with my excel settings on manual. I want to control it by hitting a data submit button.

Please advise.

Thank you all so much for your help!

I really appreciate.

Hi, Does anyone have any idea if there is a search option when assigning rights? e.g. ctrl F I have a list of 500 rows and 100 columns to assign multiple rights that are grouped in 5's. I have to scroll manually through my dimension of 500 rows to make changes. (NB:They are in no particular order). ...