TM1 Forum

ascheevel wrote: ↑

Mon Mar 30, 2020 2:35 pm

Just do you DimensionElementInsert in the PROLOG or EPILOG tabs after your validation.

Not in Epilog tab, use the Prolog tab.

Hello all, I hope that everyone is safe during these challenging Corona times ! As people tend to stay in house (mandatory by the government), I thought it might be good to use this time for a new TI process in Bedrock. We can export the data on an element with '}bedrock.cube.data.export'. Often, cu...

On a more general level, see here: https://www.tm1forum.com/viewtopic.php? ... 34&p=71919

Hello, I have no immediate cure, but first get rid of the DIMENSIONDELETEALLELEMENTS function. Use a generic process to unwind the dimension structures, Bedrock for example has such process (in case you haven't written this one yourself). What rules do you typically have ? If I see TI wizard generat...

Please post the full code of the process, if you want any meaningful replies.

EDIT: go with the advice of Timok below.


I have not done this yet in TI but it sounds like a bug if you tested this thoroughly.

There’s a McAfee tech note, do not use it with Docker.

What happens if you assign the return value of HierarchySusbsetExists to a variable first? Do you just get the numeric flag or do you get the string bit? If you use a variable for HierarchySubsetExists first, it works as expected. This: v = HierarchySubsetExists( 'Rp_Company', 'Rp_Company', 'beperk...

Thank you Kamil. I will do some more testing when time is available.

Hello, I have this code, which generates weird output. Can someone make any sense out of it ? I would expect simple concatenations of text and a number (converted to text). LogOutput( 'INFO', 'z' | numbertostring( HierarchySubsetExists( 'Rp_Company', 'Rp_Company', 'beperking Rp' ) ) ); LogOutput( 'I...

True. But watch out with feeding like that, since the number of fed cells can grow quickly into big numers (if you apply the technique to several dimensions for example).

For the feeder, you have a couple of options. If the cube is really 2D and small, then don’t bother about feeders (and leave out the skipcheck statement near the top). Or if you want feeders, feed to 12 elements, comma-separated areas on the right hand side of the feeder. Or, add a consolidated elem...

Hello,

- Why do you duplicate the same (yearly) value in the months ?
- you can remove dimnm, dimix. Rules will just take the element principal name by default.

Hello,

Regarding the Bedrock question, is it related to what I posted here:

https://www.tm1forum.com/viewtopic.php?f=3&t=15134

orlando wrote: ↑

Wed Feb 26, 2020 10:57 am

TimeTq wrote: ↑

Tue Feb 25, 2020 10:07 am

Hi, I want to create a hyperlink from xlsm file to another xlsm file ( both of them on server).

Hi,

out of pure curiosity - why are you not using an "action button"?

best regards
orlando

True, if wanted, the button formatted as a hyperlink.

What is the purpose of the views and subsets ? Used in the process to copy data and so a zero out, or views that will be used later in by the user ? If the latter, views and subsets need to be permanent. If the former, indeed, you should use temporary objects.

Elements can also be used in reports or Action buttons, even though there are no data posted against them. So I would propose to also go through the/some reports.

Try to use the Prolog tab and concatenate the query string there.

What AsciiOutput statements did you try and what was the outcome for each of the statements ?

Please post the real TI code. What you post cannot be real TI code since it would contain syntax errors.
Also, 'CHC Consolidation Ledger' is not the same as 'Consolidation Ledger'
Use the AsciiOutput function to check your code.

Try:
or: