Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel data source for webi

Hellow Experts

I am trying to load/import excel data into bobj, I am wondering which appraoch is the best and what are the pros and cons of these approaches.

We just deployed bobj 4.1 sp01

Approach 1: Build universe based on excel datasource and then build webi query

Approach 2: Import excel file directly into webi

I would appreciate if you advise the following.

1. What is the refresh machnaism in both these approached

2. Can I refresh using BI launch pad in 4.1 version or what is another option

3. Is there any other machanism to refresh these kind of report which is based on excel in 4.1 version

4. What is the best suitable file format for this kind of data load into bobj, I have following file format, please see attachment cell hielighted in yellows are dimension and green are measures) can you please let me kow if this format is correct.

Regards

Tags:
Former Member replied

Hello Imran,

Your exel format is right and you need to repeat the "Walmart" for  Salt and Oil also..

Approach 1 Benefit: Build one universe use it in any no of reports.

                             You can create formula's in universe as well which improves query performance.

                             ...   

Approach 2 Benefit: For each report you have to start from beginning because you have to change the object type each time when you are using the excel source.More ever you have to  create variables in report it self...


Conclusion: If your excel is having multiple sheets use approach 2

                   If your excel is having single sheet then use approach and you have 2 create multiple reports then use approach 1.

                  

Finally it's your choice to choose the best one which suits your requirement with less developing time.

Note:In Both approaches you need to close the report and open it to make changes done in excel(structural changes only ). for delta rows you don't need to do anything.. except saving the excel sheet.

let us now if anything is required.

Regards,

Subbarao M

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question