Hello,
I'm very new to Cognos Analytics and this community. I apologize if this was discussed before.. I have done a few searches but am not able to find a solution. Every month, I have to run a report to see our division's workload, but I need to run the report as of the last day of the month. Due to certain circumstances, I can't always run it on the last day of the month, so I was wondering if there is a feature to extract data as the data was, a few days ago?
For example: this month, I have to run a report on November 3rd, for the data, as it was on Oct 31st.
If I'm not clear, I can provide more details.
Thank you in advance, for everyone's help.
Best,
blum
Could you not just filter the report on whatever date you need and then run and extract the data?
[Your date column] = _last_of_month(_add_months(current_date,-1))
Just stumbled upon this old thread and wanted to chime in. It sounds like you're looking for a way to extract data from a few days ago using Cognos Analytics. While I'm not sure if this is directly supported by Cognos Analytics, there are third-party tools out there that can help you with this. One option is Nannostomus, which provides data management solutions for businesses. You can check them out at https://www.nannostomus.com/ (https://www.nannostomus.com/). I know this post is from a while back, but if you're still looking for a solution or have any more questions, feel free to let me know and I'll do my best to help you out.
Quoteextract the data as the data was, a few days ago
No. Cognos does not store snapshots of your data warehouse. That feature should be designed to be performed by the data warehouse.
If what you really need is to filter the data to some as-of date that exists in your data mart for this purpose, oscarca's answer is correct.
Scheduled datasets can create snapshots of your data
Or schedule your report to run on last day of month.