My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 7922 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / obaidullah shareef
If we want to transfer the data from excel to Data base
table, you need to write one pl/sql code for that, this can
be easily done in Oracle Application with the help of
selecting the right table. This process is called inbound
interface in oracle apps and the file is called flat file.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
which is the best way to resolve loop context r alias why?
Can more than 1 metric be applied on an analytic in business objects?
what are the complex reports you have created. Tell me with example?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
How we can resolve the loops by using the Aggrigate Awareness?
What is difference between merged dimension and forced dimension??
I have all the latest SAP – Business Objects - XI Certification Dumps, SABE201: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level One SABE301: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level Two SABE401: BUSINESS OBJECTS Enterprise Certified Professional XI – Level Three SABE501V3.0: BUSINESS OBJECTS Certified Professional – BUSINESS OBJECTS Enterprise XI 3.0 – Update. RDCR201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR301:1 BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR08301: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08401: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 QAWI201V3.0: BUSINESS OBJECTS Certified Professional Web Intelligence XI 3.0 QAWI301V3.0: BUSINESS OBJECTS Certified Professional BUSINESS OBJECTS Web Intelligence XI 3 DMDI201: BUSINESS OBJECTS Data Integrator XI – Level One DMDI301: BUSINESS OBJECTS Data Integrator XI – Level Two You can get Guarantee Pass 100 % Score with these Dumps, If interested in any of the dump, drop me a mail to: srivatsav.2k5@gmail.com with Certification code
how will you move the universe/report from development to production?
what is main functional differences between BO and COGNOs?
What are the errors u have faced in creating reports in business objects and explain some?
Approximatly how many enduser can use the each bo project?
what is zero client and thin client ?
Teradata 
