Tuesday, July 03, 2012

BW dataflow examples for HR masterdata

It happens quite often, source data comes from a single infotype, but users want informations coming from different subtypes moved to different infoobjects on the same row (i.e. one row per employee per time period), this usually requires some ABAP but there is a trick.
You can use infosets to differentiate logically between rows of the infotype, see below:

This example is quite specific for time dependend masterdata attributes (think 0EMPLOYEE).
It's like having the ability to run different transformations from the same source to the same target according to different values of one column.

Something like inverted rule groups, which are great at turning data in a long row into data in different columns:

An example of rule group usage:

PERNR LGA01 BET01 LGA02 BET02 etc

turned into:

PERNR LGA01 BET01
PERNR LGA02 BET02

which can fit nicely into an infocube.

Friday, April 06, 2012

Texts in the output of an APD

There seems to be interest in outputting not only the query results in APD but also some texts, which is currently not supported by simply having the query output contain texts as anyone would expect.
But, there is an easy solution, see figure below






Here you are.
Sending it out to a file doesn't change the other steps.