Interested to Buy Any Domain ? << Click Here >> for more details...
what is crosstab reporting,slice and dise and drill mode??
- 3 Answers
- 12522 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothi
Tabular reports is a 2D format and most of the
operational/formated reports will be created in tabular
form.
Cross tab reports is a 3D format and most of the analytical
reports are created in the cross tab report form.
Slice and dice allows us to show and hide the objects,
whereas drill allows us to drill the data like drill up,
drill down, drill through depending upon the user
requirements. With slice and dice, you change the postion
of the data like moving the data from rows to columns.
Drill mode allows you to analyze the data in different
angles and different levels of details.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / v.sivakumar
Crosstab Report:
Crosstab must have one measure object and 2 dimension
object.
measure object wii be placed in the body and dimension
object in the rows and column of the report.its some what
as three dimensional format.
Slice and Dice:
Its an three dimensional view, we can retrieve data on
different views.
We can replace the position of the object, we can sort the
object etc..
Slicing and dicing a cube allows an end-
user to do the same thing with multiple dimensions.
drill Mode:
Drill mode is used to view the data in different level
(ie.. from higherto lower level and vice versa.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ramesh
Crosstabreport:Its one of the template in WEBI.normally table having rows and columns.but it crosstab report we have three columns,rows,body.columns and rows can be interchanged here.usually rows and columns are dimensions.but boeedy must be measure(facts) ex:salesrevenue
Slice and dice:the veiwing of data in different perspectives.and it can be achivedby drill
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
explain merge dimensions with real time in DWH?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
is it possible to export the webi reports to crystal reports?with out using businessview?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
Can we create universe with no cache??
use scheduler to refresh report.....explain please.....
how many times can use the union operator in a report?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
Explain in detail about type 1?
What is drill across ? can anybody explain me in detail?
Teradata 
