Hello,
i have the following problem. in my database are for example these datas:
15.Feb.2008 10
31.Aug.2008 5
How can i roll up the measure in the transformer that it should give back always the latest measure. For Instance, when i quest in the report studio for the measure in January 2009 it should give back 5 and not null, even there is no measure in January!!! alway the latest data.
is this possible??
i´m very thankful for any kind of help!!!
Hi ,
It can achieved by setting the proper rollup type to the measure.i.e, Time based rollup.
suppose if you always want to see the recent measure values from the selected time period, Select Measure properties->rollup->TimeState Rollup-> select Last Period.
Regards,
MC