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
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?
what will be the contents for a functional requirements specifications
What sort of existing documents should business analysts refer to when starting on a new project?
What are the steps to be taken to schedule the report?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what is the difference between slice and dice and cross tab report?
What is the difference between absolute and relative div positioning?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What Is Snow Flake Schema?
Explain what is the difference between business requirement document and use case document.
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What Is The Difference Between Oltp And Olap?
Can we Save (save as) WEBI Doc as DESKI?
Explain is data mart?
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....