Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: ML on 26 Feb 2020 04:50:58 AM

Title: Show value for date previous to what is displayed on the Dimensional Report
Post by: ML on 26 Feb 2020 04:50:58 AM
Hi,
I have a report based on a dimensional cube.  I want to add a new column called 'Closing Balance' to display the Raw Average figure.
The closing balance for the previous date is the opening balance of the date displayed on the report.
ie Opening Balance for 2020-02-26 equals 21,352.  Therefore the 'Closing Balance' for the previous date 2020-02-25 equals 21,352.

I have a dimension in my report called Historian_Current_Month and I am displaying the date level which is level 2 of the dimension.  The Member set name in the report is Current_Month.  Set definition for this is...
descendants([Historian_Current_Month],2)

Thank you
Title: Re: Show value for date previous to what is displayed on the Dimensional Report
Post by: Andrei I on 26 Feb 2020 07:48:03 AM
Can you add an example of a layout you need?
Text only | Text with Images