|
|
Categories
»
IT
IT
- 3 Steps for Creating Efficient Update Rules
by John Kurgan, Manager, Inforte Corp.
With a little ABAP code, optimize your data loads with efficient update rules.
- A Better Way to Manage User Exits: The Flexible Approach
by Christian Harrington, Business Intelligence Consultant, Harrington Informatique (February 2009)
The SAP NetWeaver BI environment involves many developers in many different areas (such as finance, logistics, and HR). In the traditional approach, all developers share the same user exit. Discover another way to handle this work — the flexible approach — that can save you time (and money), while reducing the potential problems of sharing user exits.
- Automate Your Updates Even When Deltas Won't Work
by Iliya Ruvinsky, SAP BW Consultant, NESS A.T.
Keeping the data in your InfoProviders current is critical if you want to give end users reports with any real value. Automation is the key to efficiently performing updates that keeps the data fresh. Here’s a way to automate even the toughest updates using process chains and a little custom code.
- 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.
- Avoid Full Data Reload: Use Selective Deletion 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: selective deletion.
- Bring Business Rules into BW for More Accurate Reports
by Gersh Voldman, BI Manager, Inforte Inc.;
and Sushrut Shrotri, Consulting Manager, SAP America
Businesses often need to use IMG (Implementation Guide) logic configuration in BW. This article describes different ways to do so, focusing on the method that has proven the most efficient based on the authors’ numerous implementations.
- BW Applications on the Web: Why Not Use Business Server Pages?
by Kumar Srinivasan, Senior Independent BW Consultant
Business Server Pages (BSP) support many of your business processes on the Web. Beginning with an introduction to BSP, the author presents five basic steps that will allow you to use BSP functionality in BW. In addition, his downloadable code enables you to offer personalization options to your BW users.
- Conditional Execution Part 1
One Process Chain Does the Work of Two
by Rajiv Kalra, Independent SAP Consultant
With a few steps you can simplify process chain maintenance by combining two processes into one process chain. The system determines which process to carry out based on conditional execution. Learn the four steps you need to take to use conditional execution with a process chain.
- Conditional Execution Part 2: Prevent Incorrect Data in Transactional Data Loads
by Rajiv Kalra, Independent Consultant
See how you can use conditional execution in your process chains to halt additional transactional data loads when you have outdated master data.
- Create an Interactive BW Report Catalog
by Yu (James) Hong, Senior Consultant, BearingPoint Inc.
Discover how to make a report catalog using a BW virtual InfoCube and ABAP table interface technology.
- Custom ABAP Program for BW 3.5 Loads Data into a Transactional InfoCube Automatically
by Charles Hall, SAP NetWeaver BI Solution Consultant, Sapphire Consulting
Although users of SAP NetWeaver BI 7.0 can switch an InfoCube between load and plan modes, the process is manual in SAP BW 3.5 and earlier. Find out how you can mimic the SAP NetWeaver BI 7.0 functionality in four steps with the supplied ABAP program.
- Custom Program Grants Users Easy Access to Both BEx Analyzer 3.x and SAP NetWeaver 2004s
by Bryan Koetting, BI Consultant, Teklink International
When migrating to SAP NetWeaver 2004s, your users may want to access both the new and legacy versions of BEx Analyzer until they get used to the new program. However, users accessing BEx Analyzer via single-sign on with transaction RRMX cannot choose which version of BEx Analyzer to launch. Use ABAP code to add a selection screen so users can choose their version of BEx Analyzer.
- 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.
- Empower Your End Users with Accurate BW Reports
by Philip Botterill, SAP NetWeaver Application Consultant
Use standard BW functionality to show end users the accurate last load date and time for each report. This saves time for end users, who can see at a glance whether or not they need the report information.
- Enable Your Process Chains to React to Outcomes of ABAP Programs
by David Eady, Reporting Team Lead, SI Corporation
Process chains in BW have a built-in process type that allows you to execute ABAP programs. However, the process chain has no way of knowing whether the ABAP program succeeded or failed. You can create a custom process type that executes ABAP programs and returns a success or failure code to the process chain.
- Ensure Business Access Segregation by Automatically Generating SAP NetWeaver BW Analysis Authorizations
by Jonathan D. Griffith, SAP NetWeaver BW Subject Matter Expert and BI Solutions Center Tools Team Lead, FirstEnergy Corp. (October 2009)
Learn about an alternative method for creating and maintaining complex business access segregation rules that does not involve having your employees manually assign and revoke SAP NetWeaver BW roles with every employee job transfer. Through the use of analysis authorizations and security data models, you can update your SAP NetWeaver BW security automatically to reflect the latest changes to users as well as business rules governing data access.
- 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.
- How to Approach Time-Dependent Relationships in SAP NetWeaver BI
by Jens Koerner, Principal, Inforte
Modeling time-dependent objects in SAP NetWeaver BI can be challenging. Find out about alternate solutions, depending on the source data format.
- Identify Failed Data Loads with This Check Tool
by Mark Theunissen, Reporting and Analytics, Rio Tinto
Dealing with data load failure is an inevitable part of BW support team members’ jobs. Expedite the way you check for data loads using this standardized process.
- Keep ABAP Routines in Sync for Global SAP NetWeaver BW 7.0 Implementations
by Soumya Mishra, Sr. Consultant, Deloitte Consulting LLP (July 2010)
Discover effective practices and methodologies to consider when designing and implementing start and end routines in transformations, customer exits for query variables and DataSources, and routines in data transfer processes in SAP NetWeaver BW 7.0. These methodologies and practices can help reduce the risks of keeping the data model in sync during implementation.
- 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.
- Maximize Your Query Optimization Options in BW
by Gary Nolan, Independent BI Strategic Architect
Get expert advice for when, how, and why you should optimize your BW queries. Also, determine whether to optimize them automatically or manually.
- Minimize Your STS Maintenance Effort
by Andrey Bondarev, Senior BI Consultant, Bluefin Solutions Ltd.
Find out how to automate the maintenance of each user’s details in your Status and Tracking System implementation.
- Modify Web Reports with the BW Table Interface
by Joerg Boeke, Director Business Intelligence, syskoplan AG, Germany
Many tools are available for creating Web templates, but they offer little help when it comes to modifying data in a report or formatting cells. The author introduces you to a little-known interface that allows you to create object-oriented classes to enhance and modify your Web reports. He offers some ABAP and HTML code to modify a report so it will display special graphics in individual cells along with data.
- One Web Table Interface Class Fits All
by Jin Freda, BW Developer, Becton Dickinson
Implement a flexible custom table interface class for enhancing BW Web reports to meet new and changing business requirements.
- Personalize Your BW Web Reports with a Report Selection Screen
by Jay Dixit, Senior IT Analyst, Halliburton; and Sathish Janardhanan, Senior IT Analyst, Halliburton
You can enhance the bookmark functionality of your BW Web reports to obtain your preferred report layout without the need for additional drill-down or filtering. By adding JavaScript code to the bookmark properties, you can create a pop-up selection screen where you can choose the variables to display in your bookmarked BW Web report
- Quick Tip: Take the Guesswork Out of 0CALWEEK Selection
by Jeevan Ravindran, Independent Software Solution Architect
With a little tweak in 0CALWEEK, and by using a program provided with the article, you can make the 0CALWEEK selection more intuitive to use.
- Refine BW Querying with Real-Time Data
by Leon Berman, SAP BW Expert, SAPSoft Consulting Ltd.
Users often expect BW to provide up-to-the-minute information, forgetting that BW is accurate only according to the time of the most recent upload. Find out how to address this limitation by refining BW queries with real-time data.
- SAP BusinessObjects Planning and Consolidation: Administrator and Power User Best Practices for Configuring Authorizations and Authentication
by Ryan Leask, Senior Director, BPC Solution Management, Enterprise Performance Management, SAP, and Prakash Darji, Director, BPC Solution Management, Enterprise Performance Management, SAP BusinessObjects (December 2009)
When a power user creates an application in SAP BusinessObjects Planning and Consolidation, users must be assigned and given authorization to read and write data that they own. Take an in-depth look at how authentication and authorization are set up to ensure users can only work with the regions of data they own. This information can help you ensure that your data remains accurate and that you aren’t violating any data governance policies your company may have.
- SAP BusinessObjects Planning and Consolidation: Gain a Better Understanding of Application Management
by Ryan Leask, Senior Director, BPC Solution Management, Enterprise Performance Management, SAP, and Prakash Darji, Director, BPC Solution Management, Enterprise Performance Management, SAP BusinessObjects (September 2009)
When a user creates an application, much of what happens in SAP BusinessObjects Planning and Consolidation is hidden from the user. Take an in-depth look at how applications are created and see how InfoCubes and applications differ. This information can help you quickly troubleshoot any issues your users may encounter.
- SAP NetWeaver BW and Xcelsius: Develop Eye-Catching Reports with Real-Time Updates
by Derek L. Johnson, Program Manager, and Oliver Willoughby, Technical Specialist of Delivery Operations, SAP America, Inc. (August 2009)
Discover how to develop a Web service with Microsoft .NET that you can use to create Xcelsius applications that access SAP NetWeaver BW data dynamically. This allows you to develop applications that are always relevant and current. Downloadable sample data to try out this process is included.
- 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.
- 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
See how to develop a BW Web report that shows the top N product analysis with the subtotal key figures of top N products and the subtotal of the remaining products in one report. Walk through an example of how to set up a top 20 products analysis based on the user selection of the subsidiary and time period.
- Simplify Your ABAP Data Access to Planning Applications
by Alfred Ho, SAP Technical Specialist, Husky Energy
Use the ABAP code in this article to enhance standard function modules in Strategic Enterprise Management Business Planning and Simulation (SEM-BPS) so that you do not have to worry about externally formatted values.
- Simplify Your SAP NetWeaver BW 7.0 Upgrade with This Comprehensive Checklist
by Uday Gupta, Business Intelligence Lead, J. Crew (August 2010)
Upgrading an SAP NetWeaver BW system includes many detailed steps and customizations that depend on your business requirements. Creating a comprehensive checklist allows you to customize the process and ensures that you cover every base to end with a successful implementation. In this case study, I describe the steps my team and I took during such an implementation and tell you the lessons we learned and the tips and tricks we took from our experience.
- 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
DataStore object data usually updates when the user or system generates or changes source system documents. The data flows into SAP BW via a full load or delta queue extract. Unfortunately, the real world sometimes intrudes on this ideal scenario and requires you to edit data in BW directly. Discover the pros and cons of three methods of editing data in BW.
- Uncover Process Chain Execution Errors When SAP NetWeaver BI Fails To Notify You
by Jeevan Kumar Ravindran, Independent BI Solution Architect
Learn how you can implement a custom watchdog program in just three steps to back up the standard messaging functionality. This ensures that you find out about process chain errors as soon as possible and allows you to quickly address issues as they arise. Also find out tips to optimize your use of the watchdog program.
- Use This SAP NetWeaver BW Data Model for Easy Fill Rate and Cycle Time Reporting
by Anuj N. Babel, Deloitte Consulting LLP (June 2010)
Discover an SAP NetWeaver BW data model that you can use to generate fill rate and cycle time reporting using standard data sources from sales and distribution. This generic data model uses ABAP transformations, which you can modify to align with your specific business process flow.
- Wait Process Type Offers an Alternative to Third-Party Job Schedulers
by Shailesh Unny, Senior Consultant, BearingPoint
Find out how you can create a wait process type to handle dependencies across process chains. When combined with the standard start process type, the wait process type ensures that only one dependent program runs at a given time, which prevents conflicting processes from running.
|
|
