Search found 572 matches

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: 549

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 470 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: 745

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}, TM1FILTERBYLEVEL(TM1SUBSETALL([%d...
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: 42
Views: 5587

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: 673

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: 826

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: 826

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: 1858

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: 1547

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: 1547

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: 1465

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: 703

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: 703

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: 16792

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: 16792

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: 7
Views: 3930

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: 917

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: 930

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: 2232

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...
by Michel Zijlema
Mon Aug 10, 2015 9:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: make websheet repeating row headers visible
Replies: 4
Views: 2818

Re: make websheet repeating row headers visible

Resurrecting this thread from the dead... I noticed this technote from IBM, which states that conditional formatting should be working in both Excel and TM1 Web from 10.2.2 FP1 onwards: To see the hidden text in Excel you can change the color of the font by using a conditional format on the outer ro...
by Michel Zijlema
Wed Jul 01, 2015 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update Query in TI Process data tab
Replies: 1
Views: 1157

Re: Update Query in TI Process data tab

Hello All, Need a quick help. I have below statement in data tab but whenever i run the TI Process i get an error of SQL invalidity. sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month =''APR'' and year = 2015'; ODBCoutput(strOrcDB, EXPAND(sql)); Please let me know wh...