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
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
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?
Explain how to execute the plsql procedure from the report by clicking with mouse?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain is there any default username & pwd for bo designer & supervisor?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What three things do you consider to be the most important factors for a manager?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference between business requirement document and use case document.
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How to execute the plsql procedure from the report by clicking with mouse?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Can Bo generates the Report from the cubical data Explain?