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.
Search found 3024 matches
- Tue Apr 18, 2017 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders Problem ( Range )
- Replies: 6
- Views: 3901
- 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
What user accounts are involved (your account and the one under which the TM1 service runs) and in what way do they differ ?yingchai wrote:If I manually execute this .vbs script, it works okay.
If I trigger this .vbs script from a TI, the process failed
- 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.' );...
- 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
- 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.
- 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.
- 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...
- 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...
- 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 ?
Did you try them ?
- 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...
- 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.
- 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
https://www.ibm.com/support/knowledgece ... ppend.html
- 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...
- 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.
If you start from a working process with the correct data source type and credentials, things are easier.
- 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.
In that rule, you could limit the measures dimension elements to 1 element - if needed - such that amount does not show the picklist.
- 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...
- 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
- 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...
- 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.
I haven't heard of changes in this respect.
It's been always like still and will most probably remain like this.
- 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...
- 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...