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....
- 2 Answers
- 6325 Views
- I also Faced
- E-Mail Answers
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 are the data types present in bo? What happens if we implement view in the designer and report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can i merge two dataproviders if they do not have common column?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
when we go for snow flake schema rather than star schema ?
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
what is custom sorting?how we can do this expalain with procedure???
what is confirm dimension ?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
how will you move the universe/report from development to production?
Explain what are the steps to be taken to schedule the report?
Teradata 
