Friday, November 30, 2012

In one of earlier post I
mentioned Time characteristics as Rule Type in Transformations. We can see how
useful they are here.
Especially in case of derivation of week (0CALWEEK) based on calendar day (0CALDAY).
To decide into which week particular day falls might be tricky. Basically the
main problem here is to decide about first/last week of year. It depends on calendar
implementation which may differ from country to country. By default BW logic is
govern by ISO (International
Organization for Standardization). Its definition 8601 of first week (in
short) is following:

- First
day of the week is always Monday

- First
week in year is week that includes January 4th

You can override this
definition by implementing BadI CALENDAR_DEFINITION (for SAP Basis 62 & 64)
and by Enhancement Spot (Basis 7). For details refer to SAP Notes below. To be
honest this is not easy topic. :-)

Wednesday, November 28, 2012

Using IF statement is very
convenient how to evaluate the data. As usually BW developers are coming with
programming background it is very obvious that they are looking into such statements.
Although it is not very obvious from the very modest menu of functions in BEx’s
formulas IF is possible it is just not easy to realize how this can be
achieved.

About Me

Working as a Business Intelligence consultant (at percept ltd.) in SAP area specializing on SAP NetWeaver (BW, BI). Certified as SAP NetWeaver Business Intelligence consultant. From Bratislava, Slovakia.
More information