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!
Search found 3036 matches
- 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: 7311
Re: MDX which takes Value from Cube
- 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: 1731
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: 1731
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: 1412
- Wed Aug 23, 2023 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 904
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: 1412
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: 1412
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: 904
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: 809
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: 1669
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: 1669
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: 1759
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: 1759
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: 1759
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: 571
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: 571
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.
- Fri Jul 28, 2023 3:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 should display values in /1000 format.
- Replies: 9
- Views: 1759
Re: TM1 should display values in /1000 format.
Or create a new measure with the old measure as a child.
The weight is 0.001 for thousands.
No need for rules and you are not loading your values twice.
Maybe what is needed is a bit of formatting to not show decimals.
The weight is 0.001 for thousands.
No need for rules and you are not loading your values twice.
Maybe what is needed is a bit of formatting to not show decimals.
- Thu Jul 27, 2023 3:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx statement for zero suppression based on control cube
- Replies: 13
- Views: 2351
Re: Mdx statement for zero suppression based on control cube
Try the StrToMember() syntax with inside that [Periods].CurrentMember.Properties(“Name”) + “YTD” bit.
- Wed Jul 26, 2023 5:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx statement for zero suppression based on control cube
- Replies: 13
- Views: 2351
Re: Mdx statement for zero suppression based on control cube
Yes. If it is string you would compare with ="1"
- Thu Jul 06, 2023 6:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify All References to Cube
- Replies: 7
- Views: 9841
Re: Identify All References to Cube
Or commercial tools such as Qubedocs. Note: I have no advantage of or links with, Qubedocs.
Or roll your own solution by using a TI process to read the PRO and RUX files, etc. Or develop a solution using the TM1 REST API. tm1py has some support for this task at hand.
Or roll your own solution by using a TI process to read the PRO and RUX files, etc. Or develop a solution using the TM1 REST API. tm1py has some support for this task at hand.