Which outer join is used in Merge Dimension.
Diff between merge and auto merge dimension.
Answer Posted / 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 |
Post New Answer View All Answers
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
(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.
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is aggregate table and aggregate fact table ... Any examples of both?
Give some information on report bursting?
Explain what is the difference between slice and dice and cross tab report?
Explain about a tricky situation for which you found a very simple solution?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
When we use aggregate awareness function in designer?
any difficulitis have you phase while creating bo reports and how did u solve it