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

Calculate Monthly report data using Weekending Date

Started by Cognos Man, 17 Mar 2021 08:13:31 AM

Previous topic - Next topic

Cognos Man

Hello Gurus

I need to calculate a logic on the basis of Weekending Date in a report for the Monthly report

We have two pages of reports in the report studio
1) Weekly Report with the weekending data (Example: 26/02/2021) Day 1 of the week starts from Saturday to Friday
2) Monthly Report with the month data. I know the monthly calculation to get the data current month data using the below
TRANSACTION_DATE between _first_of_month (_add_months (current_date,0) and _last_of_month (_add_months (current_date, 0)

But here the requirement is how can we calculate based on the Weekending Date. The requirement is to show the previous month data even in the 1st week of next month (New Month)
that is from (01-Mar-2021 to 05-Mar-2021) since the weekending of the weekly report is showing the data for 26/02/2021 (Friday).

This should work dynamically since this is a scheduled report and we are not having any prompt page to select the date ranges since the report take to long to execute.

Please share your ideas and thoughts on this.

Your help is much appreciated.

Yours Sincerely
M Rao