My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
Answer Posted / 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 View All Answers
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is the difference between the public object&schema object?
is it possible to export the webi reports to crystal reports?with out using businessview?
how to prepare the documentation in business objects and where to get the requirement?
What sort of existing documents should business analysts refer to when starting on a new project?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain is there any other repository domains rather than universe, security, document?
Can we Save (save as) WEBI Doc as DESKI?
Explain what task is 98% of the required work of a business analyst?
Explain what are the steps to be taken to schedule the report?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is the difference between condition & filter?
what are the tables used in health care domain project and columns used in report?
in sap bi we have wad, then why we go for sap bo