Answer / vikram

Drilling across:
When you drill down and up you move through the levels of
the same hierarchy. However, if you cannot find the answer
to a question by analyzing data in its current hierarchy,
you can move to another hierarchy to analyze other data.

Example: Move from analyzing Resort to Sales.Your report
displays data for Resort, which belongs to the Resort
hierarchy.
The report also contains Year, which belongs to the Sales
hierarchy, but the data for Year is not currently
displayed. If you drill across from Resort to Year,
you can then drill down on the next dimension in the Sales
hierarchy. You can also drill across to other hierarchies,
or back to the hierarchy you were originally working in.

Drilling across opens up new paths that you can follow
when analyzing data.
Before you can drill across, your report must contain
dimensions from more than one hierarchy. If this is not the
case, you can:
• Retrieve data for dimensions from more than one hierarchy
by expanding
your scope of analysis, or
• Create new hierarchies inside the report.

Thanks,
Vikram

how can u find the granularity in fact table

1 Answers   iGate,

---

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  

---

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers   Accenture,

---

what is difference between folders and category ?

4 Answers   Tech Mahindra,

---

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

---

---

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers   CSC,

---

how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,

---

What is a loop? How can we overcome?

5 Answers  

---

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

what is the source for metrics?

2 Answers  

---

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

---

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---