Search found 3151 matches
- 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: 84985
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.
- 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: 84985
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? -...
- 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: 84985
Re: security overlay - what am I doing wrong
What I observe in my tests is: • a user in the ADMIN or DATATADMIN group can write to the overlay security locked cell • a user not in the ADMIN and not in the DATATADMIN group cannot to the overlay security locked cell • a user in the ADMIN or DATATADMIN group can run a TI that writes to the overla...
- 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: 84985
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...
- 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: 84985
Re: security overlay - what am I doing wrong
And that is why only you and George are using the feature….
- Mon May 26, 2025 7:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Action Button
- Replies: 8
- Views: 6999
Re: Dynamic Action Button
You’re welcome
- 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: 4357
Re: Parallel update of dimensions causes rollback
Are there cube links through rules ?
- Fri May 23, 2025 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Action Button
- Replies: 8
- Views: 6999
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...
- Fri May 23, 2025 8:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Action Button
- Replies: 8
- Views: 6999
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...
- Sun May 11, 2025 11:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Printing the date of today and time of now
- Replies: 1
- Views: 2700
- 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: 2700
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...
- Tue May 06, 2025 8:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Action Button
- Replies: 8
- Views: 6999
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, ...
- 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: 13240
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...
- 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: 13240
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....
- 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: 35007
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...
- Fri Apr 11, 2025 6:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }dimensionsecurity cube Created
- Replies: 4
- Views: 4132
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)
- 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: 57475
Re: Remove the alias in MDX of dimension; show member ID
Saving a subset should also save the alias or principal name choice.
- Sun Mar 09, 2025 8:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools 64 Bit - Does it exist?
- Replies: 10
- Views: 19212
Re: TM1 Tools 64 Bit - Does it exist?
E_PICK was removed from PAfE.
- Wed Mar 05, 2025 9:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove the alias in MDX of dimension; show member ID
- Replies: 8
- Views: 57475
Re: Remove the alias in MDX of dimension; show member ID
I am very sorry but I don't understand it.
A few pictures might make it clearer.
A few pictures might make it clearer.
- Fri Feb 28, 2025 9:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: system process to create dimension period
- Replies: 2
- Views: 5755
Re: system process to create dimension period
Do you know who is the author of the process ? Do you know whether it was found online (can you Google some parts of the script maybe) ?
I have the impression that it was custom built for you and that an extension does not exist/should be written by you or someone else.
I have the impression that it was custom built for you and that an extension does not exist/should be written by you or someone else.