If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date of data extraction

Started by blum, 30 Oct 2020 02:16:03 PM

Previous topic - Next topic

blum

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

oscarca

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))


HeatherReynolds

#2
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/. 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.

dougp

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.

Cheeks100

Scheduled datasets can create snapshots of your data

Cheeks100

Or schedule your report to run on last day of month.