COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: alliecat61 on 08 Feb 2016 12:19:35 PM

Title: Historical Date Question
Post by: alliecat61 on 08 Feb 2016 12:19:35 PM
I need to add a historical date to a report.  The date I need is December 31, 2015.  The data field I need is "current balance".  What date expression would I use?
Title: Re: Historical Date Question
Post by: bdbits on 09 Feb 2016 09:32:25 AM
You've not provided nearly enough information. Relational? Dimensional? How is the date you want to filter on stored in your data source? Is there a time dimension? Or is it an attribute of a table? Member of a dimension?
Title: Re: Historical Date Question
Post by: BigChris on 09 Feb 2016 09:59:50 AM
Are you trying to run a report for the previous year, so that you can run the same report again next year without having to edit it?