Which outer join is used in Merge Dimension.
Diff between merge and auto merge dimension.
Answers were Sorted based on User's Feedback
Answer / srikanthreddy
merge dimension leads full outer join,in webi- right click on query panel-document properties-you have a option called auto merge,when you trying to merge two universes it will automatically merge the dimensions.
Is This Answer Correct ? | 21 Yes | 2 No |
Answer / krishna
Yes, by default it will take full outer join, along with merged dimension, if you select any non-merged dimension from left/right data provider, then join will be either left outer/right outer join.
Is This Answer Correct ? | 3 Yes | 0 No |
Explain how to schedule the report in b.o?
HOW DO YOU SCHEDULE THE REPORTS?
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
What is the use of BO SDK?
what are the complex reports you have created. Tell me with example?
How you get the requirement from client?
what is diff between webi,deski,infoview
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
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?
Is it necessary to give joins to the aggrigate tables in the universe?