My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 8405 Views
- TCS, I also Faced
- E-Mail Answers
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
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain which versions are used in the bo dashboard work?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what are the steps to be taken to schedule the report?
What is the difference between the public object&schema object?
Explain about alerts in bos, under what situation we need to use alerts?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What we need to discuss with designer before starting the universe designing.
Can we create universe with no cache??
how to prepare the documentation in business objects and where to get the requirement?
8. How much supervision have you typically received in your previous job?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What three things do you consider to be the most important factors for a manager?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
