Downloads

Please note that you can find the download files for recent articles at the bottom of the individual articles.

Update 7 2009

For “SAP NetWeaver BW and Xcelsius: Develop Eye-Catching Reports with Real-Time Updates” by Derek L. Johnson and Oliver Willoughby, SAP America, Inc. Download the sample data for the Xcelsius report and Web service.

Update 5 2009

For: “Create Engaging, Error-Free Xcelsius Dashboards with SAP NetWeaver BW Queries” by Tony Harper. Here is the sample code for the remote-enabled function module.

For: “An Insider’s Guide to SAP BusinessObjects and SAP NetWeaver BW: What Tools Should You Use Going Forward?” by Ned Falk, Senior Education Consultant, SAP, and Antonio Soto, Platinum Education Consultant. Here is the Introductory SAP Courses for SAP NetWeaver BW and SAP BusinessObjects guide available for the tools mentioned in the article.

Update 4 2009

For: "6 Steps to Enhance a CRM DataSource Using a BDoc BAdI," by Liang Ma, Senior Specialist, Deloitte Consulting. Here is the code mentioned in step 4 in the article.

Update 3 2009

For “Custom Data Slices Protect Your BI Integrated Planning Data” by Shailesh Unny, Senior Consultant, BearingPoint. Click here for the IF_RSPLS_DS_METHODS~IS_PROTECTED code. Click here for the IF_RSPLFA_SRVTYPE_IMP_EXEC_REF~GET_REF_DATA_SEL code.

Update 2 2009

For “A Better Way to Manage User Exits: The Flexible Approach” by Christian Harrington, Business Intelligence Consultant, Harrington Informatique. Click here to download the code for a transactional DataSource and click here to download the code for hierarchy DataSource.

October 2008

For “How to Create a Generic Retractor in Integrated Planning” by Andrew Simmonite, Solutions Architect, Business and Decisions. Download the three files you need implement the planning type and associated objects: NUGG_ZCL_CUSTOM_RETRACTOR.nugg, Retractor_IOBJ , and Implementation of Custom Retractor Planning Type.

June 2008

For “Minimize Your STS Maintenance Effort,” by Andrey Bondarev, Senior BI Consultant, Bluefin Solutions Ltd. Download the ABAP program that allows you to create user email addresses, provided that first and last names are already maintained in the system.

For “Conditional Execution Part 2: Prevent Incorrect Data in Transactional Data Loads,” by Rajiv Kalra, Independent Consultant. Download the code for Figure 4 and Figure 7.

May 2008

For “How to Approach Time-Dependent Relationships in SAP NetWeaver BI” by Jens Koerner, Principal, Inforte. Download the ABAP code for the custom program. You can also download a visualization of the PROVIDE program.

For “Allow Users to Manage SAP NetWeaver BI Master Data with Visual Composer,” by Hubert Alistair Wallace, Developer, Morris Communications. Download the code for the ZBWEX_SAMPLE_GET and ZBWEX_SAMPLE_UPDATE function modules.

March 2008

For "Uncover Process Chain Execution Errors When SAP NetWeaver BI Fails To Notify You," by Jeevan Kumar Ravindran, Independent BI Solution Architect.

Click here to download the file that contains the source code for the watchdog program.

For "Conditional Execution Part 1: One Process Chain Does the Work of Two," by Rajiv Kalra, Independent SAP Consultant.

Click here to download the files that contain the code to define the GET function in Formula Builder and the code to determine the last Saturday in the month.

For "Custom ABAP Program for BW 3.5 Loads Data into a Transactional InfoCube Automatically," by Charles Hall, SAP NetWeaver BI Solution Consultant, Sapphire Consulting.

Click here to download the file that contains the source code for the custom program ZSWITCHCUBE.

January 2008

For "Use a New Process Type to Create Dynamic Process Chains," by John Kurgan, Independent SAP BI Professional, JK Global Consulting, Inc.

Click here to download the illustration of the time buffer when you have a variable completion window.

November/December 2007

