Search found 103 matches

by whitej_d
Thu Aug 25, 2016 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change TM1 server location - Service getting started from old location
Replies: 7
Views: 5109

Re: Change TM1 server location - Service getting started from old location

I reported this as a bug to IBM when v10.1 first came out. They told me it was expected behaviour!
by whitej_d
Thu Aug 25, 2016 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any benefits for using ViewConstruct in TI?
Replies: 2
Views: 3343

Re: Any benefits for using ViewConstruct in TI?

Hi, I might be wrong on this as it is a while and a few fix packs since I've done any detailed testing of this sort of thing, but I think... MTQ, VMM and VMT only applies to stargate caches. TI processes do not use stargate caches for their data source, so there won't be much improvement from pre-ca...
by whitej_d
Thu Feb 25, 2016 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic drop down
Replies: 6
Views: 4908

Re: Dynamic drop down

Or a similar post, showing basically the same thing in an active form!

http://www.infocatasia.com/tm1-tips/inf ... picklists/
by whitej_d
Tue Jun 30, 2015 11:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express 10.2 Fix Pack 3 Install Issues
Replies: 3
Views: 4263

Re: Cognos Express 10.2 Fix Pack 3 Install Issues

Did you have enough hard disk space when you installed the Fix Pack? Cognos Express requires an enormous amount of disk space, and even more while applying the fix pack. I've found it tends to fail silently if there isn't enough free space. If this is the case, then the only safe way I have found is...
by whitej_d
Fri May 22, 2015 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 used for reporting. Simple sparse cube report never ends
Replies: 11
Views: 9369

Re: TM1 used for reporting. Simple sparse cube report never

I know it's not so much of an issue with DQM, but I believe there is still some benefit to setting the useprovidercrossjointhreshold parameter in the qfs_config.xml file in BI. Might be worth playing around with, but it does not look like your doing too many cross joins. Another thing to consider is...
by whitej_d
Fri May 22, 2015 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 parameters all merged into one for xlsx excel
Replies: 1
Views: 2122

Re: TM1 10.2.2 parameters all merged into one for xlsx excel

The work around is to set your action button to get process info from sheet, and then use a range to define the parameters. This is much more reliable than selecting the parameters one by one as you have done. Alternatively, if you recreate the action button, you should be able to set it up again wi...
by whitej_d
Wed May 13, 2015 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API is great!
Replies: 9
Views: 12240

Re: TM1 REST API is great!

You can use any language you like. The rest api takes a url get or post and returns a json. There are libraries in most lanuguages for processing json output. We combined the rest api, with the java extensions called via TI to enable two tm1 servers to talk to each other directly, in our case perfor...
by whitej_d
Fri Feb 13, 2015 9:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Decimal precision
Replies: 11
Views: 13845

Re: Decimal precision

To provide more on my point, the following rule works, and evaluates ['Gross Revenue'] as 2.

Code: Select all

['Existing Stores Revenue'] = N: 1 / 1E20;
['New Stores revenue'] =  N: ['Existing Stores Revenue'] * 2;
['Gross Revenue'] = N: ['New Stores revenue'] * 1E20;
by whitej_d
Fri Feb 13, 2015 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Decimal precision
Replies: 11
Views: 13845

Re: Decimal precision

Someone will correct me if I'm wrong, but wouldn't TM1 be able to handle small numbers by using E-20 type stuff. For example 0.0000000000000345 would actually be 3.45E-14, therefore there should be no limit to the size of a number, large or small, only the precision. In the example given by the OP, ...
by whitej_d
Wed Feb 11, 2015 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disable rules in cube
Replies: 1
Views: 2260

Re: Disable rules in cube

Hi,

You can highlight the rule and then right-click -> Disable. This will comment out automatically generated rules (and/or feeders) in just the cube you do it for.
by whitej_d
Wed Dec 10, 2014 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web works, Application Web doesn't over WAN
Replies: 3
Views: 2883

Re: TM1Web works, Application Web doesn't over WAN

There's a config file, whih cshould be somewhere like "C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml" In it there's a parameter <service forceQualifiedPaths="true">. If you change it to false, then reconfigure the admin part of Applicat...
by whitej_d
Wed Dec 10, 2014 8:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQ with TM1 10.2.2 under W2003Server for TI
Replies: 7
Views: 6695

Re: MTQ with TM1 10.2.2 under W2003Server for TI

Hi, It's probably not well know, but the viewconstruct needs to be run in a sub-process called from the prolog of the parent process using an ExecuteProcess command in order for the data tab to use the cached view. It's worth noting though that ViewConstruct will cause locking and stop any PI from h...
by whitej_d
Wed Dec 10, 2014 8:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow performance from DBRW/CellGetN vs Cube Viewer
Replies: 10
Views: 6605

Re: Slow performance from DBRW/CellGetN vs Cube Viewer

There is an issue with cache on some versions of 9.5.2 and 10.1. I believe they are fixed in 9.5.2 FP3 and in v 10.2 onwards. If you are not on FP3 for 9.5.2 then applying this fix pack should solve your issue. The issue occurs when you change some data and do a SaveData. This causes TM1 to not trus...
by whitej_d
Tue Dec 02, 2014 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension in memory
Replies: 10
Views: 5979

Re: Dimension in memory

I've had dimensions of around 3 million elements, which were definitely significant in terms of memory - around 500 mb and was around the same size as the cube. This was quite an unusual situation though. On a related point, there is no way to load a dimension 'on demand', despite there being a prop...
by whitej_d
Fri Feb 28, 2014 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ensuring ODBC connection is closed
Replies: 7
Views: 5410

Re: Ensuring ODBC connection is closed

The interim fix mentioned is officially termed Interim Fix 1 by IBM, however there seems to be some confusion on IBMs part with the accompanying documentation which states IF2 in places. Another option might be to Open and close connections in a master process and run a sub-process to do the ODBC ou...
by whitej_d
Thu Feb 20, 2014 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 Operation Console with CAM
Replies: 9
Views: 9279

Re: 10.2 Operation Console with CAM

I did find the other day that the javascript pops up with a validation error, however if you pressed enter it would log in to Ops Console regardless.
by whitej_d
Thu Feb 20, 2014 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Guided Import is not working with Fix Pack 1 in TM1 10.2
Replies: 7
Views: 6255

Re: Guided Import is not working with Fix Pack 1 in TM1 10.2

It's a known issue.

1. Stop the TM1 Application Server service
2. Go to <TM1 install location>\Tomcat\work\catalina\localhost\ and delete or rename the pmhub and pmpsvc folder.
3. Restart the TM1 Application Server service.
by whitej_d
Thu Feb 13, 2014 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 Operation Console with CAM
Replies: 9
Views: 9279

Re: 10.2 Operation Console with CAM

You also need the Group setting to be the CAMID for the group, eg:

CAMID(":System Administrators")
by whitej_d
Thu Feb 13, 2014 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data save All taking Long time because of persistent feeders
Replies: 6
Views: 6807

Re: Data save All taking Long time because of persistent fee

When you restart the server, it should load the feeders straight into memory. The fact that it deletes them when you restart suggests something not quite right. TM1 would delete the feeders files and re-evaluate based on the timestamp of the .feeders file compared to the timestamp of the correspondi...
by whitej_d
Thu Feb 13, 2014 3:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2 Operation Console with CAM
Replies: 9
Views: 9279

Re: 10.2 Operation Console with CAM

I think you can use the nice version of the CAM Id.

It's something like Namespace\UserName.