Hello experts, we are using BI 7.0 (NetWeaver 2004s) and are trying to create some reports (using Business Explorer tools) from a cube we created (in order to meet the business's specific needs), which is based on cube 0FIAR_C02 (Accounts Receivable - Transaction Data) with data source 0FI_AR_4. What we need to present is transaction data from different time intervals for each account. The intervals are 30, 60, 90 and 120 days. The idea is that the user inputs a date when he runs the report, and those intervals with their receivable amount are calculated.
For example, if I run the report and I input date 05.01.2009 (May 1st, 2009), the query should calculate for each account receivable the amounts open for roughly 04.01.2009 (30 days), 03.01.2009 (60 days), 02.01.2009 (90 days) and 01.01.2009 (120 days). We only have current information from each account, but we have seen that somehow the information for all intervals can be calculated.
We thought about solutions on the BEx side, but could not find anything useful with variables and the like.