TM1 Forum

Thanks Paul, I checked out your suggestions and it turns out the thread (function, obj type) info might be a red herring. It became a problem when the data dir was upgraded to PA 2.0 from 10.2.2, the activeform that was using an mdx statement in the TM1RptRow( ) was not working like it did in 10.2.2...

Hi,

Does anyone know what this means? it's holding up the server and I'm not sure what's causing it except it happens when opening an excel template with an activeform. Function = SubsetFilterBySecurity, Object Type = Rule.


Thanks!

Well, after following 2 of the suggested fixes on the ibm site that still produced the same error - so annoying; I decided to just take a guess and delete the ..\tm1_64\configuration\cogstartup.xml file > start ibm cognos configuration again > [complains the file is missing] start with default setti...

Thanks Alan, yes I couldn't have guessed - I thought that was the application service for tm1 instances that runs on after the admin server. But now I have a cryptography error :( CAM-CRP1315 Current configuration points to a different Trust Domain than originally configured. [I'm thinking maybe bec...

Hi,

This is probably a dumb question but can someone tell me (on PAL) how to restart TM1Web?
I've been looking all over documentations and web searches and can't seem to find it anywhere.

Thanks

It's good!
thanks for sharing.


Nice to have it on ribbon. Works well with PAX for dynamic reports (after the addin check is disabled)
Maybe the next offering could be some extended functions using "Cognos Office Automation Server object" that installs with PAX

Well it turns out, that win svr 2003 sp2 running sql 2005 will work with a hotfix:-

https://support.microsoft.com/en-us/hel ... r-2003-sp2

Thanks kangkc, the link provided some clues and it appears in this case, the instance name could be a red herring. After some testing, connectivity problem starts with windows server 2003 running sql server 2005. Hopefully my support ticket with ibm may yield some answers...

I'm sure somebody has a SQL Server connection with an instance name connected to PA control ?
it's not possible to enter the backslash "\" in datasource host:port
so did/does anyone have any solution or workarounds to get the connection going?

Thanks!

{[PRODUCT].[A]} + {[PRODUCT].[B]} + {[PRODUCT].[C]} + {TM1FilterByLevel( Descendants([PRODUCT].[B^C]), 0)} just while I was refreshing the browser anxiously to see if anyone answered the question in my post (does anyone else do this I wonder..); I thought I'd add an idea to this thread - if there a...

It might be an obvious thing but I'm not sure right now, if odbc function is run in prolog and not the data source tab - and say the sql takes 3 minutes to run; does it wait before going onto the next statement in prolog or just keep going? pProcess = GetProcessName( ); dsnSQL = 'TM1_Finance'; ODBCO...

Thanks lotsa, I'm not sure why it didn't work when I changed it the first time - so I thought I had to keep it the same as the dimension name. Such an eeeeasy thing, should have just tried re-saving the process again. Feels a bit like the prolog contents disappearing sometimes when it gets a syntax ...

I was going to post this question but by the time I found my password for the forum, came up with the answer already. In case anyone else had this question I thought I'd share what happened; Cube with dimension name called "year" or "month" >> create drill process >> use dimension element name to co...

Hmm, I wonder if the x2 threads have something to do with it.

Congratulations Capt'n, and it was a privilege and honor serving under your command on the enterprise systems. My brief tour there remains the best times in the TM1 space. Recently I was briefly on board a borg vessel where I resisted assimilation that didn't go down well with the hive, so I'm now e...

http://www-01.ibm.com/support/knowledgecenter/SS9RXT_9.5.0/com.ibm.swg.im.cognos.tm1_wb.9.5.0.doc/tm1_wb_id5415DisplayingorHidingtheViewsNodeintheNavigat.html%23DisplayingorHidingtheViewsNodeintheNavigationPane_N510F6 Hi Alan, So is this still only a global option or do you know if it can be set per...

And without losing the ribbon functions too!
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"

Error message suggests excel can't reference the library containing the CUBES_BROWSE function. Unlike the public methods contained in the addin like tm1p.TM1RPTShowFormatArea or tm1p.TM1RebuildCurrentSheet, I think excel occasionally loses the object handle in memory. I don't have 64 bit excel, but ...

Hi Everyone, Not sure if this was already posted but a quick search didn't return anything similar so I've attached these 2 files. T.I. can be called without parameters to write some test lines to html file. If the file doesn't exist, it creates one and if it does it appends to file. {Set variables ...

Very useful code, thanks! :D Was needing to change properties in a list of action buttons displayed as hyperlinks. btw. an alternative to using progID's is Shape.Name eg: ... Dim vShape as Shape For Each vShape In sht.Shapes If Left(vShape.Name, 8) = "TIButton" Then Set tib = sht.OLEObjects(vShape.N...