Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Crystal_Cognos on 14 Jul 2016 08:07:14 PM

Title: Report with dynamic year to date and month to date
Post by: Crystal_Cognos on 14 Jul 2016 08:07:14 PM
Can I create report with dynamic column.  example as attached. Thanks.
Title: Re: Report with dynamic year to date and month to date
Post by: schrotty on 15 Jul 2016 04:45:14 AM
Hi,

Do you have a dimensional or relational Model?

in a dimensional you can use the periodstoDate-Function to build ytd or mtd-functionality.
Title: Re: Report with dynamic year to date and month to date
Post by: Crystal_Cognos on 15 Jul 2016 09:19:21 AM
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?
Title: Re: Report with dynamic year to date and month to date
Post by: schrotty on 18 Jul 2016 08:33:56 AM
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 (http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html)
Title: Re: Report with dynamic year to date and month to date
Post by: Crystal_Cognos on 20 Jul 2016 02:26:32 PM
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. :)
Title: Re: Report with dynamic year to date and month to date
Post by: MFGF on 21 Jul 2016 03:16:41 AM
Quote from: Crystal_Cognos on 20 Jul 2016 02:26:32 PM
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.
Text only | Text with Images