Interested to Buy Any Domain ? << Click Here >> for more details...
My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 9168 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
What task is 98% of the required work of a business analyst?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain is data mart?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain what task is 98% of the required work of a business analyst?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain about alerts in bos, under what situation we need to use alerts?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
