Search found 120 matches

by yyi
Tue Mar 30, 2021 6:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending an email using PA on IBM Cloud
Replies: 3
Views: 3090

Re: Sending an email using PA on IBM Cloud

for multiple recipients, using $recipients = "email1@domain.com", "email2@domain.com" like in:- https://www.ibm.com/support/pages/planning-analytics-cloud-smtp-send-email-process-using-powershell-script if it doesn't work, then in .ps1 got this to accidently work; [array]$emailTo...
by yyi
Mon Mar 15, 2021 2:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 3909

Re: TM1Tools is there one for PAX

Thanks Capt'n for the really detailed reply! yeah I'm still doing a bit of tm1/paw stuff WFH. I can relate to that annoying paw install routine - the day I was introduced to powershell, after the nth time scrapping previous failed installations, by some great fluke the ./start.ps1 actually launched ...
by yyi
Sun Mar 14, 2021 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 3909

TM1Tools is there one for PAX

Been using this excel add-in for ages, the one made by Alan, Steve & Martin - namely the hierarchy documenter and formula trace. The forum search gave me a 0 result, maybe noone uses it anymore :?: or maybe I spelt it wrong.

Just wondering if a PAX/PAFE version was ever put together.
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: 1972

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: 1972

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: 4782

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: 4782

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: 4782

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: 15952

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: 3305

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 3161 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: 3305

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: 3305

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 3305 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: 5313

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: 2306

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: 2374

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: 2374

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 dimensio...
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: 4484

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: 15773

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: 6425

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: 4092

Re: TM1 Ribbon deactivate or activate

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