TM1 Forum

Hi Wim, thanks for prompt response.

That's very useful tip. Is there a way to prevent some other unknown TI process write/edit these cells when locked?

Hello again Experts, Community, How to prevent any TI process writing to cells which are set to READ security. I understand that for TI Processes that are under my control can be set/coded logically but I'm looking for solution that irrespective of TI Process/Manual Input I want to prevent alteratio...

Thanks ascheevel, tomok and lotsaram. Your answers gave me much more clarity.

thanks, second option seem to work yes.

Is there any way to refer to elements in below fashion (LEFT Side) ?
[!}Cubes, !}Groups] = S: 'READ';

Hi Experts, 'm back with a question. I'm confused on how to place dynamic objects on Left side of rule. I tried below but it errors. I actually want the right side to be a look up from another cube. [!}Cubes, !}Groups] = S: 'READ'; do i write as below? [] = S: DB('my_cube', !}Cubes, !}Groups, 'Permi...

Thanks @gtonkin

There is a very useful Cube Viewer TM1 }ROLLUP feature which is not available in SUBNM. I have an Slice & ActiveForm where I want users to have flexibility of using consolidated element but don’t want to create many public subsets for it. Please advise alternative option to have }ROLLUP option f...

Thanks a lot and thanks for understanding. Finally my problem is solved.

bGregs, reallyappreciate your help on this. My files are in '}ApplicationEntries' folder I veried this using =SUBNM(pServer&":}ApplicationEntries","",1 which returns file path and file name with .blob extension. When i manually opened the file using excel / notepad it showed ...

bGregs, thanks for help so far. 'm still very to new to tm1 space. Would it be possible to throw some example? I tried below and it doesn't load the file. Workbooks.Open ActiveCell.Value (where active cell holds =SUBNM(pServer&":}ApplicationEntries","",1)) I am able to figure...

Got here so far and still can't make it work... Any advise will be apprciated. thanks. Overflows/excel crash at 'hBlobName = TM1ValString(hPool, strBlobName, 75)' line Dim hPool As Integer Dim hHandle As Integer Dim hBlobName As Integer Dim hBlob As Integer Dim hObject As Integer Dim hReturn As Inte...

Thanks Paul. In Cell I have a formula like this =SUBNM(pServer&":}ApplicationEntries","",1) and using action button to load it. Whenever you find sometime could you provide some dummy code to convert the result into a path and open them using VBA in TM1 Perspectives? thanks a...

Hi everyone,

Is there a way to open file from Application folder using VBA? One way I tried and worked was to open the file (one at a time) from Action button (Worksheet tab) but I want to be able to loop and load multiple files.

thanks for your help!

perfect! thank you.

Is there a formula to get children count of consolidated element within excel/tm1 perspective function?

That helps, thank you!

Hi Wim, thanks for quick support. I do not have admin rights to perform this task. Is there a way to process this copy/replace suggestion via TI Process?

regards
Ashleigh

Hello TM1 Experts out there!!! I have many files I need to (1) download from Application folder to local folder and archive and (2) upload multiple new files mostly excel to the folder. Is there a way to automate (upload/download) this in TI or any other way, please advise. Currently the manual way ...

@ Wim Gielis, thanks for your input and suggestions/idea. appreciate your help.

@tomok, thanks for quick reply.
I have 300+ processes that have multiple parameters (some 2,3 or some 5 or 6) depending on process requriements... I am wanting to include generic code that can store all the parameters passed and the input values to my cube for logging.