Report with dynamic year to date and month to date

[Crystal_Cognos]

Can I create report with dynamic column.  example as attached. Thanks.

[schrotty]

Hi,

Do you have a dimensional or relational Model?

in a dimensional you can use the periodstoDate-Function to build ytd or mtd-functionality.

[Crystal_Cognos]

I have dimensional model, in Cognos 10.2  I can't find express mode to build report, can I use the normal mode? Does Analysis studio can do this dynamic report?

[schrotty]

What do you mean with express and normal mode?

This is the Report Studio Forum so you can build it with Report Studio.

http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html

[Crystal_Cognos]

I used to work in report studio, if you select express you can work on DMR report, I don't remember very clear.

Thanks for your document. :)

[MFGF]

I used to work in report studio, if you select express you can work on DMR report, I don't remember very clear.

Thanks for your document. :)

Hi,

I think you're getting a little confused. Express mode for Report Studio used to be a simplified interface for authoring financial-style reports, but you could do that (and much more) in "normal" Report Studio too. You can use DMR packages in Report Studio.

Cheers!

MF.