For "Home Page Framework Integrates Your Dashboards for Easy User Access," by Brian Hether, Manager of Data Warehousing, The Washington Post.

Click here to download the full HTML code for the layout page shown in Figure 4 of the article.

For "Simplify Reporting by Creating a Top N Analysis Report," by Yu (James) Hong, Information Management Lead, Major Manufacturing Company, and Balaji Bitra, BW Lead, Major Manufacturing Company.

Click here to download the ABAP user exit code referred to in step 3 of the "Subtotal of Top 20 and Remaining Products Report" section of the article.

October 2007

For: "Wait Process Type Offers an Alternative to Third-Party Job Schedulers" by Shailesh Unny, Senior Consultant, BearingPoint.

Click here to download the file that contains the codes to build the modules mentioned in the article.

September 2007

For: "Enhance Process Chain Efficiency by Using Dynamic Delay Capability" by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel.

Click here to download the T-delay block code to create the sample program ZBI_T_DELAY.

July/August 2007

For: "Maximize Your Query Optimization Options in BW" by Gary Nolan, Independent BI Strategic Architect.

Click here to download the code you can use for a program to optimize any query you create in BEx.

For: "Avoid Full Data Reload: Use Reverse Loading to Substitute InfoCube Characteristic Values" by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel.

Click here to download the ABAP code in a sample start routine for key figures value reversing.

For: "Avoid Full Data Reload: Use Selective Deletion to Substitute InfoCube Characteristic Values" by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel.

Click here to download the ABAP code for the InfoPackage selection criteria for the characteristic ZCHAR_SUBST.

Click here to download the ABAP code in a sample start routine for characteristic value substitution.

Click here to download the ABAP code for substituted characteristic selection criteria for the ICS InfoCube deletion program that you generated.

June 2007

For: "Load CSV Files to BW Through a Web Page Using XML" by Martin Ringvold, Independent SAP BI Consultant.

Download the front-end HTML source code and the source data (CSV) file used in Martin's example.

May 2007

For: "Implement Custom Process Types in Process Chains for CRM Analytics" by Ryan Leask, CPM Product Manager, SAP Labs.

Click here to download the complete step-by-step solution for implementing custom program types in CRM Analytics with directions to create tables, message classes, ABAP programs, and more.

April 2007

For: "Modify BW-BPS Web Interfaces with JavaScript to Include Fixed and Scrolling Columns" by James Koefelda, Senior Technical Consultant, Sheldon Edelstein, Platinum Principal Solution Consultant, and Olaf Fischer, Regional Implementation Group (RIG) Specialist, SAP America.

Download the initializing JavaScript program jsInitScrollingLayout and the main JavaScript program jsScrollingLayout to improve your scrolling abilities.

March 2007

For: "Directly Populate User-Defined Hierarchies" by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss-Elite Ltd., Israel.

Download the contents of the ZXRSAU04 user exit. In this code, I selected the ZCHAR InfoObject values from its master data table /BIC/PZCHAR.

For: "One Web Table Interface Class Fits All by Jin Freda, BW Developer, Becton Dickinson.

Download the contents of the START, CAPTION_CELL, STRUCTURE_CELL, CHARACTERISTIC_CELL, DATA_CELL, and DATA_CELL_2 methods.

For: "Quick Tip: Take the Guesswork Out of 0CALWEEK Selection" by Jeevan Ravindran, Independent Software Solution Architect.

Download the ZZLOAD_0CALWEEK_TEXT program to populate the 0CALWEEK text.

February 2007

For: "Three Methods for Editing DataStore Object Data Without Altering Source Data," by Brian Hether, Manager of Data Warehousing, The Washington Post, and Jerry Coleman, Senior Analytics Developer, The Washington Post.

Click here to download an additional method of using a Data Browser to directly edit a DataStore active table.

Click here for complete ABAP code mentioned in Figure 18.

January 2007

For: "Simplify Your ABAP Data Access to Planning Applications," by Alfred Ho, SAP Technical Specialist, Husky Energy.

