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 crosstab reporting,slice and dise and drill mode??
How will you test a BO report
how to test reports in businessobjects?
What is the local filter and global filter in bo's?
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?
Tell me about a complicated object you have created?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
every alternative row should be hilighted ? how u can ?
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
5.what is LOV? where it is store?
What would you consider as your biggest achievement and why?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?