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....

Answer Posted / jansi

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10082


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

651


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

695


How we drill up week to month?

714


Can you please send me the migration related issues .

1743






What are the steps to do to use alerts in bo?

705


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

629


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

643


What is the difference between user and versatile user?

669


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

696


Explain how we drill up week to month?

737


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6187


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

780


Explain how many universes can be created in a project?

721


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

7259