Click here to download the technical setup for the examples and here for SE80 instructions. Next, download example 1 and example 2. Finally, download the complete source code mentioned in the article.

November/December 2006

For: "3 Steps for Creating Efficient Update Rules," by John Kurgan, Manager, Inforte.

Click here to download the instructions for "How to Get to the Update Rules." Click on the following figures for the complete code in Figure 3, Figure 4, Figure 5, Figure 6, and Figure 7.

For: "Custom Program Grants Users Easy Access to Both BEx Analyzer 3.x and SAP NetWeaver 2004s," by Bryan Koetting, BI Consultant, Teklink International.

Click on the following program names to download the complete code: ZRRMXOLD, ZRRMXNEW, and ZRRMX_CHOOSE.

October 2006

For: "Refine BW Querying with Real-Time Data," by Leon Berman, SAP BW/BI Expert, SAPSoft Consulting Ltd.

Click here to download the complete code YBW_ONLINE_TEST based on the standard function module RSFH_GET_DATA_SIMPLE.

September 2006

For: "Empower Your End Users with Accurate BW Reports," by Philip Botterill, SAP NetWeaver Application Consultant.

Click here to download the PROGRAM UPDATE_ROUTINE.doc for the complete custom ABAP program to enter into the start routine.

July/August 2006

For: "Identify Failed Data Loads with This Check Tool," by Mark Theunissen, Reporting and Analytics, Rio Tinto.

Click here to download the complete code explained in this article. If you are encountering a syntax error when implementing Mark's solution, it occurs because he uses a structure in the program that needs to be defined in the data dictionary as well as a function module that needs to be created in the function library. You can resolve this minor problem easily by downloading this spreadsheet where the layout of the structure is specified and this spreadsheet where the function module code is specified.

For: "Simplify Complicated Extractions with Function Modules," by David Eady, Reporting Team Lead, Propex Inc.

Click here to download the test dataset in Excel format and here to download the test dataset in Word format.

Click here to download the ABAP source code mentioned in the article.

May 2006

Get an introduction to " The Extraction Process" and the building blocks of SAP BW. This sidebar by Iliya Ruvinsky, SAP BW Consultant, Advantech Technologies, is referred to in his article "Pinpoint the Cause of Data Inconsistencies to Ensure Precise Key Figure and Characteristic Values" in the May 2006 issue of BI Expert.

March 2006

For: "6 Ways to Optimize SAP BW in Business Objects," by Sergei Peleshuk, BI Consultant, ABSS Europe.

Download the code in Figure 4, Figure 5, and Figure 8 to minimize Business Objects/BW integration problems.

February 2006

For: "Create an Interactive BW Report Catalog," by Yu (James) Hong, Senior Consultant, BearingPoint Inc.

Download the code in Figure 11, Figure 12, Figure 14, and Figure 16 that enables you to create your own report catalog.

For: "Quick Tip: Automate a Personalized Title in an SAP BW Web Report" by Vitaliy Rudnytskiy, SAP/BI Developer, Hewlett-Packard Global Delivery-Application Service.

Download the code in Figure 3 and Figure 5 that allows you to change the title of your SAP BW Web reports.

January 2006

For: "Enable Your Process Chains to React to Outcomes of ABAP Programs" by David Eady, Reporting Team Lead, SI Corporation.

Click here for the code in Figure 15 in David's article.

November/December 2005

For: "Personalize Your BW Web Reports with a Report Selection Screen," by Jay Dixit, Senior IT Analyst, Halliburton and Sathish Janardhanan, Senior IT Analyst, Halliburton

Click here for the JavaScript code from Figures 3.

Click here for the JavaScript code from Figure 7.

September 2005

For: "Extract R/3 Hierarchies Directly into BW," by Christian Harrington, Business Intelligence Consultant, Harrington Informatique

Click here to read the additional information about other internal tables involved in user exits referred to in Christian's article.

Click here to read the source code referred to in Christian's article in Figure 8.

