My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
Answer Posted / 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 |
Post New Answer View All Answers
What is Indexing? how did u implement indexing?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Did you face any problems while creating reports? Name? Solutions?
Explain what are the steps to be taken to schedule the report?
How were the reports scheduled and how to resolve unexecuted documents?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What Is The Difference Between Oltp And Olap?
Explain how to execute the plsql procedure from the report by clicking with mouse?
is it possible to export the webi reports to crystal reports?with out using businessview?
What are the data types present in bo? What happens if we implement view in the designer and report?
What are the join problems comes appart from loop,chasm & fan Traps
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What we need to discuss with designer before starting the universe designing.
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is thumbnail?