Revelator80
Technical User
Hi,
I followed the IBM instruction for creating a YTD data item for my reporting purposes, which is working well. However, I want to be able to implement LAST YTD and similar functions. Whenever I try, using either the parallelperiod or prevmember functions (as these seem most useful) I get errors.
My data source is DMR and, as prescribed by IBM I have data items for selected month (just sets the parameter), year to date set: periodsToDate([DW_Present].[Time Information].[Time].[Financial Year];[Selected Month]) and finally the data item for the spend YTD: (total([Evidenced Spend] within set [Year to Date Set]))
My assumption is that I would need to edit one of these to get last YTD. Any advise would be gratefully received.
Cheers
David
I followed the IBM instruction for creating a YTD data item for my reporting purposes, which is working well. However, I want to be able to implement LAST YTD and similar functions. Whenever I try, using either the parallelperiod or prevmember functions (as these seem most useful) I get errors.
My data source is DMR and, as prescribed by IBM I have data items for selected month (just sets the parameter), year to date set: periodsToDate([DW_Present].[Time Information].[Time].[Financial Year];[Selected Month]) and finally the data item for the spend YTD: (total([Evidenced Spend] within set [Year to Date Set]))
My assumption is that I would need to edit one of these to get last YTD. Any advise would be gratefully received.
Cheers
David