Search found 574 matches
- Mon Sep 19, 2022 5:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wildcard text searches in a TI process
- Replies: 5
- Views: 1445
Re: Wildcard text searches in a TI process
Not really a full wildcard search functionality, but for your example you could look at the SCAN function: F.i. SCAN('Rad', 'Radius') returns 1, meaning that the string 'Radius' starts with the substring 'Rad'. If the function returns 0 the substring is not found in the string. If the return value i...
- Fri Mar 05, 2021 4:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Capture Contributor Usage
- Replies: 5
- Views: 3136
Re: Capture Contributor Usage
When an application is opened, the process }tp_initialize_session is run. You can find this in the TM1 Message Log with the message " Process "}tp_initialize_session" executed by user "username" ". You could add some code to this process that logs when this process is r...
- Fri Jan 11, 2019 7:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Old TM1 version
- Replies: 7
- Views: 5733
Re: Old TM1 version
And if we go even further back in time ... there was this interface:
- Fri Nov 02, 2018 4:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HierarchySubsetElementDelete odd behavior
- Replies: 4
- Views: 3543
Re: HierarchySubsetElementDelete odd behavior
Have the following subset with hundreds of elements: All Accounts 100-100-100 200-100-101 ... This code fails with "Unable to delete element at position "0" from dimension:subset": sMDX = EXPAND('UNION({[%dimAccountsMaster%].[%hierAccountsForecast%].currentmember}, TM1FILTERBYLE...
- Fri Jul 27, 2018 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics using twice the memory of 10.1
- Replies: 43
- Views: 52873
Re: Planning Analytics using twice the memory of 10.1
Hi Paul, You're probably aware, but I just would like to mention that there are some server configuration settings that trigger a RAM usage impact that you mention - most notably the MaximumCubeLoadThreads and the newer MTCubeLoad, MTFeeders and MTFeeders.AtStartup. One thing you could check is whet...
- Fri Oct 13, 2017 3:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 10.2.2 FP6 client and Planning 2.0.2
- Replies: 2
- Views: 2834
Re: 10.2.2 FP6 client and Planning 2.0.2
Hi Willi,
The Pre TLS 1.2 option is only relevant for clients on version 10.2.2FP5 and older.
Did you set the ClientVersionMinimum and ClientVersionMaximum parameters in the tm1s.cfg file (f.i. ClientVersionMinimum=10.2.20600)?
Michel
The Pre TLS 1.2 option is only relevant for clients on version 10.2.2FP5 and older.
Did you set the ClientVersionMinimum and ClientVersionMaximum parameters in the tm1s.cfg file (f.i. ClientVersionMinimum=10.2.20600)?
Michel
- Fri Oct 13, 2017 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional cumulation of values between two differently dimensioned cubes
- Replies: 3
- Views: 3445
Re: Conditional cumulation of values between two differently dimensioned cubes
Hi Jan, If the mapping changes from period to period it indeed makes no sense to use the dimension rollup. What you could do is build an intermediate accumulation link cube that contains the company, year, month, version, currency, accountParams, accounts and accountGroups dimensions. This cube pull...
- Wed Oct 04, 2017 1:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional cumulation of values between two differently dimensioned cubes
- Replies: 3
- Views: 3445
Re: Conditional cumulation of values between two differently dimensioned cubes
Hi Jan, I was just going through some unread posts in the forum and noticed your question. If I understand your requirement correctly, you want to pull the on an accountgroup level consolidated account values from the accountParameters cube to the accountGroupParameters cube. In that case you would ...
- Fri Jul 07, 2017 1:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Time dimension, alternate drill-down path
- Replies: 7
- Views: 5493
Re: Time dimension, alternate drill-down path
actually we're building a time dimension in TM1 and ran into a question how to have an alternate drill-down path in the dimension. [...] But at the moment we can just define one path in the HierarchyPropertys which causes that TM1 puts the rolling month levels under year, quarter, month. Anyone an ...
- Wed Jun 07, 2017 6:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stuck on a if Condition.. too silly
- Replies: 7
- Views: 5606
Re: Stuck on a if Condition.. too silly
Its sometimes easier to say if something is equal to such and such then itemskip. I second that. To me it was not clear whether the If statement enclosed an ItemSkip or the actionable code... I would reverse the conditions and put an ItemSkip inside the if and the actionable code after the endif. O...
- Wed Jun 07, 2017 5:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stuck on a if Condition.. too silly
- Replies: 7
- Views: 5606
Re: Stuck on a if Condition.. too silly
the condition translates to if Proj_code is not blank or proj_code is not equal to 'N/A' or Proj_code is not equal '0' or if NewBuss is equal to 'N' if ( Proj_code @<> '' % Proj_code @<> 'N/A' % Proj_code @<> '0' % NewBuss @= 'N') ; ----- EndIf; I have verified that the data is 'N/A', '0'. So you'r...
- Wed May 03, 2017 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run a Java program from TI process using ExecuteJavaN
- Replies: 3
- Views: 4426
Re: Run a Java program from TI process using ExecuteJavaN
Hi Mohan,
Have a look at the javaextensions.policy file in TM1-install-dir\configuration directory and make sure the grant permissions are set correctly.
See details here.
Michel
Have a look at the javaextensions.policy file in TM1-install-dir\configuration directory and make sure the grant permissions are set correctly.
See details here.
Michel
- Thu Nov 03, 2016 10:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 iWidgets in Internet Explorer
- Replies: 2
- Views: 2732
Re: TM1 iWidgets in Internet Explorer
Hi Maybe try in Compatibility view, or IE10 Browser mode (F12 - Developer tools in IE). That helped in case of tm1 ops console, I know this is totally different what you are doing but maybe worth a try? Hi mvaspal, Thanks for this. I already tried compatibility mode with no success, but changing th...
- Thu Nov 03, 2016 9:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 iWidgets in Internet Explorer
- Replies: 2
- Views: 2732
TM1 iWidgets in Internet Explorer
Hi all, I'm configuring a new installation consisting of Cognos Business Analytics 11.0.4 and TM1 10.2.2 (FP5), both on the same server. I'm trying to get the TM1 iWidgets working (legacy Cognos Workspace) and ran through the various configuration steps. I'm now facing an issue that everything is wo...
- Fri Jul 15, 2016 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2.2 FP6
- Replies: 57
- Views: 44074
Re: TM1 10.2.2 FP6
Regarding the MTQ usage I'm wondering how much benefit this bring if you have to include consolidated values in the view extract... If you set the view up so that you don't have any consolidations in the view definition to start with (why have them there if you are only going to skip them anyway?) ...
- Fri Jul 15, 2016 4:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2.2 FP6
- Replies: 57
- Views: 44074
Re: TM1 10.2.2 FP6
This FP6 seems like a premature e-publication to me
Regarding the MTQ usage I'm wondering how much benefit this bring if you have to include consolidated values in the view extract...
Michel
Regarding the MTQ usage I'm wondering how much benefit this bring if you have to include consolidated values in the view extract...
Michel
- Tue Jul 05, 2016 4:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web login: How to set a default TM1 server
- Replies: 8
- Views: 8833
Re: TM1 Web login: How to set a default TM1 server
Can we specific some TM1 servers into that drop-down list? rather than all available servers? You either specify a particular server or get a drop down list of all servers available on the admin host. If you want to control it you can use a url redirect to bounce users into TM1 web with a particula...
- Tue Sep 01, 2015 7:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rule Last value in next level and hierarchy
- Replies: 4
- Views: 3511
Re: TM1 Rule Last value in next level and hierarchy
Hi A3aan, It’s not easy to find out what’s wrong based only on the rules sheet and your brief description. What I can see is that: 1. Based on the comments I see you have been editing the original rules set. Did the problems occur after your changes? 2. There are quite some rule calculations defined...
- Wed Aug 26, 2015 5:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error : Operations Console
- Replies: 2
- Views: 3035
Re: Error : Operations Console
Hi, Any one have come across with the same error attached and have fixed? please suggest me ... I have added a server and observed the users connected and later after a day, when I re-login back , I came across this error. default configuration: Default server : SData Default Group : Admin DefaultA...
- Wed Aug 19, 2015 7:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to connect TM1 Perspective from client to the Server
- Replies: 8
- Views: 6890
Re: How to connect TM1 Perspective from client to the Server
Hi Roy, If you've installed Perspectives on a client machine you can start the add-in from the Perspectives shortcut in the start menu. You can also create your own shortcut to the tm1p.xla file and double-click that to start Perspectives (or you can setup Perspectives to auto load when starting Exc...