How can I get numbers for the last 10 days in a report built on a Powercube? I suppose I will have to use i.e (_add_days(current_date, -10)) in some way.
This variable will then be used as filter on the date dimension in the cube.
Can someone give me some examples? Thanks!
Hi,
If your time dimension does not include future dates, you could try the following expression in a query calculation:
lastPeriods(10,closingPeriod([day level of your time dimension]))
Regards,
MF.
It would have worked out fine, BUT I have future dates in my time dimension.
I would like to have the last 10 days from today (sysdate), but I don't know how to do that.