Difference between drill by and drill across with example?
Answers were Sorted based on User's Feedback
Answer / kiran
Drill By and Drill Across functionalities are same-
drilling by another dimesion or different view(viewing data
from different view of dimention).
Drill Down: is drilling within the same dimension,but with
diffrent levels of it.
| Is This Answer Correct ? | 8 Yes | 9 No |
Answer / nameer
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 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.
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / shiv
Drill Down-its for drilling down or drilling up one level
to another level by eliminating the immidiate levels
Drill Across-its for drilling from one hierarchie to
another hierarchie
example:-DRILLDOWN
customer customer
customer name customer address
customer id
customer address
customer phone
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / martha
Drilling across: display different data by choosing other
values from the drop down menu.Drilling across shows totals
for another value on the same level in the current
hierarchy.
| Is This Answer Correct ? | 4 Yes | 18 No |
What are universe parameters?
HOW TO HIDE Column in WEBI & DESKI?
What is mean by stored procedure ? and how we can generate stored procedure universe?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
what is mean by lov?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
how u restrict the values?to display 5 values insted of 10 values?
limitaions of cross tab ?
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
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
2 Answers Accenture, Rolta, TCS,
What is the report extension in webi and deski
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube