cancel
Showing results for 
Search instead for 
Did you mean: 

Drilldown through category

Former Member
0 Kudos

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)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Vimal:

Our hierarchy is created, and looks perfect from BW side - Actually we used the program to create the hierarchy too:)

We could execute the spend by category report and see the first level, we got this message when we try to drilldown.

Thanks a lot.

Best regards,

Eric

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Eric,

Open the query 0ASA_MP01_Q1002 select the dimension 0XAREWCCAT. Check whether the hierarchy is activated. Else activate it and select the hierarchy name as CATEGORY.

Warm Regards,

Vimal G

Answers (0)