Skip to Content
0
Former Member
Sep 20, 2011 at 04:16 PM

Drilldown through category

18 Views

Hi Guru:

We have a category hierarchy which looks perfect from BW side.

However, when we run the spend by category report, and then drilldown from one node, it gives the below error, seems it has problem to get the lower level nodes in the hierarchy.

I tried the BW query side, it works fine. I also looked at the SM21, ST22, no dump, no error in the system log, we did a BW trace

I did a trace when clicking on the node to drilldown at the ABAP side, nothing happened, seems this drilldown is purely at Java side.

Also, I tried the spend by supplier report, it could drilldown without problem.

Any suggestion on this?

Thanks a lot.

Best regards,

Eric

09/20/2011 11:00:54 AM:Event Error occured from server Failed

Details

java.lang.NullPointerException

at com.sap.analytics.aui.bi.impl.NavigationDimension.nextlevel(NavigationDimension.java:561)

at com.sap.analytics.aui.bi.impl.NavigationDimension.getConvertedDto(NavigationDimension.java:649)

at com.sap.analytics.aui.bi.impl.BIDataServiceImpl.findChildMembers(BIDataServiceImpl.java:316)

at com.sap.analytics.aui.bi.nw.NWBIDataService.findChildMembers(NWBIDataService.java:142)

at com.sap.analytics.aui.bi.resource.ChildMembersResource.postJSONValue(ChildMembersResource.java:110)

at com.sap.analytics.aui.core.RequestProcessor.processJSONRequest(RequestProcessor.java:145)

at com.sap.analytics.aui.core.RequestProcessor.processJSONRequest(RequestProcessor.java:241)

at com.sap.analytics.aui.core.FrontController.doPost(FrontController.java:200)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)