SAP BW Solutions for
Business Intelligence Professionals

Latest Posts

WEEKNIGHT in Formula Builder

WEEKNIGHT in Formula Builder

What night of the week is it? Ideally, midnight should be in the middle of the time interval being evaluated. Defining a ‘weeknight’ from midday to midday.

5 Reporting Variable Screen Experiences that Users Love to Complain About

5 Reporting Variable Screen Experiences that Users Love to Complain About

Ignore them to guarantee complaints and reduce confidence in the overall reporting solution.

How-To Rerun BI_TCO_ACTIVATION Job

How-To Rerun BI_TCO_ACTIVATION Job

Wondering why you don't have all the SAP BW Business Content available? Perhaps the BI_TCO_ACTIVATION job canceled and needs to a restart.

Where Is the BW Technical Debt?

Where Is the BW Technical Debt?

Solution Architects know how to use data modeling concepts to correctly assess a solutions technical debt.

What Is SAP Business Warehouse (BW)?

What Is SAP Business Warehouse (BW)?

SAP Business Warehouse (BW) is an Enterprise Data Warehouse, Reporting and Planning solution.

How-to Use TVARVC Values via ABAP

How-to Use TVARVC Values via ABAP

Using a small snippet of ABAP code, the TVARVC records can automate configurable system behaviour. Significantly reducing the BW Support Debt.

Resources

Resources

Looking for a specific resource? Try the document direct download links, here ...

STVARV Transaction for Flexibility

STVARV Transaction for Flexibility

Use the STVARV Transaction to maintain the TVARVC configuration table. This will allow hardcoded BW solutions to be flexible and supportable.

MiniSAP BW v7.5 on HANA Trial

MiniSAP BW v7.5 on HANA Trial

The 'SAP NetWeaver AS ABAP and SAP BW v7.5 SP01 Trial on SAP HANA v1.00.102 Database' cloud based developer edition is now available.

What is the Difference between BW and BI?

What is the Difference between BW and BI?

While they look closely related, the difference between BW and BI is as big as a real tree versus an ideal goal.

How-to Enforce DTP Semantic Group

How-to Enforce DTP Semantic Group

Optimised BW Transformation solutions can leverage the DTP Semantic Group configuration. This solution enforces selection of specific DTP Semantic group fields.

What Is a BW Staging Cube?

What Is a BW Staging Cube?

A BW Staging Cube has it's own unique name, so it must be special. Right?

WEEKNIGHT Function versus WEEKDAY

WEEKNIGHT Function versus WEEKDAY

Is my SAP BW Nightly Load Window suffering from a 'Before Midnight' limitation? A WEEKNIGHT Function aligns to Business Requirements much better.

Support Debt from Technical Debt

Support Debt from Technical Debt

Each piece of Technical Debt has the ability to become multiple instances of Support Debt, compounding the time wasted by BW Support personnel.

Time Zones in Reporting

Time Zones in Reporting

Most enterprise requirements will ignore the misalignment of time zones in reporting. Why is this ok? Most of the time ...

Timeline Dimensions and Perspectives

Timeline Dimensions and Perspectives

Why are there so many perspectives through multiple timeline dimensions when there is only 1 real timeline?

Hardware Defines the MiniSAP Experience

Hardware Defines the MiniSAP Experience

While the software is free, you will waste a lot of time and money if you use under performing hardware. The hardware defines the MiniSAP experience.

Where to Download MiniSAP?

Where to Download MiniSAP?

The SAP NetWeaver Application Server ABAP Stack free trial has four options available. Choose the right one before finding out where to download MiniSAP?

MiniSAP Download Links

MiniSAP Download Links

Where can I find the MiniSAP download links for the SAP NetWeaver Application Server ABAP Stack free developer trial?

Performance Boost with FOR ALL ENTRIES IN

Performance Boost with FOR ALL ENTRIES IN

Use the FOR ALL ENTRIES IN statement to boost performance by minimising DataPacket processing overhead in the database and application server.

Supportable Coding in Data Warehousing

Supportable Coding in Data Warehousing

How can we approach coding in data warehousing solutions that will more likely be approved in a peer review by the BW Support team?

SYST-UZEIT in Formula Builder

SYST-UZEIT in Formula Builder

Complete the availability of Date & Time fields in the SAP BW Formula Builder. Add the SYST-UZEIT field to the list.

Fiscal Calendars for Local/Group Reporting

Fiscal Calendars for Local/Group Reporting

Each country has its own local government tax reporting obligations driven by local laws. Can your SAP BW DataModel adapt to time dimension changes?

Process Chain Issues

Process Chain Issues

The process chain solution is out-dated soon after go-live. Despite this; the advantage of automation is worth the time and effort. Now what?

Who Pays for Post Upgrade Activities?

Who Pays for Post Upgrade Activities?

I've upgraded SAP BW but the job is not finished yet. Now its time to implement the post upgrade activities. Who is going to pay for the effort?

Enhancements and Best Practice DataModeling

Enhancements and Best Practice DataModeling

The idea of reaching a summit of SAP BW Best Practice DataModeling is an illusion. There is one clear reason why we can get close but never arrive.

7Cs of BW Information Lifecycle Management

7Cs of BW Information Lifecycle Management

A BW Data Warehouse without a BW Information Lifecycle Management (ILM) strategy will waste valuable personnel time and increase operating costs.

Characteristic and Key Figure for Reporting

Characteristic and Key Figure for Reporting

Characteristic and Key Figure for Reporting are not just Words and Numbers.

Creating My SAP BW Document Library

Creating My SAP BW Document Library

Process Documents and Application Documents are the two most beneficial types to have in my BW Document Library. Why do I want them?

Process Documents for BW Team Members

Process Documents for BW Team Members

There is a way to save time, save money, communicate expectations, reduce new starter overhead and enable self-service ... process documents.

Approving BW System Improvement and ROI

Approving BW System Improvement and ROI

The relationship between approving BW system improvements and the question "Whats my Return on Investment?" must consider a bigger picture.

Custom Data Flow Diagram Features

Custom Data Flow Diagram Features

The true purpose of the custom data flow diagram features is efficiency by being clear and simple; not an all-in-one detailed visual representation.

Custom Data Flow Diagrams Are Invaluable

Custom Data Flow Diagrams Are Invaluable

Custom data flow diagrams make it easy to absorb a BW system. Discover in minutes what can never be made clear from within the BW system.

Master Data Maintenance for Reporting

Master Data Maintenance for Reporting

How much time and money is wasted ... should all master data maintenance be centralised into a single system?

Process Chains in Process Slots

Process Chains in Process Slots

Process chains automate data processing. They can also cripple a BW system when not configured properly. Find out how ...

BW Feature Tests Help Set Expectations

BW Feature Tests Help Set Expectations

To get the best Return On Investment (ROI), use BW feature tests to focus the teams' effort based upon facts, not guesses.