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 |
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
Any one suggest me best SAP Business Objects XI Online Training institute from India
Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
can we cretae views in universe level?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
Explain the BO Developer WORK FLOW?
What is batch processing in Business Objects?
How toconnect one to one report?