Search found 3024 matches

by Wim Gielis
Tue Apr 18, 2017 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Problem ( Range )
Replies: 6
Views: 3901

Re: Feeders Problem ( Range )

That's an easy one.

{ } is supported on the left hand side of the feeder or rule, but not on the right hand side.

Either duplicate it, either feed a consolidated element grouping those 12 elements.
by Wim Gielis
Sat Apr 15, 2017 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with ExecuteCommand. Not working for me
Replies: 10
Views: 8075

Re: Need help with ExecuteCommand. Not working for me

yingchai wrote:If I manually execute this .vbs script, it works okay.

If I trigger this .vbs script from a TI, the process failed
What user accounts are involved (your account and the one under which the TM1 service runs) and in what way do they differ ?
by Wim Gielis
Wed Apr 05, 2017 6:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12002

Re: Wildcard Search in a Dimension

Attached you can find a TI process that finds an element in any of the dimensions of a TM1 model. Wildcards * and ? are allowed in the element selection. The output is a file. Wim WG_search_for_element_name_with_wildcards.pro If( Long( pElement ) = 0 ); LogOutput( 'ERROR', 'The element is empty.' );...
by Wim Gielis
Wed Apr 05, 2017 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12002

Re: Wildcard Search in a Dimension

Also, watch out for invisible characters. An article on that can be found on my website. The site changed to extension .com instead of .be
by Wim Gielis
Tue Apr 04, 2017 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12002

Re: Wildcard Search in a Dimension

DIMIX is an exact match, taking into account that:

- all aliases are looked at
- TM1 being case-insensitive and space-insensitive

The drawbacks are that you can only search in the currently selected alias.
by Wim Gielis
Fri Mar 31, 2017 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }HierarchyProperties
Replies: 1
Views: 1549

}HierarchyProperties

Hello, Does anyone know if we can use the above control cube in MDX statements in plain TM1 ? If I read this page: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.10.2.2.doc/c_tm1_namedlevels_n0274.html You can assign your own custom names to the hiera...
by Wim Gielis
Wed Mar 29, 2017 5:43 pm
Forum: Useful code, tips and tricks
Topic: Dimension utilisation - finding redundant dimensions
Replies: 21
Views: 42997

Re: Dimension utilisation - finding redundant dimensions

Hello, I am trying to use this process but I am facing an error on .cma file. What I have to do in this case about the exportfile folder on prolog? Tks, JR Did you use a good value for exportFolder ? Meaning, a folder on the hard disk ? If yes, do you see the generated cma file ? Can you open it, f...
by Wim Gielis
Mon Mar 27, 2017 6:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

Did you really read the other contributions in this topic ?
Did you try them ?
by Wim Gielis
Sun Mar 26, 2017 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCII output file that doesnt overwrite
Replies: 8
Views: 6127

Re: ASCII output file that doesnt overwrite

Here is code for you. # Result: 2017-03-26 21:03:19 vNow = Timst( Now, '\Y-\m-\d \h:\i:\s' ); AsciiOutput( 'test.txt', vNow ); # Result: 2017-03-26 21:03:19 q = NewDateFormatter( '' ); vNow = FormatDate( Now, 'y-LL-dd HH:mm:ss', q ); AsciiOutput( 'test.txt', vNow ); # Result: 20170326 210319 q = New...
by Wim Gielis
Sat Mar 25, 2017 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCII output file that doesnt overwrite
Replies: 8
Views: 6127

Re: ASCII output file that doesnt overwrite

Or, as an alternative to FormatDate, consider the Timst function. That's not difficult at all.
by Wim Gielis
Wed Mar 22, 2017 6:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process compile error
Replies: 3
Views: 3099

Re: TI Process compile error

Please can we ask that you also spend time to investigate the error ?

https://www.ibm.com/support/knowledgece ... ppend.html
by Wim Gielis
Tue Mar 21, 2017 11:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Random number in TM1 process error logfiles
Replies: 1
Views: 1755

Random number in TM1 process error logfiles

Hello, EDIT: the pictures below are not hat I hoped to see, so if someone can improve this, go ahead :-) The TM1 process error logfiles appear to have a random number since the last version of TM1. In the past we had: http://everanalytics.blogspot.be/2015_08_01_archive.html 00.PNG Now we have: 01.PN...
by Wim Gielis
Tue Mar 21, 2017 6:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 8203

Re: Set ODBO Datasource in Prolog

That's true, and it's the reason why I only mentioned the local variables you would overwrite.
If you start from a working process with the correct data source type and credentials, things are easier.
by Wim Gielis
Mon Mar 20, 2017 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension picklist link
Replies: 3
Views: 2028

Re: Dimension picklist link

As indicated, you could create a picklist cube, containing a rule as shown.
In that rule, you could limit the measures dimension elements to 1 element - if needed - such that amount does not show the picklist.
by Wim Gielis
Sat Mar 18, 2017 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension picklist link
Replies: 3
Views: 2028

Re: Dimension picklist link

Hello, A picklist attribute on the dimension DEPT could be a possibility. Then put the values subset:REG:West, subset:REG:East, subset:REG:South on the respective elements. This could be sufficient but I don't know if you have other elements to populate. Alternatively you could create a picklist cub...
by Wim Gielis
Sat Mar 18, 2017 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ODBC - how to format output table?
Replies: 3
Views: 3210

Re: Drill Through to ODBC - how to format output table?

Not sure it's possible. Here is the link to another topic on how to work around shortcomings of the drill-through: http://www.tm1forum.com/viewtopic.php?f=3&t=12375
by Wim Gielis
Fri Mar 17, 2017 7:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 8203

Re: Set ODBO Datasource in Prolog

Hello, Welcome on board with your first post here. Not sure I understand what is going on, but this works fine for me: DataSourceNameForServer = 'THE_NAME_OF_MY_PC'; DataSourceODBOCatalog = 'THE_TM1_MODEL_NAME'; DataSourceQuery = '"WITH SET [General_Years Set] AS ''{ FILTER( { [General_Years].M...
by Wim Gielis
Thu Mar 16, 2017 5:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number Consolidation based on security settings
Replies: 7
Views: 5256

Re: Number Consolidation based on security settings

It's the sum of 6 children, not 3.
I haven't heard of changes in this respect.
It's been always like still and will most probably remain like this.
by Wim Gielis
Sat Mar 11, 2017 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assistance/guidance required using VBA QULOOP
Replies: 5
Views: 2924

Re: Assistance/guidance required using VBA QULOOP

Hello, Back in the days of 2007 when I started using TM1, I know that Turbo Integrator (TI) was optional. Turbo Integrator is the ETL tool of TM1. You can find it with "Processes" in the Server Explorer, below Applications, Cubes, Dimensions, and so on. I am pretty sure you can use it, but...
by Wim Gielis
Sat Mar 11, 2017 8:59 am
Forum: Useful code, tips and tricks
Topic: Tip of the Day - Ctrl+N and MDX
Replies: 2
Views: 14711

Re: Tip of the Day - Ctrl+N and MDX

Thanks! Indeed, we can reference elements in a dimension like that. {[dimension].[element]} The part in the middle is the result of ctrl-n, ctrl-v. I have seen people using TM1SubsetAll, Hierarchize, TM1FilterByLevel, TM1FilterByPattern on the exact same element string without wildcards, just to end...