Answer / sathish arichandran

Merge option used for fetching more than one data providers
information into single report or block.

For example, employee information is available in different
database like some of the information in oracle and some of
information in sql server. But you need all these info into
single report. In that time merge dimension option is used
to achieve this task.

You need to create two universe(data provider) for each data
source and then u can merge the two data provider with
common dimension field. One thing important is u can merge
only the dimension object not measure object

In dimension object should be in same data type in both data
source. ex emp no should be number or varchar. mismatched
data type will give error.

Answer / simha

we can use merge option in webi, as like syncronization in 6.5
EX: if u open one Dp & generates the report after u select
another Dp u can link with in 2Dps same containg objects
like In 1st DP(Year,Q,Country,revenue),In 2nd
DP(Year,Q,quantity sold). --> Click Merge Option -->
automatically merge same type of dia objects.It is generated
in one report.

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,

---

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  

---

What is the difference between master-detail and Breaks?

3 Answers  

---

---

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,

---

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---

what is main functional differences between BO and COGNOs?

5 Answers   TCS,

---

any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....

2 Answers  

---

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

what is Scope of Analysis

8 Answers   TCS,

---