How will solve a loop caused by lookup table without using alias?
Answer / prasad
Context or shortcut join can be used to resolve loops.
| Is This Answer Correct ? | 10 Yes | 0 No |
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
while migrate bo 5.1 report into boxir2 ,what are the problems faced
Hi, How to navigate one report to another report in webi? Thanks in Advance
Explain about derived tables?
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
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:)
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
without creating the business view is there possible to create & generate the Crystal reports?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?