trended PTD report in BCA needs YTD

[msimonsen]

Hi - I can easily create a report using a filter I created that brings back 13 months of data, as PTD actual. However, I now need to add YTD based on the last month retrieved, and I only want YTD to appear once, not every time the PTD object appears. Is there a way to create an object that dynamically updates with the last PTD to calculate YTD and only appears at the end? need to scheduled through BCA.

Thanks,
manal.

 

[raysnj]

Show us your data to work on.

ray

 

[msimonsen]

Not sure what you mean. But my PTD_actual is a metric, and my YTD_actual is a metric. My period is a dimension and I have a rolling trended 13 month filter, that takes the last closed month and goes back 13 months. The customer, needs to display the PTD for the 13 months and then YTD just once. I am using BO5.1.6 and and Oracle 8..1.7 db. YTD is based on which month was last displayed. Therefor, as the months roll forward, so does the YTD need to adjust. The customer doesn't want ot create this in a report but wants it done in the universe.

EG:
Nov02.. Feb03 March03 ... Nov03 YTD
Revenue 10.... 15 20 30 30

Thanks,
manal.