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 many ways you can restrict data in business objects?
what is optional prompt in boxi r2
How to create universe in business objects enterprise 11.5
Tell me the difference between cmc and cms?
What is a Set?
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
difference between xir2 and 6.5 version
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
What is the local filter and global filter in bo's?