Briefly describe the steps you would take to use an Excel
file as data to join a Business Objects data provider in a
report?
Thanks in advance....
- 2 Answers
- 6506 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit rathi
1)Create a New DP by Personal data File(Excel File) .
2)check objects in the data manager.only those column
contain measures values should be measure objects.other
should be dimension or details.
3)Link the dimesion objects with other DP Objects.
| Is This Answer Correct ? | 3 Yes | 1 No |
1. Create a data provider having personal data file as
source, select the excel file and check 'First row contains
column names'. This'll do.
2. Suppose we want LOVs to be populated from excel,
definitely we 've to build universe out of the excel.
Assumption: Answers are given to Desktop Intelligence
reports.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is object stores?
What Is Snow Flake Schema?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
What is thumbnail?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
how to schedule a report for even number dates?
What is the Computation error? how to solv it?
what is crosstab reporting,slice and dise and drill mode??
Teradata 
