|
|
Categories
»
Data Modeling
Data Modeling
- 22 Ways to Improve BW Back-End Performance
by Nurullah Battal, Turquoise Consulting
You have three key areas where you can boost BW performance on the back-end: the collection and extraction layer, the transformation layer, and the staging and storage layer. The author provides speed-up tips in all three of these areas.
- 24 BW Design and Data Modeling Tips for Optimal ETL
by Catherine Roze, Senior BW Consultant, IBM Business Consulting Services; and Joffy Mathew, Senior BW Consultant, Quinnox
Inc.
In terms of performance, you get the biggest return on ETL optimization in the design and modeling stages. We give you tips in six categories: general design and data modeling, PSA design, InfoCube design, ODS design, Dimensions and characteristics design, and aggregates.
- 5 Tips for a Successful Global Data Warehouse Project
by Gary Nolan, Independent BI Strategic Architect
Establishing a global enterprise data warehouse (EDW) can involve many unique challenges. Recognizing and negotiating these challenges can yield a global EDW with benefits to the entire organization.
- Balance-Sheet and Cash-Flow Planning with SAP NetWeaver BI
by Rajasekhar Gummapadu, Manager, Deloitte Consulting LLP
Balance-sheet and cash-flow planning helps you get your cash picture under control. Learn how to design a solid, flexible SAP NetWeaver BI data model for balance-sheet planning. Examine the five key steps required to create balance-sheet planning and cash-flow planning.
- Better Star Schema Design Means Better Performance
by Gary Nolan, Platinum Consultant, SAP America, Inc.
Implementing an efficient star schema data model in your BW environment is critical if you expect your system to perform well. The author introduces you to the star schema and explains how it is used across the BW system and in the InfoCubes that underpin the system.
- BW for Beginners: Teach Users InfoCube Basics with Excel and Better Reports Are Sure to Follow
by Kurt Goldsmith, IT Implementation Consultant, ICM America
This simple exercise is a friendly introduction to the confusing terminology of InfoCube, InfoObject, Dimension, and Attribute. Experienced BW professionals will find this article useful because it shows them a non-technical way they can teach the process to others in their company.
- Combine Data from Multiple R/3 Tables into One BW Table
by Rich Oxley, Kenakore, Inc.
Having to combine data from multiple R/3 sources into one BW table is a common requirement. Fortunately, BW 3.x provides a means - flexible staging - to carry out this requirement. The author shows how to configure flexible staging using an real-world example.
- Data Modeling Advice: Where Do I Put My Sales Area Data?
by Ned Falk, Senior Education Consultant, SAP America
How you break up your sales area data into dimensions will have an effect on performance.
- Data Modeling with Time-Dependent Master Data
by Gary Nolan, Platinum Consultant SAP America, Inc.
Depending on the setup of your system, new master data can overwrite your old data when it is loaded. However, you can view data from a certain point in time with time-dependent master data. The author debates the benefits and drawbacks of adding time dependency to your data model.
- Enhancing DataSources in Standard Business Content to Suit Your Needs
by Nathan Genez, Platinum Consultant, SAP America
Sometimes the SAP-delivered Business Content does not map exactly to your requirements and you must modify it. This article explains how to add a field to an existing DataSource.
- Experience Faster Enhancements with the Remodeling Toolbox
by Allison Levine, Senior SAP Business Analyst, Tesoro Companies, Inc. (September 2009)
The new remodeling toolbox in SAP NetWeaver BW 7.0 enables you to decrease your enhancement delivery times and increase end-user satisfaction. Find out when you should use it and learn tips for overcoming issues you may encounter.
- 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.
- How to Make a Near
Real-Time InfoCube
by Duncan Foster,
Information Strategy
Consultant, CSC EMEA
North (November
2008)
Near real-time data is not possible as standard with InfoCubes in SAP NetWeaver BI 7.0. Only DataStore objects can use real-time data acquisition (RDA). However, InfoCubes provide better performance than DataStore objects. Find out how you can model InfoCubes to facilitate near real-time data.
- How to Migrate to the New DataSource Concept in SAP NetWeaver 2004s
by Nathan Genez, Principal Consultant, Serio Consulting LLC
A new data flow concept has been introduced in SAP NetWeaver 2004s. SAP still supports the existing classic 3.x data flow, which allows customers to migrate as their needs warrant. Although the migration is not required, it presents a host of new capabilities.
- Keep Track of Characteristic Relationships within SEM-BPS
by Keith Howard, Managing Consultant, SEM, SAP UK
During the planning stages of a product, it is essential to consider changes in relationships among the product group, division, business unit, and profit center. The author demonstrates how to account for these variations using the characteristic relationship functionality of SEM-BPS. He focuses on the configuration of BW hierarchies, BW attributes, reference data, and user exits.
- Make DB Connect Delta Capable with External Sources
by Shreekant Shiralkar and Bharat Patel, BW System Managers, Bharat Petroleum, India
Most DataSources within an SAP system are delta capable. However, the delta capability is not available when you connect to external databases using DB connect. By following this process, you will be able to connect your BW system to an external database and make the DataSource delta capable.
- 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.
- Monitor the Health of Your System with BW Reports
by David Hill, SAP Basis Administrator, and Kumar Srinivasan, BW Consultant
The latest addition to the Computing Center Management System gives you the ability to extract Central Performance History data to your BW system where you can then analyze and correlate it graphically. You need a central monitoring system on Web Application Server 6.40 and BW Release 3.5. This new functionality can help you prevent unexpected outages of systems and applications as well as see trends and report on service-level agreements.
- Optimize BW’s Data Modeling Capabilities with BPS
by Peter Jones, Platinum CO, BW, SEM, Value Realization Group, SAP
Make the jump from reporting in BW to planning and data modeling using BW’s Business Planning and Simulation (BW-BPS). See how the InfoCubes, attributes, calculated key figures, and dimensions for planning differ from those you use in reporting. Get valuable tips about properly structuring your planning InfoCubes.
- Part 1: Data Modeling Strategies to Avoid Data Inaccuracy and Ensure Consistency
by Duncan Foster, Information Strategy Consultant, CSC EMEA Northern Region
Minimize and eliminate data inconsistency and inaccuracy in SAP NetWeaver BI environments by adopting and adapting the data modeling techniques described here. The author explains the accuracy, benefits, and drawbacks of each.
- Part 2: Data Modeling Strategies to Avoid Data Inaccuracy and Ensure Consistency
by Duncan Foster, Information Strategy Consultant, CSC EMEA Northern Region
Overcome the challenge of retaining the original master data attribute validity from when transactions occurred.
- Part 3: Data Modeling Strategies to Avoid Data Inaccuracy and Ensure Consistency
by Duncan Foster, Information Strategy Consultant, CSC EMEA Northern Region
Overcome the challenge of re-determining the master data attribute values for a transaction when changes in master data attribute values are back-dated.
- Quick Tip: Save Time When Changing ODS Data by Using a Reverse Load
by Frank Bulacher, BI Practice Manager, Enowa Consulting
You can change ODS data without needing to reload it or reinitialize it. The trick is to do a reverse load using these seven steps.
- Quick Tip: Use a Standard Hidden Gem to Create Your Development Landscape Data
by Stuart Chambers, BI Consultant, Innogence (April 2010)
Many development systems have small incomplete data sets, and some (Greenfields sites) have none. Find out how to effectively create data in InfoCubes in a timely manner by using the little-known SAP NetWeaver BW 7.0 program CUBE_SAMPLE_CREATE.
- Use Real-Time Hierarchies to Map Transactions to the Proper Groups
by Mark Reimer Caroli, IT Consultant, BASF IT Services
Create BW hierarchies to track products sourced from merging suppliers, and avoid the inaccuracies that can result when your supply partners buy (or are bought by) other firms. With an example based on a fictitious international company, the author demonstrates how to assign purchase orders correctly via a real-time hierarchy with user exits or BAdIs.
- 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.
- Use Virtual Time Hierarchies for Flexible Reporting with Time Characteristics
by Lorne Kellaway, Senior Business Systems Analyst, Alcatel-Lucent Canada Inc.
Activating virtual time hierarchies provides a flexible and convenient option for reporting on time characteristics. Not only is it simple to implement, it can immediately increase the functionality available to query designers and users. It can deliver reports with summary time groupings on existing time characteristics (based on 0DATE, 0CALMONTH, 0CALMONTH2, and 0FISCPER) with no changes required to the data targets.
- Virtual Characteristics and Key Figures Make Queries More Dynamic
by Jens Nissen, SAP BW/SEM Manager, NNIT A/S, Denmark
Though immensely useful, time-dependent attributes have limitations that can lead to inaccurate reports. The author explains the benefits of virtual characteristics and key figures, which use programmable BW user exits. He then walks you through five steps that will allow you to make the most of virtual characteristics and key figures.
- Visual Composer 7.0’s BI Extension Kit Offers New Data Modeling Capabilities
by Franklin Herbas, SAP NetWeaver Product Management, and Shan Jiang, SAP NetWeaver Development
Understand what’s new in Visual Composer 7.0. The BI Extension Kit, part of Visual Composer, includes many new design-time and run-time features that allow functional consultants to create analytical applications without coding.
|
|
