Search found 117 matches
- Thu Dec 06, 2018 4:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
- Replies: 2
- Views: 364
Re: SubsetFilterBySecurity - Rule [threads/tm1top]
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...
- Tue Dec 04, 2018 3:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
- Replies: 2
- Views: 364
SubsetFilterBySecurity - Rule [threads/tm1top]
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!
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!
- Fri Oct 19, 2018 1:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.0 - TM1Web reboot
- Replies: 5
- Views: 1041
Re: PA 2.0 - TM1Web reboot
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...
- Fri Oct 19, 2018 10:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.0 - TM1Web reboot
- Replies: 5
- Views: 1041
Re: PA 2.0 - TM1Web reboot
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...
- Fri Oct 19, 2018 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.0 - TM1Web reboot
- Replies: 5
- Views: 1041
PA 2.0 - TM1Web reboot
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
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
- Tue Jul 31, 2018 2:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 tools excel add-in not working in Excel 64 bit
- Replies: 15
- Views: 8714
Re: TM1 tools excel add-in not working in Excel 64 bit
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

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

- Thu Aug 10, 2017 5:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA - DSN for SQL Server instance
- Replies: 3
- Views: 1278
Re: PA - DSN for SQL Server instance
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
https://support.microsoft.com/en-us/hel ... r-2003-sp2
- Fri Aug 04, 2017 3:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA - DSN for SQL Server instance
- Replies: 3
- Views: 1278
Re: PA - DSN for SQL Server instance
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...
- Tue Aug 01, 2017 2:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA - DSN for SQL Server instance
- Replies: 3
- Views: 1278
PA - DSN for SQL Server instance
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!
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!
- Thu May 25, 2017 2:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Expression needed
- Replies: 7
- Views: 2180
Re: MDX Expression needed
{[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...
- Thu May 25, 2017 1:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: does ODBCOutPut( ) wait for sql to finish
- Replies: 1
- Views: 798
does ODBCOutPut( ) wait for sql to finish
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...
- Mon Dec 19, 2016 6:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: When parameter name is a function name
- Replies: 2
- Views: 897
Re: When parameter name is a function name
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 ...
- Sat Dec 17, 2016 2:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: When parameter name is a function name
- Replies: 2
- Views: 897
When parameter name is a function name
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...
- Tue Jun 21, 2016 5:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server freezes in SaveData
- Replies: 5
- Views: 1718
Re: Server freezes in SaveData
Hmm, I wonder if the x2 threads have something to do with it.
- Wed Aug 26, 2015 7:09 am
- Forum: General
- Topic: The Capt, Star Date 5000
- Replies: 2
- Views: 10388
Re: The Capt, Star Date 5000
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...
- Fri May 15, 2015 1:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Re-Customising (Customizing) Web after an Upgrade
- Replies: 5
- Views: 3663
Re: Re-Customising (Customizing) Web after an Upgrade
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...
- Thu Mar 05, 2015 4:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Ribbon deactivate or activate
- Replies: 2
- Views: 2374
Re: TM1 Ribbon deactivate or activate
And without losing the ribbon functions too!
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"
- Sat Feb 21, 2015 1:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA TM1StartOrionWithAutomation or CUBES_BROWSE not working
- Replies: 3
- Views: 2042
Re: VBA TM1StartOrionWithAutomation or CUBES_BROWSE not work
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 ...
- Fri Feb 20, 2015 12:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: if anyone's interested in debug.print T.I. to an html page
- Replies: 1
- Views: 1419
if anyone's interested in debug.print T.I. to an html page
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 ...
- Fri Jan 23, 2015 12:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Action Button's and VBA
- Replies: 5
- Views: 4592
Re: TM1 Action Button's and VBA
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...