Answer / alok

4.A junk dimension is grouping of low cardinality flags and indicators. Like for ex when some one processing a order .No all the information like prouct price order id these are important dimension . But if the information is like order place on phone or online, coupon applied or not . like that .

5. drill across directs the drill path to entirely different dimensions or reports across a spectrum of datasets.Like link to new Report . For one report

Answer / alok

This answer is copied from SCN SAP
You use query drill when your report contains aggregate measures calculated
at the database level. It is designed in particular to provide a drill mode
adapted to databases such as Oracle 9i OLAP, which contain aggregate
functions that Web Intelligence either does not support, or cannot calculate
accurately at the report level during a drill session.




The kinds of aggregate functions that are candidates for drilling in query drill
mode are: percentages, distinct counts, ranks, standard deviations and
variances, running aggregates, lead and lag functions. Because query drill
modifies the query at each drill operation, it ensures that these aggregates
are recalculated by the server each time you drill.
Query drill is also useful for reducing the amount of data that Web Intelligence
must store locally during a drill session. Because query drill reduces the
scope of analysis when you drill up, Web Intelligence is able to purge
unecessary data.



When you drill down, query drill behaves similarly to standard drill at the
point where the data moves outside the scope of analysis.


When Web Intelligence filters a drilled dimension in query drill mode it does
so by adding a query filter in addition to a drill filter. For example, if you drill
on Year=2001, Web Intelligence adds a filter at the query level to restrict the
Year dimension to 2001. For this reason, the only value that appears in the
drill toolbar for the drilled dimension is the value on which you drilled (in this
case 2001). This is different from standard drill mode, in which all values of
the dimension are visible in the toolbar. As a result, you cannot change filter
values in query drill mode (for example, drill on Year=2001 then switch to
Year=2003) as you can in standard drill mode.
Because query drill automatically extends the scope of analysis, you can
use it only if your BusinessObjects XI administrator has granted you the the
right to drill outside the scope. See your administrator for more details.

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 Answers  

---

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  

---

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  

---

wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

2 Answers   Accenture,

---

how to coneect to a server in a business objects

1 Answers  

---

Explain the difference between detect alias and detect context?

0 Answers  

---

What are the steps to be taken to schedule the report?

0 Answers  

---

in xir2 how to send reports to end user

2 Answers   TCS,

---

5.what is LOV? where it is store?

3 Answers   TCS,

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---

How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers   WinAlliance,

---