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 difference between zabo and webi?
Can we create universe with no cache??
What is the dense rank?
What is thumbnail?
Explain the difference between union and group?
Can we Save (save as) WEBI Doc as DESKI?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
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 the difference between slice and dice and cross tab report?
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?
how to create metric universe ?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
what will be the contents for a functional requirements specifications
What sort of existing documents should business analysts refer to when starting on a new project?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?