Search found 329 matches

by Andy Key
Wed May 15, 2013 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Limiting Processing Cores for TM1 Server
Replies: 5
Views: 5171

Re: Limiting Processing Cores for TM1 Server

... or taking out one processor chip... Does that actually change the PVU rating? The IBM PVU Table states "Maximum number of sockets per server" rather than "Number of sockets that actually have a chip in them". So wouldn't it be necessary to change the motherboard? I've asked ...
by Andy Key
Thu May 02, 2013 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating subsets on }Cubes & }Dimensions
Replies: 15
Views: 8405

Re: Creating subsets on }Cubes & }Dimensions

I'm sure I have had subsets in control dimensions in the past without issue so I suspect this is new "functionality" that has arrived with 10.1. I don't think this is that new. I can't remember where I had this issue before, but a have a feeling it was at a client who was using CX, and if...
by Andy Key
Thu May 02, 2013 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to open TM1 WEB page
Replies: 6
Views: 4164

Re: Unable to open TM1 WEB page

Maybe you've done this already, but it might be worth having a look in the web.config itself. From memory there are a whole bunch of lines in there that are specific to .Net 4. I don't recall if you have to do something to include them, or exclude them.
by Andy Key
Thu May 02, 2013 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating subsets on }Cubes & }Dimensions
Replies: 15
Views: 8405

Re: Creating subsets on }Cubes & }Dimensions

Create a TI Process that has code to re-create the subsets in question, add that TI to a chore and specify that chore against the StartUpChores line in the tm1s.cfg.
by Andy Key
Fri Apr 12, 2013 4:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to get the Data Directory Location in TI?
Replies: 22
Views: 16179

Re: Is there a way to get the Data Directory Location in TI?

I'm with Paul on the parsing the cfg file route. Even if you don't know the absolute path to the DataBaseDirectory, you should have a consistent relative path from there to the directory that contains the cfg file. If you don't, you should do. When you create your process, point the DSN (for Client)...
by Andy Key
Fri Apr 12, 2013 3:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data value retains in web-sheets
Replies: 4
Views: 2942

Re: Data value retains in web-sheets

That way when you select it in one, the second will also pick it up via a DBRW (albeit needing a recalc if the second page was already open.) If you are using the 2d cube approach (which I do myself, as I find the passing of title elements via action button is, er, inconsistent) then use a DBR to t...
by Andy Key
Wed Mar 27, 2013 2:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button's Advanced Properties not working in TM1 web
Replies: 1
Views: 1684

Re: Action Button's Advanced Properties not working in TM1 w

I have had this issue in the past. I gave up using the Action Button method of transferring the values and used a Cube with some judicious dbsw and dbrw formulae instead.
by Andy Key
Mon Mar 25, 2013 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add string elements into consolidated elements in TI?
Replies: 4
Views: 7953

Re: How to add string elements into consolidated elements in

...string elements ... can't be added as a child in a consolidation. Not directly in a TI or through Dimension Editor, but as the OP says, you can add Simple elements as children (using either TI or DimEd) and then change their element type to String in Dimension Editor. Maintaining the dimension a...
by Andy Key
Mon Mar 25, 2013 7:40 am
Forum: Useful code, tips and tricks
Topic: Extended TM1top
Replies: 19
Views: 25862

Re: Extended TM1top

I can not end any process execute or object duplicate . There were issues with some of the early releases of 9 whereby threads showing ObjectDuplicate could hang the server. I don't have a copy of the 9.0 manuals, so check your documentation to see if ReceiveProgressResponseTimeoutSecs is available...
by Andy Key
Mon Mar 25, 2013 7:14 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 67293

Re: Another TM1 TOP

By default the installer will create environment variable pointing to TM1 9.5 default installation path "C:\Program Files\Cognos\TM1\bin" if your are using TM1 9.5 and installed on default location then no need to worry. Given that 10.1 onwards has a different default location would it be...
by Andy Key
Wed Mar 20, 2013 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Serialized messages in TM1 transaction logs
Replies: 4
Views: 3603

Re: Cube Serialized messages in TM1 transaction logs

We're talking about the Transaction log here, not the Message log. So I don't think changing anything in tm1s-log.properties will have any effect.
by Andy Key
Tue Mar 19, 2013 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Serialized messages in TM1 transaction logs
Replies: 4
Views: 3603

Re: Cube Serialized messages in TM1 transaction logs

As the CubeSerialized messages are in the Transaction Log to enable the most efficient use of the logs with CubeSaveData (rather than SaveDataAll) I doubt there would be a way of stopping them being added.
by Andy Key
Fri Feb 08, 2013 5:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cognos TM1 Performance Modeler
Replies: 1
Views: 1774

Re: IBM Cognos TM1 Performance Modeler

One of the new features of TM1 Applications in v10.1 (the new name for Contributor) is the ability to use WebSheets in your approval process. You still need to use the browser based interface (unless you want to replicate the workflow logic in Excel) and you have to manually tell the application whi...
by Andy Key
Wed Feb 06, 2013 5:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 55: Object Not Found for TM1 Websheet
Replies: 2
Views: 2370

Re: 55: Object Not Found for TM1 Websheet

Try reloading the navigation tree and open the web sheet again. It is possibly the case that you have deleted and then re-Uploaded a web sheet using an existing name. (Which seems to be a requirement these days as Updating websheets gives me a pile of garbage when I reopen them.) The issue is that t...
by Andy Key
Thu Jan 17, 2013 10:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating the Language Feed Files for Each TM1 Server
Replies: 1
Views: 1699

Re: Creating the Language Feed Files for Each TM1 Server

Hi All, I want to access TM1 data from cognos BI servers so as suggested by vendor I am following the below link http://pic.dhe.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.inst_cr_winux.10.1.1.doc%2Ft_buxtm1langfeed.html I need to configure tm1_en.properties file so can ...
by Andy Key
Thu Jan 03, 2013 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore status update (successful and unsuccessfull) to Email
Replies: 4
Views: 4452

Re: Chore status update (successful and unsuccessfull) to Em

You'll find plenty of solutions if you search the forum for EMail.
by Andy Key
Wed Dec 19, 2012 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To load data from files without placing them on TM1 server
Replies: 4
Views: 3253

Re: To load data from files without placing them on TM1 serv

When you preview the file, you are running the preview in the context of the user that you are currently logged on as, and using the file name as supplied in the Data Source Name box. When you execute the process, you are doing so in the context of the user account that is running the TM1 service, a...
by Andy Key
Tue Dec 18, 2012 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String in consolidation level
Replies: 18
Views: 17112

Re: String in consolidation level

declanr wrote:TM1 has no way of knowing what Quarter-1 should show based on the elements below it since Turnip + Ferrari + Spain = ???
Err, Turnip + Ferrari + Spain? Surely Quarter-1 should show Fernando Alonso...
by Andy Key
Tue Dec 18, 2012 7:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow TM1 10.1 Client Install
Replies: 3
Views: 3470

Re: Slow TM1 10.1 Client Install

I think it is down to the multinational help files. I did an install the other day and, just before I deleted all the languages that I am never going to use - so I can reclaim the GBs of disk space that these waste, I spotted that the directory creation times were about 6 minutes apart. 6 minutes by...
by Andy Key
Tue Nov 27, 2012 2:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AutoGenerated Rules not updating
Replies: 2
Views: 2581

Re: AutoGenerated Rules not updating

Have you made any changes in the rule in Architect/Perspectives? I would try shutting the server down, physically removing the .RUX file (and the .BLB if it exists) and restarting the server.