If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

roll up measures

Started by quanto, 17 Aug 2009 11:54:11 AM

Previous topic - Next topic

quanto

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!!!


Mpotla

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