FRAMEWORK MANAGER - RUNNING-TOTAL

[giovanni.lucarelli]

HI,

Please help me!!!!

does anybody know how to use "running-total" function in Framework Manager? this is my case:

In FM I created a Measure Dimension from a Query Subject:

Profit: xxxx (xxxx is a query item of my Query Subject)

then, I need another measuer as: Running-Total(xxxx)

everything seems ok but when I am going to use Running-Total(xxxx) in the report, for example:


Year   Profit Running-Total(xxxx)
2002   10    ???
2003   12    ???
2004   5     ???
2005   3     ???

the result is totally unsane; if I create a new query item in Report Studio as Running-Total(xxxx for [Year]) it works ok.... but i cannot put this in FM 'cause i don't know which kind of aggregation I need.

thanks to everybody!!!!!

[blom0344]

You either define the scope in the framework dataitem expression or you use an expression in report studio. I believe there is no way - AFAIK - to add the scope in second instance tot the running-total (this leads to incredibly bloated values)