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 difference between zabo and webi?

1039


Can we create universe with no cache??

2440


What is the dense rank?

1121


What is thumbnail?

917


Explain the difference between union and group?

1043


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

8030


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1208


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10754


What is the difference between slice and dice and cross tab report?

993


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?

939


how to create metric universe ?

2276


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2074


what will be the contents for a functional requirements specifications

2287


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

965


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

975