on 09-20-2011 5:16 PM
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)
Hi Eric,
Please check whether the hierarchies have been loaded in the BW side under 0XAEWCCAT.
We had experienced similiar problem due to non creation of category hierarchy using the standard process chain during data load. We had to use another ABAP routine to create the hierarchy in the system and the error was resolved.
Warm Regards,
Vimal Gasper
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
Just trying to trouble shoot...
1. Does your hierarchy start from a single node, i.e., Level 0 is the Root or All and subsequent hierarchical levels are below this node.
2. Are all the hierarchies having the same number of levels.
3. In the SPM report are you able to see the highest hierarchy level when you execute the report or the lowest level?
4. Instead of using the drill down functionality if you change the start level, does this error recur.
Warm Regards,
Vimal G
Hi:
We checked the navigation dimension of the Category in the data source administration.
it is blank.
We checked the other navigation dimension definition, they have the definition there.
We tried to manually insert the category and product into the navigation, could not save, guess because it is delivered?
We then create a custom navigation dimension for hierarchy, and use it replace the delivered category dimension in reports, it works.
Any idea? How to correct the delivered category dimension?
Thanks.
Eric
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.