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


Please Help Members By Posting Answers For Below Questions

Explain what three things do you consider to be the most important factors for a manager?

547


Explain what is the difference between slice and dice and cross tab report?

598


What is the profile and package?

1760


What Is The Difference Between Oltp And Olap?

668


How can you first report in Business Objects by using broadcast agent?

2593






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)?

569


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

1568


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

1395


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

1424


Explain about a task that really tested your analytical abilities?

744


Can we create universe with no cache??

1949


How to restrict password to a user while sending a document in .pdf format

1850


What Is Snow Flake Schema?

664


What are the data types present in bo? What happens if we implement view in the designer and report?

611


What is the difference between condition & filter?

600