TM1 Forum

WilliamSmith 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!

Like the CubeNext function in TI

Good, elegant, solution.

Minor remark, you have the $url = part twice.

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 ?

monkey97 wrote: ↑Tue Aug 29, 2023 9:44 am They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.

Isn't it something that Yuri scripted in the SQL ?

I haven’t done that, if at all possible.

I haven’t done that, if at all possible.

Yes, a simple TI process with the necessary loops. There are no builtin functions to give that information.

Did you mean the function "RemoveClientFromGroup" in a Turbo Integrator process ?

https://www.ibm.com/docs/bg/cognos-tm1/ ... tfromgroup

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...

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...

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 _...

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...

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.

By adding a child you indeed convert to a C element.
What is the requirement for keeping it as an n-element ?

It’s Monday for a reason

Hello,

Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.

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.

Try the StrToMember() syntax with inside that [Periods].CurrentMember.Properties(“Name”) + “YTD” bit.

Yes. If it is string you would compare with ="1"

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.