Search found 11 matches

by stuartbarnes27
Wed Oct 24, 2018 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Automation
Replies: 15
Views: 10807

Re: Cognos Automation

I believe I got it to work, but seems to be inconsistent. I would not delete the Cognos_Office_Connection_Cache worksheet, it is hidden for a reason and is most likely needed by PAX. IBM were absolutely no help at all getting CognosAutomation to work, I'm not convinced any of their support people kn...
by stuartbarnes27
Tue Oct 23, 2018 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Automation
Replies: 15
Views: 10807

Re: Cognos Automation

After a lot of digging I was able to locate a piece of VBA code that could select the IBM Planning Analytics ribbon. See attached VBA module. It would not let me attach the .bas file, so just change the extension on the txt file to .bas To call it use the Sub Switchtab: SwitchTab "IBM" + C...
by stuartbarnes27
Mon Oct 22, 2018 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Automation
Replies: 15
Views: 10807

Re: Cognos Automation

Are you saying that I would need to manually click on the PAX ribbon before running any VBA code to connect and refresh worksheets? The whole idea is to automate the calculation of these workbooks, if we have to manually click on the ribbon that would defeat the whole purpose. And to confirm, for th...
by stuartbarnes27
Fri Oct 19, 2018 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Automation
Replies: 15
Views: 10807

Cognos Automation

Has anyone managed to get the Cognos Automation functionality to work in PAX. Either in VBA in Excel or outside of Excel with a VB script. I am trying to have a file open, connect to two TM1 servers and refresh all the data in the workbook, unlink all the data and then save the workbook as a differe...
by stuartbarnes27
Wed Sep 20, 2017 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0 - Integrated Login - Security Mode 2 and 3
Replies: 0
Views: 2209

Planning Analytics 2.0 - Integrated Login - Security Mode 2 and 3

I believe IBM is hoping to release a version of Planning Analytics in Q4 of this year that will support TM1 integrated login (mode 2 and 3) instead of having to use CAM. Does anyone know if they are still on track for that timeline? Is anyone helping Beta test or has an alternative workaround to get...
by stuartbarnes27
Mon Feb 15, 2016 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web SSO
Replies: 2
Views: 2675

TM1Web SSO

Has anyone managed to get the TM1Web SSO proxy setup and working as detailed on the IBM DevWorks site? https://www.ibm.com/developerworks/community/forums/html/topic?id=a24ead54-cc3e-47d5-9b6b-28ebeb4d4767 I originally got it working in my dev environment after much effort but now its not working an...
by stuartbarnes27
Tue Apr 07, 2015 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirosoft Visual Basic Error
Replies: 14
Views: 10726

Re: Mirosoft Visual Basic Error

I am using TM1 10.2 and still get this issue intermittently. I've reported it to IBM but without having a way to consistent reproduce the issue I cannot seem to get any kind of fix or workaround. I believe the issue is related to Active Forms and I think it has to do with the forms calculating autom...
by stuartbarnes27
Thu Jan 09, 2014 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 creating a drill through to a cube on another server
Replies: 2
Views: 3099

TM1 creating a drill through to a cube on another server

Has anyone been able to create a drill through from a cube on one TM1 server to a cube on another TM1 server? I was hoping to use the ODBO data source but it is disabled for drill processes. I also thought of trying to use the TM1 OLE DB connector to create an ODBC data source, but since TM1 is not ...
by stuartbarnes27
Thu Oct 17, 2013 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10 and arcplan integrated login
Replies: 2
Views: 3317

TM1 10 and arcplan integrated login

I am trying to get arcplan to connect to TM1 using integrated login. This used to work with TM1 9.5.2 and lower, but for some reason with TM1 10 or higher the integrated login no longer works. Does anyone know of anything that might have changed for the tm1api from TM1 9.5 to TM 10 that would affect...
by stuartbarnes27
Tue Jul 09, 2013 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executive Viewer changing Offspread members via URL API
Replies: 3
Views: 2801

Re: Executive Viewer changing Offspread members via URL API

I eventually dug around in the SetOffspreadContext.xslt file and found the following lines: <!-- Split the Offspread Dimension and Member pairs which are seperated by a '|' --> <!-- The Dimension and Member are seperated by a ':' --> It appears that it does work: OffspreadMembers=ITAM_Year:2012|ITAM...
by stuartbarnes27
Tue Jul 09, 2013 7:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executive Viewer changing Offspread members via URL API
Replies: 3
Views: 2801

Executive Viewer changing Offspread members via URL API

I am trying to open Executive Viewer reports from a TM1 Web sheet and dynamically pass the dimension selections from the websheet to change the Offspread selections (page headers) in the Executive Viewer report. There is no useable documentation supplied by IBM but when I contacted them they gave me...