My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?

Answer Posted / guest

use personel data provider and use this excel to get the
data. Automatically it will create the SQL from excel.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

4242


How to generate the report from excel sheet?

823


how get the grand total in master-detail report?

1997


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1917


What is thumbnail?

727


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

731


What are the join problems comes appart from loop,chasm & fan Traps

1777


Explain what are the measure objects?

719


Explain what is aggregate table and aggregate fact table ... Any examples of both?

816


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1777


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

1624


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

748


Explain how to execute the plsql procedure from the report by clicking with mouse?

797


How to open a universe with out using the Designer ??

7002


Explain which versions are used in the bo dashboard work?

825