[4231] in sapr3-soft
BW
daemon@ATHENA.MIT.EDU (Randall J. Thorne)
Sat Sep 25 20:27:35 1999
To: sapr3-soft@MIT.EDU
Date: 24 Sep 1999 12:11:10 -0500
From: "Randall J. Thorne" <rthorne1@rochester.rr.com> (by way of SAP Moderator <sap-request@realtimeusa.com>)
Message-Id: <7sgbbe$n1u@nexus.netconcepts.com>
Hi All,
Has anyone encountered the need to traverse the time dimension in a BW
query to calculate a key figure? Something like a moving average total,
that would look something like this:
(Past 12 months of COGS summation)/12, (Past 12 months (one month earlier)
of COGS summation)/12, (Past 12 months (two months earlier) of COGS
summation)/12........
Such that you get a historical moving average total across time to come
back to Excel? I was wondering if anyone has had any success with either
of the customer exits, rsr00001 (allows you to set a variable) and rst00002
(allows you to calculate a key figure)? This seems like it would be a
common need for queries, I know my clients are asking for it and I've been
doing it using VBA. If anyone can point to an easier solution that would
be great!
Randy Thorne
