Search found 574 matches

by Michel Zijlema
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: 1343

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...
by Michel Zijlema
Fri Mar 05, 2021 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Capture Contributor Usage
Replies: 5
Views: 3082

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...
by Michel Zijlema
Fri Jan 11, 2019 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 5349

Re: Old TM1 version

And if we go even further back in time :ugeek: ... there was this interface:
TM1_4.0.png
TM1_4.0.png (77.96 KiB) Viewed 5270 times
by Michel Zijlema
Fri Nov 02, 2018 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySubsetElementDelete odd behavior
Replies: 4
Views: 3457

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...
by Michel Zijlema
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: 48813

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...
by Michel Zijlema
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: 2724

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
by Michel Zijlema
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: 3296

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...
by Michel Zijlema
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: 3296

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 ...
by Michel Zijlema
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: 5452

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 ...
by Michel Zijlema
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: 5544

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...
by Michel Zijlema
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: 5544

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...
by Michel Zijlema
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: 4367

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
by Michel Zijlema
Thu Nov 03, 2016 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 iWidgets in Internet Explorer
Replies: 2
Views: 2690

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...
by Michel Zijlema
Thu Nov 03, 2016 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 iWidgets in Internet Explorer
Replies: 2
Views: 2690

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...
by Michel Zijlema
Fri Jul 15, 2016 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 43415

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?) ...
by Michel Zijlema
Fri Jul 15, 2016 4:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 43415

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
by Michel Zijlema
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: 8768

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...
by Michel Zijlema
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: 3461

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...
by Michel Zijlema
Wed Aug 26, 2015 5:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error : Operations Console
Replies: 2
Views: 3008

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...
by Michel Zijlema
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: 6796

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...