Interested to Buy Any Domain ? << Click Here >> for more details...
1.How is "Query drill" mode different from standard drill
mode?.
2.Under what circumstances are you most likely to choose to
use "Query drill" mode instead of standard query mode?.
3.How do you implement the type2 slowly changing dimensions
in your project?.
4.what is meant by Junk dimension?.
5.what is meant by Drill across?.
- 2 Answers
- 5772 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What three things do you consider to be the most important factors for a manager?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference between user and versatile user?
Explain what is the difference between business requirement document and use case document.
How would you format some text using css to be verdana and bold?
Explain about a time when you discovered a more efficient way to do a work task?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
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 are the join problems comes appart from loop,chasm & fan Traps
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
