Planning Analytics

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

We have logged calls with IBM and they upgrade PASS in our dev environment, awaiting updates to PA.

There is maintenance scheduled for tonight so may be for PA upgrade.

For local, you may need to log a ticket to access the interim fixes. I have not seen them in FixCentral for ages.

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Talking with support .....

No need PA 2.0.18 IF2, 

Need recent PAW .... I upgrade it to 2.0.89

Of course, I retry  !

No better result ....

I continue talking with Ibm support

regards,

Philippe

We have logged calls with IBM and they upgrade PASS in our dev environment, awaiting updates to PA.

There is maintenance scheduled for tonight so may be for PA upgrade.

For local, you may need to log a ticket to access the interim fixes. I have not seen them in FixCentral for ages.

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

PAW 2.0.90 is now available for download.

Talking with support .....

No need PA 2.0.18 IF2, 

Need recent PAW .... I upgrade it to 2.0.89

Of course, I retry  !

No better result ....

I continue talking with Ibm support

regards,

Philippe

We have logged calls with IBM and they upgrade PASS in our dev environment, awaiting updates to PA.

There is maintenance scheduled for tonight so may be for PA upgrade.

For local, you may need to log a ticket to access the interim fixes. I have not seen them in FixCentral for ages.

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Dowloaded

Installed

Upgraded

....Too bad the Universal Report still doesn't work :-(

PAW 2.0.90 is now available for download.

Talking with support .....

No need PA 2.0.18 IF2, 

Need recent PAW .... I upgrade it to 2.0.89

Of course, I retry  !

No better result ....

I continue talking with Ibm support

regards,

Philippe

We have logged calls with IBM and they upgrade PASS in our dev environment, awaiting updates to PA.

There is maintenance scheduled for tonight so may be for PA upgrade.

For local, you may need to log a ticket to access the interim fixes. I have not seen them in FixCentral for ages.

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

It seems you have made more progress than me.

I have installed server 2.0.9.18 with PAW PASS and PAfE 2.0.90 and the option doesn't appear for me when either I right click in the task pane or I use the viewer 'convert to' option.  The new viewer member spacer function exists so I know I'm dealing with the correct version. 

I'll follow your progress.

Dowloaded

Installed

Upgraded

....Too bad the Universal Report still doesn't work :-(

PAW 2.0.90 is now available for download.

Talking with support .....

No need PA 2.0.18 IF2, 

Need recent PAW .... I upgrade it to 2.0.89

Of course, I retry  !

No better result ....

I continue talking with Ibm support

regards,

Philippe

We have logged calls with IBM and they upgrade PASS in our dev environment, awaiting updates to PA.

There is maintenance scheduled for tonight so may be for PA upgrade.

For local, you may need to log a ticket to access the interim fixes. I have not seen them in FixCentral for ages.

Heu ....

I read that "cloud" customer must ask to have 2.0.9.18 IF2.

I am "local" and try to download 2.0.9.18 (2.0.9.18_3) via fix central ..... but don't find any IF2.

I will try with this upgrade....

Or 

Any idea to get the IF2 for local customer ?

Regards,

Philippe

No problem, I did the same last week and tried to test on PAoC and had a similar outcome.

Thanks George!

I rushed to test and, of course, didn't read all the prerequisites (sorry)!
I'll upgrade and test again!

kind regards,

Philippe

HI Philippe,

What about you PA version - did you upgrade the TM1 Server to 2.0.9.18 IF2?

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

This indicates either an environmental/content concern, or a software fault in PAfE, and is less likely to be relevant to other software component versions. Please open a support case so we can coordinate the resolution.

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

Hello !

Souvent by ibm support .

I need to have Excel localized English. ;-(

Regards

Philippe 

This indicates either an environmental/content concern, or a software fault in PAfE, and is less likely to be relevant to other software component versions. Please open a support case so we can coordinate the resolution.

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe

This indicates either an environmental/content concern, or a software fault in PAfE, and is less likely to be relevant to other software component versions. Please open a support case so we can coordinate the resolution.

Hello Ladies and Gentlemen !

I wanted to try the new Pafe functionality : Universal Report.

I upgrade my tm1Web to 2.0.90 (tm1web-11.0.90-23082417-winx64h)
I upgrade my Pafe to 2.0.90 (IBM_PAfE_x64_2.0.90.11)
I have  Excel : 2019 MSO (16.0.10401.20025) 64 bits
I have Workspace 2.0.84

When I try to generate an Universal Report, I obtain :
System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
   à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   à Microsoft.Office.Interop.Excel.Name.get_RefersToRange()
   à Cognos.Office.Excel.Name.get_RefersToRange()
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.BuildDQRFromCommonViewSpec(Worksheet sheet, Element commonView, Element axisSets, IDataProvider dp, GridCoordinate start, DQRView dqr)
   à Cognos.Office.Reporting.TM1.DQR.DQRConverter.Convert(GridCoordinate start, Element commonViewSpec, IDataProvider dataProvider, FormulaConvertType convertType)
   à Cognos.Office.Reporting.UILayer.ReportConverter.ConvertReport(GridCoordinate coord, FormulaConvertType convertType, IDataProvider dp, IReportUI uiInstance, Element commonViewDefinition)
   à Cognos.Office.Reporting.UILayer.LaunchManager.OpenFromWebEvent(IDataProvider dp, IMetadataProvider metadp, Element commonViewDefinition, ReportUIType type)

Can you help me ?

Kind regards,
Philippe