Ask the Expert

Suggestions for preparing a trend report

We have a 13-column trend report in BW -- 12 months rolling, plus a 12 month total column. The selection screen asks for the month you want to start with. The column calc is 'selection month +1', 'selection month +2', etc.

We run into issues during closing periods. While we are interested in seeing info for the only the months in the year through the closing month, when we are viewing this trend report on the first few days of the next month, it shows that data. Besides creating another report, or not loading the next month's data for a few days, do you have any other suggestions?

    Requires Free Membership to View

This can be resolved with the help of variables, user exits and restricted key figures, provided you are storing the previous closing month in BW. In the user exit, you can check for this month and pass the value of the closing month to the variable which will give you the desired result.

If you are using this approach and still having issues, it could be the case that the values you are seeing in the beginning of the month are valid. In most of the applications you will see transactions happening for a few more days for the past period, even after the period is past but not yet closed. Most business take 2-3 days into the new period to close past period. Check with your business users and see if this is happening, and if so, ask them for a decision on these transactions.

This was first published in July 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: