How to fetch the contract end date of a future contract extension using OTBI?

Summary:

Hi All,

We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract End Dates for the contract that is currently active. Is it possible to fetch the Contract End Date of a future contract extension?

Please see the example below. Before the start date 01-07-2022, OTBI only fetches the 'current' end date 30-06-2022. What we need to see is the Contract End Date of the new Contract Extension: 31-12-2022.

Thank you and kind regards,

Ben

Content (required):

Version (include the version you are using, if applicable):