Search found 117 matches

by yyi
Thu Dec 06, 2018 4:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
Replies: 2
Views: 300

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...
by yyi
Tue Dec 04, 2018 3:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
Replies: 2
Views: 300

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!
by yyi
Fri Oct 19, 2018 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 847

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...
by yyi
Fri Oct 19, 2018 10:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 847

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...
by yyi
Fri Oct 19, 2018 10:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 847

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
by yyi
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: 8376

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 :mrgreen:
by yyi
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: 1199

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
hotfix.PNG
hotfix.PNG (5.8 KiB) Viewed 1055 times
by yyi
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: 1199

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...
by yyi
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: 1199

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
PA_DSN.jpg
PA_DSN.jpg (31.57 KiB) Viewed 1199 times
so did/does anyone have any solution or workarounds to get the connection going?

Thanks!
by yyi
Thu May 25, 2017 2:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression needed
Replies: 7
Views: 2038

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...
by yyi
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: 737

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...
by yyi
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: 839

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 ...
by yyi
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: 839

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...
by yyi
Tue Jun 21, 2016 5:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server freezes in SaveData
Replies: 5
Views: 1607

Re: Server freezes in SaveData

Hmm, I wonder if the x2 threads have something to do with it.
by yyi
Wed Aug 26, 2015 7:09 am
Forum: General
Topic: The Capt, Star Date 5000
Replies: 2
Views: 3730

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...
by yyi
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: 3540

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...
by yyi
Thu Mar 05, 2015 4:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Ribbon deactivate or activate
Replies: 2
Views: 2318

Re: TM1 Ribbon deactivate or activate

And without losing the ribbon functions too!
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"
by yyi
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: 1958

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 ...
by yyi
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: 1366

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 ...
by yyi
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: 4486

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...