What is the drill up , drill down, drill by , drill trough ?

What is the drill up , drill down, drill by , drill
trough ?

Question Posted / guest

3 Answers
20112 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the drill up , drill down, drill by , drill trough ?..

drill-down means analysing the in different levels going to
the down let us eg as year--->quarter,quarte---> month and
so on
drill-up means analysing the in different levels going to
the up let us eg as month--->quarter,quarte---> year and
so on

Is This Answer Correct ?

15 Yes

3 No

What is the drill up , drill down, drill by , drill trough ?..

Answer / nameer

Drilling is a technique that enables you to analyse the
data in your report on different levels of detail.

Drilling down: It means displaying progressively more
detailed data.

Drilling up: It means you display data at a less detailed
level.

Drill By: Allows you to go straight to a particular level
in the hierarchy without having to visit each level in turn

Drilling Through :
When you are drilling on a heirarchy,you may need to drill
further than the scope of analysis allows.Rather than
setting up the scope of analysis back in the query
panel,you can use a short cut that lets you add more
drillable dimensions from the other heirarchy. This process
of appending more dimensions on-the-fly is called drilling
through.

Drilling Across:
The process of selecting the level of analysis directly in
the different heirarchy is known as drilling across. That
means we can set some navigation path which will help us to
navigate directly to the target for drilling.

Here i would like to add one more terminology called
snapshot:

Snapshot: You may want to keep track of the different
levels of analysis that you reveal as you drill into your
data. You can do this by taking a snapshot of the report at
any stage. When you take a snapshot, BusinessObjects
creates a copy of the report in a new tab inside the
document.

Is This Answer Correct ?

11 Yes

1 No

What is the drill up , drill down, drill by , drill trough ?..

Answer / raja

Suppose i have set the hierachy in the universe as
Country->State->City->Region

Drill down and Drill up= I have a report which shows country
and revenue,when i do drill down i will the report as State
and revenue,further i will get city and revenue.But in case
of drill up ,when i say drill up from city,revenue i will
get state and revenue and goes on.

Drill By-You can select the object through which you can
apply the drill.

Drill Through-Suppose i am drilling down by
country->state,suddenly i want to drill on drill hierarchy
say i want select sales manager from the other class.