Drill down and Drill up

[Former Member]

hi,

I need to explain to a team, how drill down works. I mean, what are all the properties that I should set for an infoobject to do drill down and drill up on it.

also, the purpose of hierarchies is drill down? I didnt understand.

thanks.

[Former Member · Accepted solution]

The drilldown and drillup feature is set and achieved in the report by designing in the query designer.

In the Query Designer if you push a characteristic in "Free Characteristic" then details for this characteristic won't appear in the report.To see the details for these characteristic you have to drill down the original report.

For Example you have 2 characteristic 0CUSTOMER,0CALDAY and you are displaying KFs "No of Orders" and "Order Value".

Now if you have both characteristic in the ROWS section in the query designer the report will show Customerwise Daywise Total Order and Sum of Order values.

Push the 0CALDAY to Free Characteristic.Now you will see only Customer wise No of orders and Value.Right Click you will find an option to drilldown to 0CALDAY and when you select you will be able to see Customerwise Daywise details.

Hierarchies by default shows the first node and you can drill down to its children.

Navigational Attribute behaves as a characteristic in the infocube with which you will be able to restriction as well as drill down/up.

Regs

Gopi

Assign points if it helps ....

Message was edited by: Gopi

[Former Member]

gopi,

your answer is simple and clear. If you want to let me know more details about drill down reports. please let me know. and please tell me how is navigational attribute relevant to drill down.

thanks.

[Former Member]

As I told before Navigational Attribute behaves as any other characteristic in the infocube with which you will be able to restriction as well as drill down/up.

It is possible to drilldown(not really) using RRI (Report to Report Interfaces) where from One Query Result you can jump to another query.

Eg: In the previous example you are showing daywise/monthwise orders and if the user wants in a particular month what are all the Top 10 Materials for which orders are placed then you may have another query for this and you can jump into that particular query.

I found something more .....

You can drill down from BI to OLTP system(R/3) to show the details.See the Document in link https://websmp101.sap-ag.de/bi Option Service and Implementation in that "How to ... Guides". Guide list SAP BW 2.X. How to drill down to OLTP sources.

(I prefer not to tell this b'coz you may end up in lot of problems!!!)

Regs

Gopi

Assign points if it helps ....

Message was edited by: Gopi

[Former Member]

How is declaring an Infoobject as a navigational attribute relevant to drill down and drill up?? pls. let me know.

[Former Member]

Hi Learner,

when you make an attribute as nav attribute it will act like other IO and will also be able to drildown and drillup like other independent IO when used as mentioned in my above post.

Hope this helps you....

[Former Member]

Hi,

Drilldown you mean in reports....well if you put the IO in the FreeChar you can drilldown with the required result set in the output.

Secondly, if the hierarchies(external) are used for Io in the query, it will be displayed in the form of tree which can be easily drilldowned. You should select the heirarchy in the properties of the IO and it will be displayed in the from of a tree.

Other type can be called as RRI where you can drilldown to another report from the current report.

hope this helps you....