Interested to Buy Any Domain ? << Click Here >> for more details...
What is the drill up , drill down, drill by , drill
trough ?
- 3 Answers
- 21384 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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.
| Is This Answer Correct ? | 4 Yes | 3 No |
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is a universe?
can i use stored procedure in webi?
Is it necessary to give joins to the aggrigate tables in the universe?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
how to do Ad-hoc reporting ?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is the difference between Thin client & thick client?
what are the documentations u r created?
When we are going for Shortcut join and why.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to change the order of prompts in universe?
Teradata 
