How can we acheive Correlated sub-query in Designer?
- 2 Answers
- 15194 Views
- Infosys, TCCX, Wells Fargo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prabha
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.
| Is This Answer Correct ? | 5 Yes | 17 No |
The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports
what is meant by scorecards?
what is the source for metrics?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
what is maximum scope of analysis --> can we define more than 3 levels?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
What is the test methodology for testing BO Universes?
Teradata 
