Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vams_gk
join is very imp concept in BO
relation between two tables is called joins.
we have 4 types of join relations 1:m,m:1,m:m,1:1
types of joins in BO
1)equi join
2)theta join
3)outer join(left/right)
4)isolated join
5)short cut join
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain which versions are used in the bo dashboard work?
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
Explain what are the measure objects?
What is thumbnail?
Explain in detail about type 2(scd),
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
any difficulitis have you phase while creating bo reports and how did u solve it
What is the profile and package?
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?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain about alerts in bos, under what situation we need to use alerts?
What are the steps to be taken to schedule the report?
Explain how we drill up week to month?
What is aggregate table and aggregate fact table ... Any examples of both?
