Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
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_126.96.36.199)I have Excel : 2019 MSO (16.0.10401.20025) 64 bitsI 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 ?
What about you PA version - did you upgrade the TM1 Server to 188.8.131.52 IF2?
I rushed to test and, of course, didn't read all the prerequisites (sorry)!I'll upgrade and test again!
No problem, I did the same last week and tried to test on PAoC and had a similar outcome.
I read that "cloud" customer must ask to have 184.108.40.206 IF2.
I am "local" and try to download 220.127.116.11 (18.104.22.168_3) via fix central ..... but don't find any IF2.
I will try with this upgrade....
Any idea to get the IF2 for local customer ?
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.
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
PAW 2.0.90 is now available for download.
....Too bad the Universal Report still doesn't work :-(
It seems you have made more progress than me.
I have installed server 22.214.171.124 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.
I am very glad to tell : "Universal Report Work (for me) " !
After long talking with IBM support, I have :
- PA 126.96.36.199
- PAW 2.0.90 ( to be sur, I make Docker system prune -a to delete all previous container before install paw)
- PAFE 2.0.90
- PASS (tm1web) 2.0.90
And For the moment, my excel is configured in English (which is the ultimate condition for this to work).!
I can't say anything else.
Maybe I'm lucky, but mostly stubborn!
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.
Souvent by ibm support .
I need to have Excel localized English. ;-(
yes, i'm glad you got it working [to that pont] and we should still sort out any issues you've found. Please do share any additional feedback.
I found that TM1SET was no longer working (It previously did) so I set up TM1 Web's EvaluationService component and it all worked. Nb: All of our components are on the one Windows2019 server, but given it addressed the issue I have not explored that issue further.
Separately, where can we direct suggestions for improvements to UR?