Interested to Buy Any Domain ? << Click Here >> for more details...
How can we acheive Correlated sub-query in Designer?
- 2 Answers
- 16056 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 |
Can we have multiple domains?
what are the differences between web intelligence reports and crystal reports ?
who r the users in B.O.XIR2?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
When we are going for Shortcut join and why.
What are the diffrences between Business Objects 5.1 & 6.5 ?
What are the Users and Usergroups?
every alternative row should be hilighted ? how u can ?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
can i use stored procedure in webi?
can anybody tell me about issues faced while creating reports
(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.
Teradata 
