I have a question regarding cumulative data. I have a BI infocube which is getting a request every month for cumulative data. But in BPC, I want to show the data on monthly basis. I am aware that if I load the data in BPC on periodic measure, I can report it on YTD/QTD basis, but not sure if the reverse also works, i.e. load data on YTD (or cumulative, since a set start time) and show and plan on periodic level.
If not, what are the options for me to achieve it like end routine in BI staging .
Thanks for your suggestions.