TM1 Forum

Also see:
https://www.acgi.com/blog/from-executec ... version-12

Hello, For the swap, I can only think of a semi-manual/semi-automatic approach. You could use Bedrock to export and import data but other than that, it’s a manual task. For ExecuteCommand, some of the use cases can be handled by ExecuteHttpRequest, some cannot. You will maybe have to rethink your ap...

Also you might want to consider the MDX function LastPeriods with a value of -2, if element indexes behave correctly.

As Lotsa implies, please disregard from that function and do it the proper way.
HierarchyElementInsert
HierarchyElementComponentAdd
Destroy parent-child relations and so on

Updated version. More options and enhancements, some bug fixes.
Process name changed too.

Aren't you transitioning to more modern IBM PA / TM1 clients that will be supported going forward by IBM?
In 2 months time support will stop for a number of older TM1 clients.

I am back to TM1/ IBM PA after a long long time, after having worked in it very briefly. Suffice to say, I am a beginner. Currently a very demanding project fell into my lap with extremely tight deadlines. (They brought me in because I was the only scapegoat) Not personally to you, but, ..., no one...

Voted too !

Correct. Chores should run from static cube values. They will not be stopped in case someone puts in a wrong value. That’s a responsibility for users. At least the manual runs are protected. If you want to have chores protected than take out the time to add validation code in the Prolog tabs.

Further testing: • a chore that runs a TI process can write without issue, when the chore runs on a schedule • a chore that runs a TI process, when the chore is run by a particular user, will run with the security rights of that user So you can you summarize: - what do you see in your environment? -...

What I observe in my tests is: • a user in the ADMIN or DATAADMIN group can write to the overlay security locked cell • a user not in the ADMIN and not in the DATAADMIN group cannot write to the overlay security locked cell • a user in the ADMIN or DATAADMIN group can run a TI that writes to the ove...

True. You can (and should) build such a mechanism yourself. Even better would be a generic TI that is called and returns the outcome (based on the parameter values, user (or chore), "area" (what type of process is run) and any other logic needed to decide: continue or not. That way, your h...

And that is why only you and George are using the feature….

You’re welcome

Are there cube links through rules ?

Hi, Thank you for your information. How can I reference a cell or cube in the action button? Do i do it in the field provided by adding a formula or some kind of reference? if so, how? Appreciate your response Since you are using the Excel add-in, the action button parameter references can also poi...

Hi Wim, Thank you for your response. Yes, I have a Calendar cube with the different fiscal periods. Could you provide the step by step on how I can do it, please? where exactly can I reference the cube and where should I inpute the cellgets? Many thanks Hello, Do you have a system cube of some sort...

Cross-posted here for a wider audience:

https://community.ibm.com/community/use ... 4eda43146b

Hello all, Here is some code related to dates and times: DatasourceASCIIQuoteCharacter = ''; n = Now; sNow = Timst( n, '\d-\m-\Y \h:\i:\s' ); ASCIIOutput( 'test.txt', sNow ); i = NewDateFormatter( 'nl_BE', 'Europe/Brussels', '', '', 'datetime' ); v = FormatDate( n, 'EEEE dd MMMM y - H:mm', i ); ASCI...

Hello, Do you have a system cube of some sort, to collect parameters like the current fiscal period and year that are being worked on in finance ? Or parameters in that cube to hold file paths and folder structures. Or an ODBC user and password. Etc. That cube could be manual input by the key user, ...