Hi All,
I'm need to automate a cognos 10.2.2 report studio report using the Transformer cube as the the data source.
I need to create a filter current month (MTD) and previous month on the report. The dates is based on Posting date in the hierarchy as
Year: 2019
Month is :2019/May
Date: 20190503
for instance if its current month : the report should show the dates from 1st of that month to current date.
if its previous month: the report should show 1st of previous month to current date.
Please help me . its an urgent request.
Thanks.