Page 1 of 1

Tm1 pax always shows the reports as #Name?

Posted: Fri Oct 05, 2018 7:09 am
by kavitha2002
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 protected mode, update not possible in IBM analytics.

excel function fx: tm1 is not available in dropdown ---DBR, DBRA functions are not listed...

But i have removed the protected mode, and tried but then has same problem.

Problem could be either of the above?


kindly give me detail information on that.

Thanks in advance.

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

Posted: Fri Oct 05, 2018 9:36 am
by Steve Rowe
Hi this happens because all the PAx add ins are not loaded. If you have the ribbon then the .com is loaded, if the excel functions are not working then you need to check the two excel add-ins are loaded as well.

These do occasionally seem to drop out...

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

Posted: Fri Oct 05, 2018 11:07 am
by kavitha2002
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?

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

Posted: Fri Oct 05, 2018 12:20 pm
by kavitha2002
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?

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

Posted: Thu Oct 11, 2018 2:13 pm
by kavitha2002
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", "CognosOfficeBI.xll"}
oCOMAddIn = _excel.COMAddIns.Item("CognosOffice12.Connect")
If Not oCOMAddIn.Connect Then oCOMAddIn.Connect = True
If (oCOMAddIn.Connect) Then
For Each oExcelAddIn In _excel.AddIns
For Each arrExcelAddIn As String In arrExcelAddIns
If oExcelAddIn.Name = arrExcelAddIn Then
oExcelAddIn.Installed = False
oExcelAddIn.Installed = True
End If
Next
Next

Now works great.