explain merge dimensions with real time in DWH?
Answer / 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 |
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
How to Avoid the overlaping the blocks in WEBI.
What is meant by ZABO and FC(full-client)?
11.what are the features in BO?
why we are using derived tables ?how it will help?
difference between web intelligence,crystal reports and desktop intelligents
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how to connect one to one report? Explain with example?
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
how to connect the hyperlink in webi reports?
what is the difference between bo and cognos?
WHAT IS SAP BO AND BO?