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

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3564


what will be the contents for a functional requirements specifications

2343


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

1007


What are the steps to be taken to schedule the report?

954


How to create Index to the table in the universe designer and how it improves the Query performence

2543


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

1072


What is the difference between absolute and relative div positioning?

1041


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2391


What Is Snow Flake Schema?

1190


Explain what is the difference between business requirement document and use case document.

1014


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1376


What Is The Difference Between Oltp And Olap?

1115


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

8157


Explain is data mart?

1011


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1949