Tm1 pax - first opening report not connected to TM1 if Task pane not enabled manually

Post Reply
kavitha2002
Posts: 72
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Tm1 pax - first opening report not connected to TM1 if Task pane not enabled manually

Post by kavitha2002 » Tue Oct 09, 2018 11:50 am

Hello Everyone,

I have created excel object via vb.net and called congnosOfficeAutomationExample.Logon() it connects to TM1 successfully. After successful connection I have opened the excel report but gives #Value! because I havent navigated to Task pane.

Then again I closed the report and opened the report after navigating to Menu->IBM Planning Analytics ->Connection -> Tm1 instance then loaded the TM1 data in Task pane. Now the reports works fine.

Note: This navigation to Task pane I have to do only one time then all the following reports are opened though I close the Task pane.

Is there any other function i can call after Logon() to make it open the Task pane with data for the particular instance automatically.

Thanks

Post Reply