TM1 Forum

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.

If you push the security with a process, then why don’t you have element security on the elements in the picklist ?

Hello,

I would look at StringGlobalVariable.
Or simply writing it in a system cube and reading again.o op

PavoGa wrote: ↑Tue Jun 20, 2023 5:55 pmWasn't there a post the other day about some additional variables available for use with RunProcess? I searched but have not found it.

That doesn't ring a bell unfortunately.

I would not expect SYNCHRONIZE to make the parent process wait for the child processes and that behavior is pre-PAW as well. What is the usage context? The context is that a user clicks on a button in PAW. It kicks off the mother process. The mother process should wait for the child processes to fi...