Ask the Experts

Ask the Experts

SAP Business Warehouse

• How to limit employee access to reports using roles in SAP NetWeaver

  An administrator wants to limit employees from running corporate-wide reports using roles.  Continue Reading

• SAP BI extractors vs. Business Objects for ETL process

  An SAP user wants to know the benefits of using standard SAP BI extractors for an ETL process between SAP BW and SAP ERP  Continue Reading

• How does SAP R/3 data differ from BW (NetWeaver BI) data?

  What is the difference between data on SAP R/3 and data on SAP BW?  Continue Reading

• Job prospects after SAP BI training

  I am currently working for a business process outsourcing company, and currently interested in SAP BI. If I take a course in SAP BI 7.0, what would my job prospects be like?  Continue Reading

• An SAP BW 3.1 to BI 7.0 upgrade should not take one year

  Our company is about to upgrade SAP Business Warehouse 3.1 to SAP Business Intelligence 7.0. Our consultant estimated almost a one year upgrade for just our development system. I don't have a lot of experience with SAP BI, but this doesn't sound ...  Continue Reading

• Is SAP BI knowledge advantageous to an ABAP user?

  I have been working with ABAP at a multinational corporation for the past two years and would like to learn SAP BI. When I do this should I also learn SAP BW? Will there be any advantages to learning BI as an ABAP consultant?  Continue Reading

• Key figures and web templates in SAP BI

  Can you use a key figure as a navigational attribute in SAP BI/BW? What about precalculated web templates in BI/BW reporting?  Continue Reading

• Is ABAP expertise necessary for SAP BI?

  I have an MBA in marketing. If I wanted to venture into the world of SAP BI, would ABAP knowledge be necessary?  Continue Reading

• Prerequisites for SAP BI training

  What are the prerequisites for SAP BI training? I have a J2EE background and I want to move to BI. I have heard SAP BI is the latest and greatest in business warehousing. I have also heard people say it's techno-functional, whatever tha means). Will...  Continue Reading

• The tables/views used to populate extractors

  I am trying to ascertain what tables/views are used to populate an extractor. I need to get the size of the underlying tables on R/3.  Continue Reading

• Useful transaction codes in SAP BI

  What are the useful transaction codes in SAP BW?  Continue Reading

• Using transactional and master data when creating an InfoCube

  When we create an InfoCube, we take dimensions along with key figures when we have to load data. Do I have to use two different datasources -- one for transactional and one for master data?  Continue Reading

• Measure the performance of an InfoCube

  How do I measure the performance of an InfoCube using one transaction code?  Continue Reading

• Problem loading data into a DSO

  I have loaded 2LIS_13_VDITM data into a DSO. Some of the rows in the "Billed Qty" have a "-" sign, but there are some without a "-" sign in the VBRP table in R/3. What is the cause of this issue?  Continue Reading

• What's the difference between ODS and DSO in SAP BI?

  In SAP BI, what is the difference between ODS and DSO?  Continue Reading