Search found 3040 matches
- Sun Sep 10, 2023 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1s.cfg parameter to have Excel serial dates
- Replies: 3
- Views: 660
TM1s.cfg parameter to have Excel serial dates
When we want to enable the use of Microsoft Excel serial dates instead of Planning Analytics serial dates, we would use UseExcelSerialDate=T in the TM1s.cfg file: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pitf-useexcelserialdate However, this has implications, for instance on determ...
- Sat Sep 09, 2023 4:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 21015
Re: Bedrock And Github vs Other Options
I should have added emojis to my post as we all know that you are not the biggest fan of PAW 😂 It was meant to be funny 😆 and certainly not as viable option beyond any work done for fun or demo purposes. But anyway, for completeness, custom snippets can be created. https://www.ibm.com/docs/en/planni...
- Sat Sep 09, 2023 3:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 21015
Re: Bedrock And Github vs Other Options
Yes, it's been 3 years. Time flies and IBM is coming to rescue:
PAW with your own custom snippets (https://www.ibm.com/docs/en/planning-an ... ess-editor)
PAW with your own custom snippets (https://www.ibm.com/docs/en/planning-an ... ess-editor)
- Sat Sep 09, 2023 3:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Vs Google Big Query - One Person's Experience
- Replies: 5
- Views: 2999
Re: ODBCOutput Vs Google Big Query - One Person's Experience
Thanks for the detailed descriptions. I have never used Google BQ but it appears that a flat file can be loaded: https://stackoverflow.com/questions/52119663/loading-a-csv-into-bigquery-using-bq Wouldn't that be quicker and safer ? At least I do a BULK INSERT into SQL tables (Epilog of a TI process)...
- Wed Sep 06, 2023 4:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX which takes Value from Cube
- Replies: 12
- Views: 7403
Re: MDX which takes Value from Cube
Like the CubeNext function in TIWilliamSmith wrote: ↑Wed Sep 06, 2023 3:43 pm Anyway... while we're here in 2023... using ChatGPT to help generate, as well as breakdown and understand MDX statements is invaluable. It also knows Turbo Integrator and rule/feeder syntax!
- Fri Sep 01, 2023 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1761
Re: Update a process with the TM1 REST API
Good, elegant, solution.
Minor remark, you have the $url = part twice.
Minor remark, you have the $url = part twice.
- Thu Aug 31, 2023 1:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1761
Re: Update a process with the TM1 REST API
What happens to the security assignments for the process, when you delete and recreate ?
In general, I try to update rather than recreate, to not lose other settings.
Another example, data against the process in the }Processes dimension in a cube: is it lost or not, when deleting and recreating ?
In general, I try to update rather than recreate, to not lose other settings.
Another example, data against the process in the }Processes dimension in a cube: is it lost or not, when deleting and recreating ?
- Tue Aug 29, 2023 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1425
- Wed Aug 23, 2023 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 912
Re: Cognos security group database
I haven’t done that, if at all possible.
- Wed Aug 23, 2023 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1425
Re: }ClientGroups cube not in sync. with Cognos
I haven’t done that, if at all possible.
- Tue Aug 22, 2023 9:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1425
Re: }ClientGroups cube not in sync. with Cognos
Yes, a simple TI process with the necessary loops. There are no builtin functions to give that information.
- Tue Aug 22, 2023 9:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 912
Re: Cognos security group database
Did you mean the function "RemoveClientFromGroup" in a Turbo Integrator process ?
https://www.ibm.com/docs/bg/cognos-tm1/ ... tfromgroup
https://www.ibm.com/docs/bg/cognos-tm1/ ... tfromgroup
- Tue Aug 22, 2023 9:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turn off consolidated drilling?
- Replies: 4
- Views: 840
Re: Turn off consolidated drilling?
Tm1RPTROW in PAfE has a parameter that you can use to suppress drilling on consolidated elements. Is anyone aware of an equivalent setting (or MDX that would achieve the same result) in a standard websheet cube view, please? Do you mean that you are using IBM PASS (Planning Analytics Spreadsheet Se...
- Sun Aug 13, 2023 11:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hold, Release Hold via Rest API or TI Process?
- Replies: 3
- Views: 1678
Re: Hold, Release Hold via Rest API or TI Process?
A new custom TI process was proposed by myself to Bedrock TM1. It was approved: https://github.com/cubewise-code/bedrock/pull/378 The process allows to create a holds cube, destroy a holds cube, release all holds, export all holds, import all holds. This can be done for a selection of cubes, and cli...
- Thu Aug 10, 2023 9:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hold, Release Hold via Rest API or TI Process?
- Replies: 3
- Views: 1678
Re: Hold, Release Hold via Rest API or TI Process?
Hello, Here is a TI approach. The process will read a text file and apply holds to the given combinations. In the example it will lead to 13 holds in the cube, as the combination in line 14 cannot be located in the cube. It gives us 13 holds (red triangles) at several levels in the cube. holds.PNG _...
- Mon Jul 31, 2023 10:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ISO Week Number
- Replies: 6
- Views: 1774
Re: ISO Week Number
Hello, I thought I would test this, and it works fine :) I made a couple of smaller edits. Here is the code for 1 date, output in the TM1 server log: pDate = '20241231'; pDateFormat = 'yyyyMMdd'; ndf = NewDateFormatter( 'nl_BE', 'Etc/UTC', 'serial', 'date' ); # parse the date parameter nDate = Parse...
- Mon Jul 31, 2023 9:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 should display values in /1000 format.
- Replies: 9
- Views: 1775
Re: TM1 should display values in /1000 format.
How can the n level show the value /1000 ?
It is the big value that is divided by 1000 and shown on the C level. The n level is unchanged.
It is the big value that is divided by 1000 and shown on the C level. The n level is unchanged.
- Mon Jul 31, 2023 8:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 should display values in /1000 format.
- Replies: 9
- Views: 1775
Re: TM1 should display values in /1000 format.
By adding a child you indeed convert to a C element.
What is the requirement for keeping it as an n-element ?
What is the requirement for keeping it as an n-element ?
- Mon Jul 31, 2023 7:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Distinguish between default and other hierarchies
- Replies: 4
- Views: 582
Re: Distinguish between default and other hierarchies
It’s Monday for a reason
- Mon Jul 31, 2023 7:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Distinguish between default and other hierarchies
- Replies: 4
- Views: 582
Re: Distinguish between default and other hierarchies
Hello,
Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.
Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.