what is crosstab reporting,slice and dise and drill mode??
- 3 Answers
- 11323 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 |
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
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the difference between datawarehousing and businessintelligence?
why do we use crystal reports rather than webintelligence reports ?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
What are all difference between business objects 6.5 and xi r2?
How to Avoid the overlaping the blocks in WEBI.
Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx
What is the difference between Sychronisatio and join?
Can anyone plz tell me How to create universe in business objects enterprise 11.5
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?
How we drill up week to month?
Teradata 
