Search found 103 matches
- 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!
- 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...
- 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/
http://www.infocatasia.com/tm1-tips/inf ... picklists/
- 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...
- 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...
- 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...
- 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...
- 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;
- 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, ...
- 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.
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.
- 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...
- 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...
- 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...
- 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...
- 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...
- 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.
- 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.
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.
- 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")
CAMID(":System Administrators")
- 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...
- 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.
It's something like Namespace\UserName.