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

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,

---

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,

---

What is maximum number of promts we can give in a BO report?

1 Answers   Patni,

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

---

How toconnect one to one report?

4 Answers   iFlex,

---

how do u implement dense rank in a report?

1 Answers   CTS,

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,

---

HOW TO HIDE Column in WEBI & DESKI?

6 Answers  

---

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

2 Answers   Accenture,

---

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

---