Drill down in reports

[Former Member]

Hi,

when I want to work with drill downs is this only possible with using hierarchies for the neccessary characteristics?

I'm working with SAP BW 3.5 and 7.

Thanks in advance.

Edited by: saplaz on Jun 23, 2010 11:11 PM

[Pravender · Accepted solution]

You can drill down the hierarchies in reports both in 3.5 and BI7.

Could you explain more about your requirement?

Are you planning to create a hierarchy of chracterstics?

It would be better if you will use navigation attributes and transitive attributes in that case. Which can be drill down in reports.

[Former Member · Accepted solution]

I want to do something like this:

Class 1 with the value 1000

when I drill down I can see the values of the other classes

Class 1.1 500

Class 1.2 300

Class 1.3 200

[Pravender · Accepted solution]

You can manually maintain (create) a hierarchy for characterstic class and use that in reports.

[Former Member · Accepted solution]

Thats my problem. I don´t know how. The books I´ve read only say that hierarchies are possible on dimensions, navigational attributes and external hierarchies. But there are no examples available.

[Pravender · Accepted solution]

Goto infoobjects tab of RSA1 --> Right click on the infoobject for which you wants to create a hierarchy --> Create Hierarchy

Pravender

[Former Member · Accepted solution]

For example:

if I have an infoobject risk class (characteristic) which contains risk classes 1, 2, and 3.

I have also infoobjects customers and turn over.

I would like to see something like that:

Risk class 1 1000 Dollar

after drill down:

Risk class 1.1 customerX 500 Dollar

Risk class 1.2 customerY 300 Dollar

Risk class 1.3 customerZ 200 Dollar

[Former Member · Accepted solution]

Thanks for the help guys (I´m a newbie ;-).

I´m little closer and I have first results. Now I´m doing some tests but I´m sure that I will have further questions.

[Former Member · Accepted solution]

The report shows for example:

Risk class 1 customerX 500 Dollar

customerY 300 Dollar

customerZ 200 Dollar

Sum 1000

after drill down

Risk class 1.1 customerX 500 Dollar

Sum 500

Risk class 1.2 customerY 300 Dollar

Sum 300

Risk class 1.3 customerZ 200 Dollar

Sum 200

The thing is that I only want to see one row with the risk class like that:

Risk class 1 1000 Dollar

after the drill down the other rows should appear

Rc 1.1 customerX 500 Dollar

Rc 1.2 customerY 300 Dollar

Rc 1.3 customerZ 200 Dollar

Any ideas how this could be done?

[Pravender · Accepted solution]

You can drill up the hierarchy then it will display only one row.

You can change the setting in the query --> Click on characterstic --> In Properties --> Hierarchy tab --> Expand to level.

Change this value. Give the level as top one. So by default it will show only the first row. If you want you can drill down in Bex analyser.

Pravender

[Former Member]

Hi,

If are talking about drilling down in BEx reports in general, you will be able to drilldown across any infoobject if you have made that infoobject as Navigational attribute during modeling.

You will be able to see the Navigational attribute option in attribute Tab. You just need to turn on(check box)

Regards,

Pavan

[Former Member]

Hi,

if you mean drilldown on a specific characteristic to the lower level children of that characteristic value - yes, this is the only drilldown process. You can also use the DISPLAY hierarchy functionality in the Query Designer to group a set of characteristics together in a dynamic hierarchy. This will allow you to do a drilldown from characteristic to characteristic versus on values within a characteristic.

For example, if you use SALES ORG, DIST CHANNEL, and DIVISION in a query ROW and turn on DISPLAY HIERARCHY you will be able to drilldown from sales org >> dist channel >> division. the standard hierarchy for example Cost Centers - you will be able to drilldown from higher node to a lower node but only with the use of a hierarchy.

Does this answer your question. Thanks, Pete