How To: Trigger Background Jobs with Background User
Many a times our User ID lacks the authorization to trigger a background job in a SAP system. This job can be scheduling of loads from ECC systems or any batch jobs. This blog explains how we can schedule such jobs to run with Background User ID. This can also be helpful for any background job user change. Nov. 15, 2009
Comments: 5   Rank:   Page Views: 596  (Stats updated nightly)

Activation of Transformation in Production Environment
Many a times transformations get inactive in the production or QA systems. This can happen due to changes/replication of datasources, inconsistencies caused by other transports, etc. The only plausible way to get the transformation to active state is to do a re-transport from the development box, which can lead in delay in data loads. This article provides a simple solution to activate the transformation directly in the production or QA environment. Nov. 6, 2009
Comments: 1   Rank: 13225   Page Views: 447  (Stats updated nightly)

Performance Tuning of Loads where delta is not possible
There are many standard master as well as few transactional data loads in BI which do not support the delta concept. An example can be the 0NOTIFICATION Load where in we have to go for full loads daily as the standard datasource misses the delta capability. Also many times we have to build customized datasource on tables/views where we do not have a particular field on which we can build the delta. These full load which run daily unnecessarily take a lot of time for processing data thus leading to increase in overall load times. This can be overcomed with the concept of Pseudo Delta. Jul. 28, 2009
Comments: 3   Rank: 10329   Page Views: 961  (Stats updated nightly)

Reducing Time taken for Compression Job of the Cubes
Long running compression job is a typical problem for cubes containing huge amount of data. The job keeps on running which eventually has to be killed and restarted, thus consuming lot of time. The compression time can be reduced considerably by managing the indices of the E-Table of the cube. This document illustrates the details and steps for managing the indices of the Cube. Jul. 16, 2009
Comments: 3   Rank: 10242   Page Views: 991  (Stats updated nightly)