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
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 |
Have you worked with multiple data sources? If yes. How do you link them?
How will solve a loop caused by lookup table without using alias?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
how to improve the performance of the report
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
What is the difference b/w breaks and sections
What three things do you consider to be the most important factors for a manager?
4.what is aggregate awareness ? how do we use ? where do we use ?
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
How to hide objects or columns?