Briefly describe the steps you would take to use an Excel file as data to join

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

Question Posted / guest

2 Answers
7050 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Briefly describe the steps you would take to use an Excel file as data to join a Business Objects d..

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

Briefly describe the steps you would take to use an Excel file as data to join a Business Objects d..

Answer / 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

More Business Objects Interview Questions

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers

what do u mean by merged dimensions in Business Objects

2 Answers Business Intelligence Analytics, TCS,

Difference between Decode and Case?

1 Answers NIIT, TCS,

What task is 98% of the required work of a business analyst?

0 Answers

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers Accenture,

wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

2 Answers Accenture,

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

3 Answers TCS,

What is the prm file ? can anybody explain me ?

2 Answers

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers

How do u get requirement from the client? in what format?

1 Answers TCS, Wipro,

every reports have docid,when i export a report docid will change or not?

4 Answers Zensar,

What are alertors in Business Objects?

5 Answers

For more Business Objects Interview Questions Click Here