Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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 about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1133


What is the difference between the public object&schema object?

1051


is it possible to export the webi reports to crystal reports?with out using businessview?

2271


how to prepare the documentation in business objects and where to get the requirement?

2207


What sort of existing documents should business analysts refer to when starting on a new project?

1003


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2032


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?

980


Explain is there any other repository domains rather than universe, security, document?

1071


Can we Save (save as) WEBI Doc as DESKI?

8137


Explain what task is 98% of the required work of a business analyst?

1079


Explain what are the steps to be taken to schedule the report?

1088


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2308


What is the difference between condition & filter?

1444


what are the tables used in health care domain project and columns used in report?

4495


in sap bi we have wad, then why we go for sap bo

3369