I have following problem: There is an InfoCube with stock and sale information for each item and each day. I need a query to show the stock on the selected day and the sales of the last x days. How can I store this variable in the query? How do I define the Query? I tried a restricted key figure with a customer exit but I didn't get the current selected day. And if I change the filter value for the selected day in the BEx-analyzer I didn't catch the customer exit at all.
Does anybody have a suggestion.