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 |
what is Scope of Analysis
Tell me the difference between cmc and cms?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
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?
What is top business?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
what is traffic lighting in business objects?