TM1 Forum

You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver Actually, IBM created a new 32bit proxy for 10.2.2, so this shouldn't be a concern - https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/c_enable...

If you click on the community name, you get taken to https://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=52c51723-5949-4a0c-b643-93dfff320fef From there under the files section you can find the .zip file. For convenience the direct link is https://www.ibm.co...

There's also this option - https://www.ibm.com/developerworks/comm ... .2.2%20FP2

1. Believe it to be a standalone piece of java that doesn't require PAW, I think it has to be a fairly recent TM1 version or the correct API calls don't exist under the hood. I think it works with 10.2.2. (untested). So if you are on maintenance I guess you could download PA and just use the debugg...

But (and I'll be quite happy if I'm wrong about this) I don't believe that it allows you to step through AND edit the code AND dynamically assign values within a complete IDE in the style of Eclipse, the Visual Basic Editor, Visual Studio, etc, etc. Correct, it won't do that. Still I found it usefu...

AnonimusMax wrote:We are only using bulk load mode for an export to Oracle.

I've never heard of BLM being used for data export before. What's the reasoning?

Since crashing is pretty clearly a bug in the product, you'll find IBM to be the best resource for solving this. That being said, any chance you're using Bulk Load Mode at all for any of your data loads?

It's been a while since I've had anything to do with Performance Modeller, but I seem to recall it required setting ForceReevaluationOfFeedersForFedCellsOnDataChange=T for it's generated rules. That can have a big impact on performance too.

Is this documented somewhere? Certainly isn't here: http://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_parametersinthetm1s.cfgfile_n1503fe.html Unfortunately, I can't find any (official) documentation. I heard about it in a session at IBM's Vision con...

IBM put a new "pull invalidation subsets" feature into 10.3 (cloud) and PA 2.0 that might be related.

You could try adding in your tm1s.cfg and see if that avoids the crash.

Did you try searching the IBM documentation?

https://www.ibm.com/support/knowledgece ... chies.html

We are still scratching our heads as to why PAW is needed to run PAx when it is not required in TM1 10.2.2. PAx is utilizing the same exact set editor and cube viewer as PAW. Unfortunately, the code only exists in the PAW install and that's why PAW is required to access those parts of the PAx UI. Y...

harrytm1 wrote:Oh, by the way, spotted this function SubsetElementGetIndex. Is this available in previous version, or new to PAL 2.0? Seems like the function that we have all been waiting for!

It's in 10.2.2 FP6 too

The HTML form POST action does not allow arbitrary body text or even JSON formatted body text. That's why your example isn't working. Javascript is probably your best bet. Try googling 'javascript POST JSON'.

What errors are you getting when following those instructions?

It's important to note that just using a URL like that in a browser link won't work. The browser will make a GET request while the API requires a POST request with a body.

Just noticed this document about the debugger. https://developer.ibm.com/recipes/tutor ... r-debugger. Looks like HttpPortNumber isn't the only required config option.

I hope this isn't the final home, but the debugger is uploaded to https://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=51f0ea6b-1c8b-4e4d-9042-74d69ad84fe3#fullpageWidgetId=W8f78e5b97b1c_4f90_8fcb_de8eb32c26ad . There doesn't appear to be any other documentat...

I would merge the three subsets into one, so you can use that as data source in a TI, then step through all the elements in the data source and for each record do the following: 1. Get the size of the dimension. 2. Use the size as a counter 3. Starting with the last element in the dimension step ba...

Since this isn't in Production and overhead isn't as big of a concern you could try enabling some logging. [/code]log4j.logger.TM1.Server.Threads=DEBUG[/code] or even log4j.logger.TM1.Process=DEBUG log4j.logger.TM1.Process.Functions=INFO log4j.logger.TM1.Process.Functions.Parameters=INFO log4j.logge...

I've never heard of any issues with log4cxx dropping log messages.

Are the threads completing their work successfully, and just not logging a completion message? Or is the work not getting done?