Using Cube 0FIAP_C03 A/P Payables in BW3.5 and Query Designer. I have a need to take the open items and group them by days past due.
First step I created a new key figure to take todays date (key date) and subtract the net due date. This provides a numeric value of the days past due. So far, so good.
Then I created another key figure that was the days past due divided by 7 and I displayed the output with zero decimals. This appears to get the buckets, but I cant find a way to display/group the amount by these buckets for the report. But I cant find a way to get the Amount (doc currency) to show in buckets (columns) like current, 1-7 days past, 7-14, etc.
All thoughts appreciated, I may of headed in the wrong direction when there is another approach. Thanks.