PublishTm1 gives Error 438 Object doesn't support this property or method

[paulsimongb]

Neither the PublishTm1 nor PublishTm1Multiple work. Both give Object doesn't support this property or method errors.

As a general point, why can I not just put a '.' after the object to get a list of properties and methods that it supports as you can with any proper COM object?

The example shows this coming off CognosOfficeAutomationObject. Does it actually come off that or some sub-component. I tried .Reporting but that did not work either.

[tedphillips]

it is the case that it's off the automationObject, and i have seen the feedback on visibility/traversal from the object browser (will carve this off as an improvement topic).

can you include an example of the full line you're trying?

[tedphillips]

40

[tedphillips]

also, what PA for Excel version are you using?

[paulsimongb]

Hi Ted

Exact code is a bit more complex but I have tried cutting it down and it still fails to recognise the method

CognosOfficeAutomationObject.PublishTm1 sURL, sInstance, sPublishPath, sPathFile, sCurrWb, , , False, False

The parameters don't really matter as it is just not recognising the method PublishTM1.

It is still the older version with the three separate files. We have plans to upgrade to the single XLL but it will take time for IT to package that.

; Licensed Materials - Property of IBM ; BI and PM: is ; (C) Copyright IBM Corp. 2004, 2014 ; US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp

[Product Information]

LICENSE_CAFE_COR_version=LICENSE_CAFE_COR-AW64-ML-RTM-11.0.0.46-0 LICENSE_CAFE_COR_name=IBM Cognos License SWTAG_CAFE_COR_version=SWTAG_CAFE_COR-AW64-ML-RTM-11.0.0.18-0 SWTAG_CAFE_COR_name=SWTAG Analysis for Excel [Product Update Information]

[Main Applications]

COR_APP_version=COR_APP-AW64-ML-RTM-11.0.60.9-0 COR_APP_name=Cognos 8 Analysis for Excel CAFES_version=CAFES-AW64-ML-RTM-10.3.0.1-0 CAFES_name=Cafes for Excel CORREDIST_version=CORREDIST-AW64-ML-RTM-11.0.60.10-0 CORREDIST_name=IBM Planning Analytics for Excel COI_version=COI-AW64-ML-RTM-11.0.60.4-0 COI_name=IBM Cognos COI [Cognos Applications]

ISUNINST_version=TE-AW64-ML-RTM-11.0.1000.7-0 ISUNINST_name=IBM Cognos Uninstall Engine CORCSP_version=COR-AW64-ML-RTM-2.0.60.9-0 CORCSP_name=COR Uninstall

Regards

Paul Simon Senior TM1 Developer | Financial Data & Analytics @.*** To get in touch with the TM1 team, please raise a ticket herehttps://informa.service-now.com/iportal?id=sc_cat_item&sys_id=b81c568e1b41345049090e51f54bcb57.

This electronic message and all contents transmitted with it are confidential and may be privileged. They are intended solely for the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, distribution, copying or use of this message or taking any action in reliance on the contents of it is strictly prohibited. If you have received this electronic message in error, please destroy it immediately, and notify the sender.

Informa Group plc | Registered in England & Wales No. 3099067 | 5 Howick Place | London | SW1P 1WG

From: Ted Phillips @.> Sent: 09 December 2021 17:10 To: IBM/paxapi @.> Cc: paulsimongb @.>; Author @.> Subject: Re: [IBM/paxapi] PublishTm1 gives Error 438 Object doesn't support this property or method (Issue #39)

also, what PA for Excel version are you using?

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/IBM/paxapi/issues/39#issuecomment-990048146, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGHWSVSRICJQRKRIC5AGFNLUQDPFPANCNFSM5JPKU6QQ. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

Information Classification: General

[paulsimongb]

Hi Ted

I have now upgraded to the latest version of PAX (69)

I note that in the documentation it would appear that the line Set m_oCOAutomation = Application.COMAddIns("CognosOffice12").Object.AutomationServer needs to be changed to this, to work with the XLL only version Set m_oCOAutomation = Application.COMAddIns("CognosOffice12.ConnectPAfEAddin").Object.AutomationServer

I am now getting a slightly different error when it gets to oPax.PublishTm1 sURL, sInstance, sPublishPath, sPathFile, sCurrWb, , , False, False

Runt time error '5' Invalid procedure call or argument

oPax is an object set to the result of Application.COMAddIns("CognosOffice12.ConnectPAfEAddin").Object.AutomationServer

Please advise on what needs to be changed or whether there is a bug in PAX and this just doesn't work?

Regards

Paul Simon

[paulsimongb]

Hi Ted, Happy New Year. Has there been any progress on this, as we have a large number of sheets to promote and not being able to automate this is becoming a serious issue for us.. Regards Paul Simon

[paulsimongb]

Hi Ted, Has there been any progress on this? We need to be using this in the next few days to overcome other bugs in PA. Regards Paul Simon

[tedphillips]

need to understand the specific params being passed into the publishTM1 function, can post here if you like but can otherwise email me the details.

as per your previous message you have Cognos for Microsoft Office co-running so you do need to use the alternate progID to access the framework capabilities.

I don't believe the endpoint is wholly unworking, so it would likely be something specific to your use. such as the omission of a name - i don't believe that's optional.