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.

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.

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

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,

---

How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  

---

I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

6 Answers   Exilant, Siebel,

---

What is the link option in the reporting Environment?

3 Answers  

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

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

0 Answers  

---

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,

---

What is the merge dimension?

3 Answers   IBM,

---

How many ways you can restrict data in business objects?

5 Answers   TCS,

---