BW Development Standards

The ebook details on Standards and Guidelines for BW implementation projects.

This ebook includes following topics which are very helpful for a BW Developer-

BW Development Standards Part 1: Architecture – BW System architecture, generic guidelines

BW Development Standards Part 2: LSA – LSA and LSA++ Differences, Referential Integrity, Data Acquisition layer, Business Transformation Layer and Reporting Layer

BW Development Standards Part 3: Data Modeling in Multiproviders and Infocubes – Fact table design, master data design, navigational attributes, modeling guidelines for attributes and hierarchies, design choices and their performance effects

BW Development Standards Part 4: Master data modeling – Options for modeling attributes

BW Development Standards Part 5: Transports – General Transport guidelines, object grouping and sequencing, collecting objects, changing and transporting Infoproviders, handling transport errors
BW Development Standards Part 6: BW Accelerator (BWA) – How BIA effects query processing, BI accelerator standards, adding new data to BIA index via process chain, Implications to InfoCube Management of Using the BI Accelerator

BW Development Standards Part 7: Reporting Guidelines – Querying, Report Template, Report Elements (SAP Business Explorer Elements), Reporting Authorizations

SAP BW Front­End Usage Standards and Guidelines – Chart Designer in Web App Designer, Nested Web Templates (Web Template Web Item), Adhoc Query Designer, Mass Maintenance of Web Templates

BW Development Standards Part 8: Data Extraction Technology

BW Development Standards Part 9: Process chain Standards and Guidelines

BW Development Standards Part 10: Flat File Management Guidelines

Designing and Building Secondary Indexes on DataStore Objects

BW Data Retention / Archival and Space Management Guidelines

SAP BW Back-End Usage Standards and Guidelines – Write ­Optimized DataStore Objects

SAP BI Business Content

Get in Amazon at amazingly low prices.

BW Development Standards Part 2: LSA

LSA stands for ‘Layered Scalable Architecture’. This is followed as a general thumb rule in BW systems running on Oracle database. With the advent of HANA, LSA is now replaced with LSA++

Below is the generic LSA architecture details and guidelines.

Data Acquisition Layer

This layer is the first layer of write-optimized DSOs which have raw data coming from the source.

This  layer can be skipped if not required as Continue reading “BW Development Standards Part 2: LSA”

BW Development Standards Part 1: Architecture

In large projects as well as small implementations, it is always be required of the Developer to follow certain standards.

The client will share his/her own set of standards to the developer before the start of the project.

However there are certain set of generic standards to be kept in mind as a good developer.

Whenever your design needs deviating from the said standards, you need to Continue reading “BW Development Standards Part 1: Architecture”