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

 

How to get previous year First day of last month in cognos relational model?

Started by peewan, 01 Apr 2020 11:42:06 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

peewan

01 Apr 2020 11:42:06 AM
How to get previous year First day of last month in cognos relational model?

Example:
I have report run 1/1, 2/1, 3/1 - 2020 base on 12/1/2019, and want to schedule it run for every year.

BigChris

#1
02 Apr 2020 01:54:33 AM
_first_of_month
_add_years
_add_months

are the functions that you need to use
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite