Error while viewing Analysis for office reports

[Former Member]

Hi All,

When we are viewing the AO reports in client tool, on clicking to DISPLAY tab for displaying the objects used, we get the error as-

The details is as-

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.NullReferenceException: Object reference not set to an instance of an object.

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnPropertiesControlQueryView.GetPropertiesEnabled()

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnPropertiesControlQueryView.Display(CoCommandContext iCommandContext)

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnProperties.Display(CoCommandContext iCommandContext)

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnNavigationPane.ControlCommandProcessor_ContextChanged(Object iSender, CoContextChangedEventArgs iEventArgs)

   at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.OnContextChanged(CoCommandContext iCommandContext)

   at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.CalculateContext(CoCommandContext iContext)

   at com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.CalculateContext(List`1 iViews)

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnTreeControl.OnAfterSelect(Object sender, EventArgs e)

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnQvTreeControl.OnAfterSelect(Object sender, EventArgs e)

   at com.sap.ip.bi.pioneer.controls.NavigationPane.CnTreeControl.OnMouseDown(Object sender, MouseEventArgs e)

   at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)

   at Syncfusion.Windows.Forms.ScrollControl.OnMouseDown(MouseEventArgs e)

   at Syncfusion.Windows.Forms.Tools.TreeViewAdv.OnMouseDown(MouseEventArgs e)

   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at Syncfusion.Windows.Forms.ScrollControl.WndProc(Message& msg)

   at Syncfusion.Windows.Forms.Tools.TreeViewAdv.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

I am not sure of what properties to set to view the DISPLAY tab objects.

Any help would be highly appreciated.

We are on BO 41. SP6 Patch 1, and AO 1.4

Regards,

Rohini Haksar

[Former Member]

Hi All,

This issue got resolved.

We did RSRV on the Bex and Data sources at BW level and issue from AO is gone now.

As we did make come changes in Structure at BW end, so that issue was coming.

Thank you.

Rohini Haksar.

[Former Member]

Hi,

I tried all settings available in AO tool but none is working .

Has anybody faced this similar issue without using VBA?

Inputs will be highly appreciated.

Thank you.

[TammyPowlas]

Hi - you are on a very old Analysis Office SP - please upgrade to at least SP13

[reyemsaibot]

Which AO 1.4 SP do you use?

[Former Member]

[antonette_oberholster]

Hallo Rohini

Does the report work in BEx?

Regards

Antonette

[antonette_oberholster]

And in AOLAP?

[Former Member]

Hi Antonette,

How do we check it in Bex.

And we are not using OLAP edition, so have not checked in that.

Regards,

Rohini Haksar

[antonette_oberholster]

Well I asume your report is running off a BEx query? Maybe the query has an issue. Is it only the one report or all reports in AOffice?

You can test the BEx queries using BEx Analyzer

Antonette

[Former Member]

No Antonette,

It is happening with all the AO reports..

And Bex is running fine as i have Webi reports also on top of that.

[reyemsaibot]

Hi,

do you logon via VBA? When the answer is yes, you have to refresh your datasource. (http://reyemsaibot.blogspot.de/2014/12/fehler-beim-herstellen-einer-verbindung.html)

Without refresh in Analysis Office nothing works.

http://scn.sap.com/docs/DOC-67244

Regards

Tobias

[Former Member]

Hi Tobias,

Thank you for your reply.

But there is no VBA used in this.

We login using BO and BW is backend.

Regards,

Rohini Haksar

[reyemsaibot]

Hi Rohini

have you refreshed the workbook before you click in the DISPLAY tab?

Regards

Tobias

[Former Member]

Even if i manually go and refresh data source, it still does not work.