Interested to Buy Any Domain ? << Click Here >> for more details...
can any one say me exactly when and where alias and context
are used in resolving a loop.
If possible try to give me a scenario also.
- 3 Answers
- 7148 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vams_gk
when a schema contains a loop u should create alias
table..alias concept not only for loops.we can also use
in fantraps.
coming to context :when u run two sql statements as a
singlestatemnt we will go for context detection process.
in traps we can choose contexts.
traps are two types chasam trap and fan trap.
these traps are situvation oriented
relation betwen muliple tables like this:
--------------------------------------0-
chasam trap :1:M:1
fan trap :1:M 1:M
really if u want o see the context how to look
tools->automatic detection----.detect contexts in BO XIr2
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiran
small correction with chasm traps..its two one ends to
single table so that would be M:1:M relation between 3
tables..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sivakumar
Resolving loop: Alias is the best method
Fan trap: Alias.
Chasm Trap: Context.
| Is This Answer Correct ? | 0 Yes | 1 No |
. User wants to modify a report and wants to add additional data. How will you approach.
How will you test a BO report
what is fantrap?
how do u resolve contexts ?
How can we improve performance?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
What are steps to be taken care to create a good Universe?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
What are the security level used in BO?
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
Teradata 
