|
|
Categories
»
ETL
ETL
- 5 Best Ways to Import Non-SAP Data into BW
by Mike Curl, Principal Consultant, Bluefin Solutions
Weigh the benefits and drawbacks of the five most popular ways of importing non-SAP data into your BW system.
- Another Way to Create an ETL Daily Run Report
by Karen Olsen, Business Intelligence Analyst/Developer for W. W. Grainger
With so many reports that must be run daily, it can be difficult to determine the best way to track jobs in BW. The author shares her success with creating a custom table to track InfoPackages being transported to production. The table provides users with access to vital and accurate information about the status of their jobs.
- Automate Your Loads with Recursive InfoPackages
by David Theroux-Benoni, Independent BW Consultant
Setting up InfoPackages for data loads is often a time-consuming process. Through examples, the author explains two timesaving ways to automate your InfoPackages. He also debates the benefits and drawbacks of each method, which will enable you to choose the best way for you to schedule your InfoPackages.
- Avoid Full Data Reload: Use Reverse Loading to Substitute InfoCube Characteristic Values
by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel
Become familiar with a method for substituting InfoCube characteristic values that avoids a full data reload: reverse loading.
- BW Developers Benefit from Using Production Data for Testing
by David Eady, Reporting Team Lead, Propex Inc.
BW developers spend most of their time in the development system, often the least suitable environment for testing due to the lack of solid production-class data. Explore creative ways to populate your development system with real production data.
- Case Study: How to Optimize Performance for Large-Scale ETL Processing
by Anthony Fresina, Development Manager at SAP, IBU Banking, and Ravin R. Angara, BW Architect at SAP, IBU Banking (April 2010)
Discover steps that you can take to expand your performance tuning toolkit. The tips provided help you performance tune an extraction, transformation, and loading (ETL) process with a complex transformation in the start routine.
- Custom Program Enables You to Transport Query Variants Between Two Systems
by Pranab Parhi, Senior SAP NetWeaver BW and Planning Consultant, Bluefin Solutions UK (February 2010)
Find out how to create a custom program and use it to transport multiple SAP NetWeaver BW query variants from one system to another. This process can also apply to transporting variants used with Analysis Process Designer.
- Deletion Can Be Key for Alternative Delta Loads Using Non-R/3 Data Sources
by Adrian Gawdiak, Manager, Global Data Warehousing, American Standard Companies; and Nilesh Mehta, Senior Developer and
Analyst, Global Data Warehousing, American Standard Companies
Integrating data from third-party systems into BW is a complex and often frustrating process. The authors developed a custom delta load system at their company based on removing data through a systematic deletion process. Perhaps their alternative delta load process is the right solution for your business.
- Directly Populate User-Defined Hierarchies
by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss-Elite Ltd., Israel
You can create your own hierarchies for custom InfoObjects and populate them to meet unique business requirements. This requires only one extraction, transformation, and loading step.
- Error Stack in SAP NetWeaver BI Provides Improved Data Load Error Handling
by Amol Palekar, Consultant, Enterprise Solutions, Infosys Technologies Ltd., Bharat Patel, BW System Manager, Bharat
Petroleum, India, and Shreekant Shiralkar, Principal Consultant, Tata Consultancy Services Ltd.
SAP NetWeaver BI 7.0 introduces new functionality for error handling, such as the error Data Transfer Process and error stack. Find out how to use these new options.
- Extract R/3 Hierarchies Directly into BW
by Christian Harrington, Business Intelligence Consultant, Harrington Informatique
Business Content extractors do not support all hierarchies in the R/3 source system, such as Treasury Cash Management, so there is no standard DataSource to link these hierarchies to BW. Learn a workaround to this problem by creating an empty DataSource to extract an existing hierarchy from R/3 and load it directly into BW.
- Fully Automate Your BW Load Processes with Standard Tools (and a Little Creativity)
by Luke McElwaine, Associate Director - Global Technology, Barclays Capital
Manual data loads such as daily and monthly refreshes can impede your BW team and increase the risk for human error. Fortunately, data load automation is an attainable goal. The author demonstrates how to automate your load processes using examples, InfoPackages, and custom code.
- Load Data into Two BW Systems from One R/3 Source with Zero Downtime
by Michael Loveless, BI Strategic Architect, Sapiex, Inc., and Gueorgui Patchov, BW Data Architect, Sapiex, Inc.
Are you worried about what adding another BW instance to your ERP system may mean to your end users? Here’s a technique that allows you to bring another BW system online without any outages on the source system. It can be used for other tasks such as reinitializing the system to reduce the impact on the ERP system.
- Make DB Connect Delta Capable with External Sources: Part 2
by Shreekant Shiralkar and Bharat Patel, BW System Managers, Bharat Petroleum, India
After you have connected your BW system to an external database using DB connect, you can make the DataSource delta capable with ABAP code using the time-stamp technique.
- SAP BusinessObjects Planning and Consolidation: Integrate Jobs into Your Existing Enterprise ETL
by Karunakar Gillella, Sr. SAP Administrator, ConAgra Foods (July 2010)
See how to set up controlled batch jobs for SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, with any corporate scheduling tool. This allows you to load end-to-end data from SAP NetWeaver BW to SAP BusinessObjects Planning and Consolidation and vice versa. Follow the steps for creating a batch file on the SAP BusinessObjects Planning and Consolidation application server to execute the scheduled SQL Server Integration Services package on the SAP BusinessObjects Planning and Consolidation data manager.
- SAP NetWeaver 2004s: What's New in the BI Back End
by Ned Falk, Senior Education Consultant, SAP America
Take a peek at the new features in SAP NetWeaver BI, which is part of SAP NetWeaver 2004s.
- Simplify Complicated Extractions with Function Modules
by David Eady, Reporting Team Lead, Propex Inc.
While you can handle most custom extraction needs with a generic extractor over a table or view, it’s handy to have another method for a more complicated extraction. This example shows how to create a generic extractor that uses a function module to gather and deliver data to BW.
- True Delta Loads of R/3 Master and Transactional Data: How It’s Done When No Standard Extractors Are Available
by Satish Chalasani, Independent Consultant
You might typically extract R/3 master and transactional data for which no standard extractors exist based on timestamps or as a full load. Neither method captures all the data, however. A true delta load is possible using Application Link Enabling (ALE) message types. The author describes two undocumented options for building an ALE-based extractor.
- UDConnect in SAP BW 3.5 Enhances Native Data Acquisition
by Guido Schroeder, Director of Development, SAP Labs and Glen Leslie, BI Product Manager, SAP Labs
The SAP BW ETL services layer in BW 3.5 features UDConnect, which allows users to extract data from a variety of sources. The authors introduce this new functionality and examine its advantages. They also provide an example of a common usage scenario.
|
|
