Any idea on how to do this, guys, in OBI EE?
Look at the AGO() time series function in OBIEE.
If you did model your time dimension correctly, it will do the job. If you don't have a proper time dimension in the RPD, you should start there.