Drill in WEBI Reports....?

[Former Member]

Hi everyone,

     I'm santosh kumar. Iam a fresher.

when Iam working on WEBI reports, I didn't understand the concept of drill..

even i made a report in WEBI  by taking the data source as universe.

so can anyone elaborate me clearly regarding the concept of drill in WEBI reports..

Thanks..

Kind Regards,

Santosh Kumar.

[Former Member · Accepted solution]

Hello Santosh,

Drill is basically used for analytical purpose. Lets take an example suppose you have Region Country State and Sales Revenue in your Report

Now currently your Report is showing All Data now you want to see how much sales a specific Region has generated then you further want to see under a region how much sales a country has generated then further down you want to see under a country how much sales a State has generated so that is called Drill Down.

Similarly when you go up the hierarchy its called a Drill Up.

There's another one Drill Through where report allows you to go from summary to detail. For instance: You have a financial application in which you can show the balance and profit and loss for a specific time frame. Every general ledger displays the total amount of all transactions for this specific period. By clicking (Drill through) on one of the general ledgers you will see the underlying transactions for this specific period. That means you can define your own analysis level.

Hope this helps.

Regards

Niraj

[Former Member · Accepted solution]

Thanks Niraj for your valuable information... now i got the clear idea about drill concept in webi reports.. now i can able to practice it..

Thanks,

kind regards,

santosh kumar.

[Former Member · Accepted solution]

Glad we were able to help you there is a nice Video link posted by Amit go through that that will also help you .

Please close the thread if you got the answer.

Regards

Niraj

[former_member198519]

Check these Blog as well:

Dave’s Adventures in Business Intelligence » Drilling to Details

Drill down and Drill across in WEBI « HOW TO Business Intelligence

[amitrathi239]

check this.Search on google you will get couple of youtube videos.