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

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

4.what is repository? types

8 Answers   TCS,


what is the syntax for aggregate awareness?

3 Answers   Exilant, i-Tree, Wipro,


What is the Drill filter and it's usage?

2 Answers  


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers   Arkema pte Ltd,






How were the reports scheduled and how to resolve unexecuted documents?

0 Answers  


What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  


Tell me about a complicated object you have created?

1 Answers  


Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,


What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,


What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,


HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,


Categories