Calculations at Framework level

[cognos8_1]

Has anybody worked with MTD, YTD calculations at the framework level?

[sir_jeroen]

What type of model did you build? DMR or relational?

[cognos8_1]

tell me wrt to both DMR and Relational.

[sir_jeroen]

wrt=????

[cognos8_1]

well I meant , please do let me know in case of a DMR model and also for Relational ...


Thanks

[sir_jeroen]

if you have a time dimension in your cube or dmr you can use the relative time functions that are provided for dimensional reporting.

[larsonr]

We actually have done these with relational modeling. With a well thought out and implemented time dimension you can do some very functional and powerful relative time calculations.  Refer to the proven practices guide at support.cognos.com for some guidance on how to manipulate relative time in Framework manager. 

[Desperado]

Please tell me how to do YTD in FM level using relationsla model ....We have the same scenario now and we r stuggling in doing it .

Thanks in Advance