Take the Guesswork Out of 0CALWEEK Selection

With a little tweak in 0CALWEEK, and by using a program provided on the BW/BI Expert Web site, you can make the 0CALWEEK selection more intuitive to use.

---

Can you figure out the date for the 45th week in the year 2006? Can you recall the week number corresponding to the week starting on December 18, 2006? Most of us cannot answer these questions correctly without referring to a calendar tagged with week numbers.

When we use F4 (possible values) on 0CALWEEK in the query selection screen, the resulting list contains only the week number and the year, as shown in Figure 1. Such a list of possible values does not offer much help in selecting the required week.