Search found 3154 matches

by Wim Gielis
Mon Aug 25, 2025 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: All data input only at leaf level in Contributor
Replies: 4
Views: 2262

Re: All data input only at leaf level in Contributor

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.
by Wim Gielis
Mon Aug 25, 2025 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process build for dynamic Scenario, Time etc.. Kindly help!
Replies: 1
Views: 1543

Re: TI Process build for dynamic Scenario, Time etc.. Kindly help!

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...
by Wim Gielis
Tue Jul 01, 2025 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security overlay - what am I doing wrong
Replies: 22
Views: 545783

Re: security overlay - what am I doing wrong

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.
by Wim Gielis
Thu Jun 26, 2025 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security overlay - what am I doing wrong
Replies: 22
Views: 545783

Re: security overlay - what am I doing wrong

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? -...
by Wim Gielis
Wed Jun 25, 2025 5:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security overlay - what am I doing wrong
Replies: 22
Views: 545783

Re: security overlay - what am I doing wrong

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...
by Wim Gielis
Tue Jun 24, 2025 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security overlay - what am I doing wrong
Replies: 22
Views: 545783

Re: security overlay - what am I doing wrong

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...
by Wim Gielis
Tue Jun 17, 2025 9:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: security overlay - what am I doing wrong
Replies: 22
Views: 545783

Re: security overlay - what am I doing wrong

And that is why only you and George are using the feature….
by Wim Gielis
Mon May 26, 2025 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Action Button
Replies: 8
Views: 14260

Re: Dynamic Action Button

You’re welcome
by Wim Gielis
Mon May 26, 2025 7:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel update of dimensions causes rollback
Replies: 2
Views: 10328

Re: Parallel update of dimensions causes rollback

Are there cube links through rules ?
by Wim Gielis
Fri May 23, 2025 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Action Button
Replies: 8
Views: 14260

Re: Dynamic Action Button

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...
by Wim Gielis
Fri May 23, 2025 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Action Button
Replies: 8
Views: 14260

Re: Dynamic Action Button

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...
by Wim Gielis
Sun May 11, 2025 10:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Printing the date of today and time of now
Replies: 1
Views: 5924

Printing the date of today and time of now

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...
by Wim Gielis
Tue May 06, 2025 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Action Button
Replies: 8
Views: 14260

Re: Dynamic Action Button

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, ...
by Wim Gielis
Sat Apr 12, 2025 1:43 am
Forum: Useful code, tips and tricks
Topic: Drill-through to a cube view with minimalistic coding
Replies: 1
Views: 19472

Re: Drill-through to a cube view with minimalistic coding

As an example call, use: NumericGlobalVariable( 'nErrors' ); StringGlobalVariable( 'vObject_Name' ); cCube = 'Prm_Init'; vObject_Name = 'Drill_Details (%u% at %t%)'; # Create the drill object (the order of subsets is retained) nErrors = nErrors + ExecuteProcess( 'WG_DRILL_cube_view_drill_setup', 'pC...
by Wim Gielis
Sat Apr 12, 2025 1:35 am
Forum: Useful code, tips and tricks
Topic: Drill-through to a cube view with minimalistic coding
Replies: 1
Views: 19472

Drill-through to a cube view with minimalistic coding

Hello, I was able to script a drill-through to a cube view: https://tm1forum.com/viewtopic.php?p=84403#p84403 Have a look there to download the generic process and look at the examples of how to call it. Bedrock is underpinning the new process so you need (at least some of) the Bedrock TI processes....
by Wim Gielis
Sat Apr 12, 2025 1:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 21
Views: 36188

Re: Drill-through to a cube view

Fast forward to Q2 2025 and this seems to be fully working. [Still waiting for drills to MDX views though.] I can get a fully dynamic target view without any other action by the user :-) but there is a but (the same but as 5 years ago, not coincidentally since TM1 server did not change here). I wrot...
by Wim Gielis
Fri Apr 11, 2025 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }dimensionsecurity cube Created
Replies: 4
Views: 4961

Re: }dimensionsecurity cube Created

Why don’t you use that cube and fill it out appropriately? Or should anyone be able to see all dimensions ? (Even if cube security is in place and/or an interface is used)
by Wim Gielis
Mon Mar 10, 2025 9:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove the alias in MDX of dimension; show member ID
Replies: 8
Views: 58797

Re: Remove the alias in MDX of dimension; show member ID

Saving a subset should also save the alias or principal name choice.