Search found 2318 matches

by Wim Gielis
Tue Mar 31, 2020 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Basic question on meta data and data
Replies: 3
Views: 135

Re: Basic question on meta data and data

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.
by Wim Gielis
Tue Mar 24, 2020 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Corona challenge: Export all data on an element
Replies: 0
Views: 239

Corona challenge: Export all data on an element

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...
by Wim Gielis
Mon Mar 23, 2020 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Attempt to acquire lock during commit or rollback
Replies: 4
Views: 486

Re: Attempt to acquire lock during commit or rollback

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...
by Wim Gielis
Sun Mar 22, 2020 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Attempt to acquire lock during commit or rollback
Replies: 4
Views: 486

Re: Attempt to acquire lock during commit or rollback

Please post the full code of the process, if you want any meaningful replies.
by Wim Gielis
Tue Mar 17, 2020 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hold and Proportional Spread
Replies: 6
Views: 214

Re: Hold and Proportional Spread

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.
by Wim Gielis
Mon Mar 16, 2020 12:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 17
Views: 1566

Re: Docker & McAfee on Windows Server

There’s a McAfee tech note, do not use it with Docker.
by Wim Gielis
Thu Mar 05, 2020 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with LogOutput and/or certain hierarchy subset functions
Replies: 3
Views: 611

Re: Issue with LogOutput and/or certain hierarchy subset functions

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...
by Wim Gielis
Tue Mar 03, 2020 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with LogOutput and/or certain hierarchy subset functions
Replies: 3
Views: 611

Re: Issue with LogOutput and/or certain hierarchy subset functions

Thank you Kamil. I will do some more testing when time is available.
by Wim Gielis
Sat Feb 29, 2020 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with LogOutput and/or certain hierarchy subset functions
Replies: 3
Views: 611

Issue with LogOutput and/or certain hierarchy subset functions

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...
by Wim Gielis
Fri Feb 28, 2020 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder from one n-elenemt to many n-elemets
Replies: 5
Views: 1065

Re: Feeder from one n-elenemt to many n-elemets

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).
by Wim Gielis
Thu Feb 27, 2020 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder from one n-elenemt to many n-elemets
Replies: 5
Views: 1065

Re: Feeder from one n-elenemt to many n-elemets

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...
by Wim Gielis
Thu Feb 27, 2020 1:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder from one n-elenemt to many n-elemets
Replies: 5
Views: 1065

Re: Feeder from one n-elenemt to many n-elemets

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.
by Wim Gielis
Thu Feb 27, 2020 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube -> Export as text data in a TI
Replies: 11
Views: 972

Re: TM1 Cube -> Export as text data in a TI

Hello,

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

https://www.tm1forum.com/viewtopic.php?f=3&t=15134
by Wim Gielis
Wed Feb 26, 2020 11:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink in TM1 Web
Replies: 5
Views: 655

Re: Hyperlink in TM1 Web

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.
by Wim Gielis
Tue Feb 18, 2020 5:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 User Locks
Replies: 2
Views: 208

Re: TM1 User Locks

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.
by Wim Gielis
Tue Feb 18, 2020 5:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cleaning up
Replies: 4
Views: 358

Re: TM1 cleaning up

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.
by Wim Gielis
Tue Feb 18, 2020 5:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 791

Re: Drill Through to ORACLE ODBC

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 ?
by Wim Gielis
Mon Feb 17, 2020 10:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 791

Re: Drill Through to ORACLE ODBC

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.
by Wim Gielis
Mon Feb 17, 2020 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 791

Re: Drill Through to ORACLE ODBC

Try:

Code: Select all

vSQL = Expand( 'Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = ''%sTime%''' );
or:

Code: Select all

vSQL = 'Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = ''' | sTime | '''';