Answer / prakash123

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

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.

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.

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  

---

Difference between b.o 5.1 and 6.1b?

0 Answers  

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

How do you find what type of trap is there by seeing the report?

4 Answers   TCS,

---

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers  

---

In banking domain how many Fact tables,Dimension table are present?

0 Answers   TCS, UST,

---

What is Complex Reports?

3 Answers   TCS,

---

what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,

---

BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,

---

How can we use multiple data providers in a single report in business objects?

2 Answers  

---

what are the debuggings in the business objects?

1 Answers   IBM,

---

How do you restrict access to rows of a database?

2 Answers  

---