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
Tm1 pax - first opening report not connected to TM1 if Task pane not enabled manually
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14