For: "Prevent Users from Accessing Sensitive Data Using Authorization Restrictions," by Graeme Smith, Principal BW Consultant, Unilog Ltd.

Click here to read the "Enter the Authorization Restriction in a Query" sidebar referred to in Graeme's article.

August 2005

For: "Enhance a UI Pattern to Take Advantage of the New Excel Web Printing Functionality," by Derek Johnson, Platinum Consultant, SAP America, Inc.

Click here to download a zip file containing the full source code from the example in Derek's article.

June 2005

For: "Make DB Connect Delta Capable with External Sources: Part 2"

Click here to download the file.

March/April 2005

Click here to retrieve TREX code.

Click here to retrieve Program for data retrieval code.

Click here to retrieve materials for print controls.

February 2005

Click here to retrieve ABAP code.

November/December 2004

For: "Make Users Smile with Better Running F4 Searches"

Click here for the SQL statements that correspond to the InfoObject settings described in the article written by Shreekant Shiralkar and Bharat Patel.

October 2004

For: "Quickly Build Impressive Dashboards in SAP BW 3.5," by Glen Leslie, BI Product Manager, SAP Labs.

Click here to read the code for the SAP BW Web template referred to in Glen’s article.

For: "Use Excel Workbooks for Attractive, Easily Maintained Reporting Front Ends," by Simon Ferres, BW Team, Barclays Capital.

Click here to retrieve the MATCHMULTILINE code.

September 2004

For: "Modify Web Reports with the BW Table Interface"

Click here to retrieve the user code.

June 2004

For: "BW Applications on the Web: Why Not Use Business Server Pages?"

Click here to download the code to add to the development environment for creating BSP applications noted in Kumar Srinivasan's article.

Click here for more details about the usage scenario described in Guido Schroeder and Glen Leslie's article "UDConnect in SAP BW 3.5 Enhances Native Data Acquisition."

May 2004

For: "Automate Your Loads Using Recursive InfoPackaging"

Click here to download the 0CALDAY ABAP code to enter in coding screen from David Theroux-Benoni's article.

Click here to download the code for ZREAD/ZWRITE, if you use a version of BW that is newer than 2.1C.

Click here to download the code for ZREAD/ZWRITE, if you use BW 2.1C or older.

April 2004

For: "Deletion Can Be Key for Alternative Delta Loads Using Non-R/3 Data Sources"

Click here to retrieve the user code.

For: "Fully Automate Your BW Load Processes with Standard Tools (and a Little Creativity)"

Click here to retrieve the user code.

March 2004

For: "Create New BW Web Printing Controls Users Love"

Click here to retrieve the user code.

For: "Functions to Automate and Enhance Your BW Reports in Excel"

Click here to retrieve the user code.

February 2004

For: "Virtual Characteristics and Key Figures Make Queries More Dynamic"

Click here to retrieve the user exit code.

January 2004

For: "Make BW's Bookmark Functionality a One-Step Process," by Mukunda Krishnaswamy, Principal Architect, Enterprise Systems, American Standard

Click here to download the custom query template. Please do not import this directly into your system. Copy the JavaScript function and incorporate it into your company query template as described in the article.

For: "Combine Data from Multiple R/3 Tables into One BW Table," by Rich Oxley, Kenakore, Inc.

Click here to read the source code referred to in Rich's article in Figure 7.

September 2003

For: "True Delta Loads of R/3 Master and Transactional Data: How It's Done When No Standard Extractors Are Available"

Click here for "Extractor Source Code."

Click here for "Update ROOSOURCE."

Click here for "Update ROOSFIELD."

Click here for "Update ROOSGEN."

April 2003

For: "Distribute Pre-calculated Web Reports More Quickly Using Value Sets"

Click here to download the program that checks to see if a file has been downloaded.

Click here to download the program that deletes the file after is has been sent.

Premiere Issue

For: "BW for Beginners: Teach Users InfoCube Basics with Excel and Better Reports Are Sure to Follow"

Click here to download the nine Excel worksheets.

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
BI Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.