My data source is Excel sheet. How to write the SQL Statement for Excel file in

My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?

Question Posted / sathish

3 Answers
9153 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / guest

use personel data provider and use this excel to get the
data. Automatically it will create the SQL from excel.

Is This Answer Correct ?

4 Yes

0 No

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / obaidullah shareef

If we want to transfer the data from excel to Data base
table, you need to write one pl/sql code for that, this can
be easily done in Oracle Application with the help of
selecting the right table. This process is called inbound
interface in oracle apps and the file is called flat file.

Is This Answer Correct ?

1 Yes

1 No

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is i..

Answer / stalin

If you use the personal data provider ,it will generate the
report but it will not provide any SQL.

Otherwise ust the ETL(informatica or PL/SQL ) code and
store the data in any of the data base and then generate
the data througth universe or freehand sql.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Business Objects Interview Questions

can anybody tell me about issues faced while creating reports

3 Answers Accenture,

What is the difference between the public object&schema object?

0 Answers

What is the use of Surrogate key in BO?

8 Answers IBM,

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

0 Answers

Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers

what is optional prompt in boxi r2

4 Answers Mind Tree,

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers

how we improve the performance of report and universe?

4 Answers Accenture, IBM,

what is projection function in SAP BO

1 Answers Cap Gemini,

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 Answers

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

1 Answers IBM,

What three things do you consider to be the most important factors for a manager?

0 Answers

For more Business Objects Interview Questions Click Here