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 what three things do you consider to be the most important factors for a manager?
Explain what is the difference between slice and dice and cross tab report?
What is the profile and package?
What Is The Difference Between Oltp And Olap?
How can you first report in Business Objects by using broadcast agent?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
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
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
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
Explain about a task that really tested your analytical abilities?
Can we create universe with no cache??
How to restrict password to a user while sending a document in .pdf format
What Is Snow Flake Schema?
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the difference between condition & filter?