Tagged: performance

SAP TechEd 2013 – Take away session

On November 14th, Twan van den Broek and myself presented a session on Ciber’s Customer Knowledge Carrousel. This year the annual Knowledge Carrousel was hosted on a beautiful location; An ancient church called the Orangerie in Den Bosch Our session was all about this year’s SAP TechEd. We (tried to) capture(d)...

More

Jump start a ‘hanging’ Process Chain

Sometimes a step within a process chain seems to be ‘hanging’ for no particular reason, causing the process chain to wait in vain for it to finish. I’ve added, as an example, a screen-shot of a ‘hanging’ process chain step which extracted 0 records from its source system, but did...

More

Semantically partitioned object (SPO) wizard

A semantically partitioned object is an InfoProvider that consists of several InfoCubes or DataStore objects with the same structure. Semantic partitioning divides the InfoProvider into several small, equally sized units (partitions). SAP often uses the picture below the explain the SPO principle. As of BW 7.3, creating SPO based InfoProviders...

More

DataStore Object- SID generation upon activation

The week between Xmas and NewYear is the ultimate week to do some “housekeeping”. Therefore an “old school” tip regarding DSOs and the “SID generation upon activation” option. Thanks to Roger Pijpers for providing the necessary information

More

Perfomance vs statistics

Ever wondered why, even though you’ve deleted all indexes on your cube, the (massive) initial load still took a very, very long time? It’s all about (database) statistics! Unfortunately the statistics can’t be refreshed during (massive) data loading…even though you might think it’s possible, looking at the screenshot below. Unfortunately,...

More

Easy overview of (the runtime of) Process Chains

When you’re interested in the runtime of several process chains (eg. during last night), transaction codes RSPC, RSPC1 or RSPCM don’t do the trick completely.Luckily there’s a workaround via transaction code SA38, report name /SSA/BWTExecute the program, check radiobutton Process Chain Analysis and press F8. In the following screen press...

More