Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / sathish

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

How can you access your repository with different user profiles?

2 Answers   TCS,

Can you please send me the migration related issues .

0 Answers  

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

What is the sheduling the report? What is the need of sheduling the report?

1 Answers   Wipro,

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,

what will be the contents for a functional requirements specifications

0 Answers  

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers  

What is Complex Reports?

3 Answers   TCS,

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers   Target,

What is the server based ranking? and its usage?

2 Answers  

what is BIAR file in business objects xi r2

3 Answers   TCS,

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 Answers  

For more Business Objects Interview Questions Click Here
Categories