Interested to Buy Any Domain ? << Click Here >> for more details...
My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 9108 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 |
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
How would you format some text using css to be verdana and bold?
Approximatly how many enduser can use the each bo project?
What is a bo repository?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
what is custom sorting?how we can do this expalain with procedure???
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
Can Bo generates the Report from the cubical data Explain?
What is the Difference b/w Server based Ranking and normal Ranking?
What are different types of saving options in web intelligence?
When to use local filter and when to use global filter?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
Teradata 
