Search found 73 matches

by kavitha2002
Tue Oct 16, 2018 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax - set focus on "IBM Planning Analytics" menu
Replies: 0
Views: 3

Tm1 pax - set focus on "IBM Planning Analytics" menu

Hello,

I would like to set the focus on "IBM Planning Analytics" menu in excel, when excel opens. I would like to do it in VBA.

Thanks
by kavitha2002
Fri Oct 12, 2018 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax DBRW() function
Replies: 5
Views: 239

Re: Tm1 pax DBRW() function

I tried conditional formatting in excel, but in some reports problem is active reports formatting is already applied. Say for example, White text for green background, black text white background, its dynamic based on the columns and rows changes in cube. In such a case, how to format the #VALUE! as...
by kavitha2002
Thu Oct 11, 2018 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax always shows the reports as #Name?
Replies: 4
Views: 137

Re: Tm1 pax always shows the reports as #Name?

I found what the exact problem. I have created excel object via my application, so addins are look like loaded in excel but those functions of the addins are not visible. I have activated the addins via code, and now its working. code snippet: Dim arrExcelAddIns() As String = {"CognosOfficeTM1.xll",...
by kavitha2002
Thu Oct 11, 2018 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax - IBM Cognos Office Automation outside VBA
Replies: 2
Views: 216

Re: Tm1 pax - IBM Cognos Office Automation outside VBA

I am using vb.net app for the handling excel objects and tm1 reports. So I though of rewriting the .bas file in vb.net and call the automationserver.logon() from vb.net. My code in vb.net is excelobj.COMAddIns.Item("CognosOffice12.Connect").object.AutomationServer which should return Cognos.Office.F...
by kavitha2002
Thu Oct 11, 2018 6:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax - IBM Cognos Office Automation outside VBA
Replies: 2
Views: 216

Tm1 pax - IBM Cognos Office Automation outside VBA

Hello Everyone, I would like to call the APIs for Pax outside VBA. Refer the below link https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_id_automatingcoc_550example-codeforprocessingoutsidevba.html Want to do the same in vb.net. But not clear what ...
by kavitha2002
Tue Oct 09, 2018 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax - first opening report not connected to TM1 if Task pane not enabled manually
Replies: 0
Views: 38

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

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 th...
by kavitha2002
Tue Oct 09, 2018 11:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax DBRW() function
Replies: 5
Views: 239

Re: Tm1 pax DBRW() function

I will try with conditional formatting. Thanks
by kavitha2002
Tue Oct 09, 2018 6:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax DBRW() function
Replies: 5
Views: 239

Tm1 pax DBRW() function

Hello Everyone,

I have used DBRW() in Active reports in Tm1 perspectives that gives "" when data not available for particular cell.

But same DBRW() in tm1 pax 2.0.5 version gives #Value!

Report looks bad when data not available.

Any suggestion on this. Thanks.
by kavitha2002
Mon Oct 08, 2018 6:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use Tm1 Pax Apis
Replies: 1
Views: 86

How to use Tm1 Pax Apis

Hi Everyone, 2.0.5 doesnt provide any support to marcos likes N_CONNECT, N_DISCONNECT etc. But I would like to convert our project to support pax as well. So using Logon and Logoff API methods, after importing cognosofficeAutomationExample.bas and .cls file in VBA from vb.net. What is your suggestio...
by kavitha2002
Sun Oct 07, 2018 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives or TM1 pax
Replies: 1
Views: 67

TM1 Perspectives or TM1 pax

Hi, I want to use either Tm1 perspectives or Tm1 pax in my application. Its depends on the End user which Tm1 client they have chosen. But by default IBM palnning analytics menu is coming in Excel, so how to disable the menu When user has chosen TM1 perspectives . Should I write a code in vb.net to ...
by kavitha2002
Sun Oct 07, 2018 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax Reports shows #WERT!
Replies: 3
Views: 210

Re: Tm1 Pax Reports shows #WERT!

Hi @Alan Kirk, Thanks for your reply. Actually I have installed Tm1 2.0.5 version recently .The reports which was working in older version of TM1 Perspectives is giving #value? in Tm1 Pax for some reports. Thanks for the Deutsch Translation. But I am not that good at Deutsch. Do have another questio...
by kavitha2002
Fri Oct 05, 2018 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax Reports shows #WERT!
Replies: 3
Views: 210

Tm1 Pax Reports shows #WERT!

Hello Everyone,

When I open the reports, its show data in some cells and some cell has #WERT? What could be the problem.

Connection is alive with Tm1 Server.


Any help is much appreciated. Thanks
by kavitha2002
Fri Oct 05, 2018 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax always shows the reports as #Name?
Replies: 4
Views: 137

Re: Tm1 pax always shows the reports as #Name?

Hi I have created the excel application via my vb.net app, all excel-add ins are available but functions are not shown so I open the CognosOfficeTM1.xll file then all functions are visible. Why its so??

Is there any conflicts with other addins?

How to fix it. Any setting in excel?
by kavitha2002
Fri Oct 05, 2018 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax always shows the reports as #Name?
Replies: 4
Views: 137

Re: Tm1 pax always shows the reports as #Name?

Hi,

Both the excel add-ins are already loaded. But no effect.

I am creating the excel Application from vb.net application, is this could create any problem?
by kavitha2002
Fri Oct 05, 2018 7:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax always shows the reports as #Name?
Replies: 4
Views: 137

Tm1 pax always shows the reports as #Name?

Hello Everyone, I have opened the Active reports in TM1 pax which was actually developed in tm1p. This works perfectly in excel stand alone. But When I open the report in my application which has excel plugin, it shows #Name?? What could be the issue? What i have to check? Error : excel is in protec...
by kavitha2002
Fri Oct 05, 2018 5:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 PAX plugin disappears
Replies: 3
Views: 177

Re: Tm1 PAX plugin disappears

Thanks.. I have changed the registry behaviour to 3 in regedit then it works perfectly
by kavitha2002
Thu Oct 04, 2018 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 PAX plugin disappears
Replies: 3
Views: 177

Tm1 PAX plugin disappears

Hello Everyone, I have a problem in TM1 PAx plugin, its was working fine, and suddenly crashed. Then IBM Planning Analytics Menu in excel was disappeared. I have tried adding it in excel addin, then close the excel and reopen. Again IBM Planning Analytics menu was not there. Any suggestions, welcome...
by kavitha2002
Mon Oct 01, 2018 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 perspectives equivalent Macro functions in Pax
Replies: 0
Views: 185

Tm1 perspectives equivalent Macro functions in Pax

Hello Everyone, I want to know what are the equivalent API methods in Pax for the following, M_clear TM1RebuildCurrentSheet - is equivalent to RefreshAllData() ?? TM1RECALC1 TM1RECALC W_DBSEnable Actaully I was using above macro functions for Active Reports in Tm1perpectives via .net appliaction. Bu...
by kavitha2002
Wed Sep 26, 2018 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax CognosOfficeAutomationObject.bas file in vb.net
Replies: 0
Views: 445

Tm1 Pax CognosOfficeAutomationObject.bas file in vb.net

Hello Everyone,

Anyone has idea of how to refer these two CognosOfficeAutomationObject.bas and CognosOfficeMessageSuppressor.cls files in vb.net project.

Tm1 Pax doesnt support macros instead it has APIs.

Any idea or suggestions, welcome.
by kavitha2002
Wed Sep 26, 2018 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Vb.net with Pax
Replies: 9
Views: 833

Re: Vb.net with Pax

Hi @bgregs, Thank you. I found it, it worked well. Its because of the case-sensitivity of fourth Parameter: example : host/TestInstance. Below worked: CognosOfficeAutomationExample.Logon("http://192.168.40.100", "admin", "admin", "localhost/Tm1 server instance") Paw IPaddress : http://192.168.40.100...