Search found 120 matches
- 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: 3129
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...
- 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: 3957
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 ...
- 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: 3957
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.
Just wondering if a PAX/PAFE version was ever put together.
- Thu Dec 06, 2018 4:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
- Replies: 2
- Views: 2002
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: 2002
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: 4851
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: 4851
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: 4851
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: 16072
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: 3337
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: 3337
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: 3337
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: 5344
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: 2318
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: 2377
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: 2377
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...
- Tue Jun 21, 2016 5:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server freezes in SaveData
- Replies: 5
- Views: 4496
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: 16087
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: 6455
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: 4110
Re: TM1 Ribbon deactivate or activate
And without losing the ribbon functions too!
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"