My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 7865 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Explain how we drill up week to month?
What are the security level used in BO?
Explain how to schedule the report in b.o?
what is the core universe and what is the active universe?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
when you have three fact table and there is no relationship between them. How you will tackle the issue.
Approximatly how many enduser can use the each bo project?
What is the short cut join?
how to limit number of rows in a report in business objects using webi?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
What is the Drill filter and it's usage?
Teradata 
