Ask the Experts

Ask the Experts

SAP Business Warehouse

• Formatting a BW Query in a Web template the same as in BEx Analyzer

  You may find that a BW Query may appear different when embedded in a Web template versus in BEx Analyzer. BW expert Peter Scott says that while the formatting and OLAP functionality are the same, the variances could be discovered by looking in the ...  Continue Reading

• SAP BW 3.0B vs. SAP BW 3.1C

  Wondering what SAP BW 3.1C offers that SAP BW 3.0B doesn't? SAP BW expert Peter Scott describes how Business Content is the deciding factor between the two versions.  Continue Reading

• Secure an Info Cube in SAP BW

  Looking to make your Info Cubes secure? BW expert Peter Scott provides a few options for a user who is looking to secure an Info Cube.  Continue Reading

• Can I change the InfoProvider that a query uses?

  Is it possible to change the cube used by a BW query? We have a number of identical cubes representing a quarter's history data. Rather than build a unique BW query for each quarter, I would like to build one query and change the cube it points to.  Continue Reading

• Using a replacement path variable to create a formula

  Learn how to use a replacement path variable to create a formula, with advice from BW expert Peter Scott.  Continue Reading

• Who should be responsible for SAP after implementation of SAP R/3 and BW?

  Learn how responsibility should be divided in an organization implementing SAP R/3 and BW. Executive advice expert Joshua Greenbaum says it depends on how SAP's roll will evolve in the organization and if R/3 and BW will operate seperately.  Continue Reading

• Business Content explained

  Learn about Business Content functionalities and limitations from SAP BW expert Jay Narayanan.  Continue Reading

• Can I extract data from a Hyperion database to SAP BW?

  Learn how to transfer data from a Hyperion database into SAP BW, or from SAP FI t SAP BW.  Continue Reading

• Suggestions for preparing a trend report

  Learn best practices for SAP trend reports. BI/BW expert describes how to prepare these reports including closing period data.  Continue Reading

• I learned SAP BW on Windows. How does this compare to Unix?

  I learned SAP R/3 and BW on a Microsoft Windows platform. How is this different than SAP R/3 and BW on UNIX platform?  Continue Reading

• How should I prepare for the SAP BW exam?

  Learn how to prepare for the SAP BW certification exam with advice from a BI/BW expert.  Continue Reading

• Our database is full -- how should we proceed?

  Describes how to troubleshoot a full database. SAP BI/BW expert provides advice for uploading data into PSA and cube.  Continue Reading

• I have ABAP skills, but now I want BW skills!

  I'm an ABAPer. What are the basic requirements to acquire an SAP BW skillset?  Continue Reading

• What are the best tools for SAP BW data management?

   Continue Reading

• Can we implement BW on Windows and connect to R/3 on Unix?

  We are in the process of evaluating the idea of implementing BW on Windows platform and connecting it to to SAP R/3 running on a Unix platform. We are considering this for cost reasons. Do you have any recommendations for the above scenario, and ...  Continue Reading