explain merge dimensions with real time in DWH?

Answer Posted / v.sivakumar

Merge dimension:

Merging of two common dimension from different table to
retrieve some values is known as merging dimension.

For Example:

Table 1: contains column Empid and Emp name
Table 2:Contains column Empid and salary

you have Requirement that the client need the emp name and
salary .

In this case we have to create two data provider one for
retrieving the data from table 1 and other for table 2.
and by merging Empid in the two data providers you can get
the value for emp name and salary

Is This Answer Correct ?    30 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a fantrap in business objects?

684


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

645


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10083


What is report template in b.o?

661


How to restrict password to a user while sending a document in .pdf format

1935






Explain how many universes can be created in a project?

721


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3097


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2071


How to generate the report from excel sheet?

701


Explain what are the measure objects?

641


Explain what task is 98% of the required work of a business analyst?

687


What we need to discuss with designer before starting the universe designing.

1914


in sap bi we have wad, then why we go for sap bo

2884


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

791


What is package in BO

2801