when to go for alias and when to go for contexts

Answer Posted / vams_gk

Alias,contexr these two we can used to resolve join
problems.whemn we found a loop in our scheema design we
will go for alias,when we are able to run two sql
statements as a single query we go for contexts.

we have option for these in our universe tool bar window

tools-->auto detection--.context or loop

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

8. How much supervision have you typically received in your previous job?

2010


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

1619


explain in detail about type 3?

784


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2022


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2170


What are the steps to do to use alerts in bo?

851


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2090


What is object stores?

759


Explain which versions are used in the bo dashboard work?

831


how to prepare the documentation in business objects and where to get the requirement?

1966


What three things do you consider to be the most important factors for a manager?

820


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1954


Did you face any problems while creating reports? Name? Solutions?

3460


Explain what are the steps to do to use alerts in bo?

796


What is Indexing? how did u implement indexing?

1990