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

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers TCS,

What is casual dimension?

4 Answers

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers

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?

0 Answers Infosys,

What is the difference between datawarehousing and businessintelligence?

0 Answers

plz tell me about BOmain key in detail?

2 Answers

What is the difference between the Webintelligence and desktopintelligence?

2 Answers IBM,

Did you face any problems while creating reports? Name? Solutions?

0 Answers IBM,

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers

how to create dashboard reports

4 Answers TCS,

In banking domain how many Fact tables,Dimension table are present?

0 Answers TCS, UST,

what is static filter and dynamic filter

1 Answers

For more Business Objects Interview Questions Click Here