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 the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
Can we configure two instances of CMS pointing to two different CMS system databases?
how can i add two different reports in the same document?
explain in detail about type 3?
1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2
What is broad cast agent?
What are the major problems will occur while migrating to the one version to another version?
In banking domain how many Fact tables,Dimension table are present?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
what is meant by report busting
Is it possible to develop reports without Universe access?