WHAT DOES SQL TAB CONTAIN?

Question Posted / 19-10-2011

1 Answers
5246 Views
Polaris, I also Faced
E-Mail Answers

WHAT DOES SQL TAB CONTAIN?..

Answer / 19-10-2011

IT CONTAINS CARTISIAN TAB,SET OPERATION LIKE UNION,MINUS.

Is This Answer Correct ?

7 Yes

1 No

Post New Answer

More Business Objects Interview Questions

WHAT IS SAP BO AND BO?

1 Answers

Hi any done business objects certification.i am expecting some help from them.

6 Answers

how to hide the prompts?

7 Answers TCS,

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:)

3 Answers

How were the reports scheduled and how to resolve unexecuted documents?

0 Answers

What are the types of errors you faced while creating a report from two different data providers

3 Answers IBM,

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers Cap Gemini, Deloitte,

what is master-detail report

3 Answers Patni, TCS,

What are the steps to be taken to schedule the report?

0 Answers

how to overcome overflow of data in a report