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
- 6519 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
How to restrict password to a user while sending a document in .pdf format
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Difference between zabo and webi?
what are the tables used in health care domain project and columns used in report?
Can you please send me the migration related issues .
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between the public object&schema object?
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 create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Can anybody tell me what are the tuning problems?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
