Tm1 pax - first opening report not connected to TM1 if Task pane not enabled manually
Posted: 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
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