Trailing Twelve Months in Oracle EPM ASO Cube

Summary:

Trailing Twelve Months ASO member formula not working as expected in ASO Cube

Content (please ensure you mask any confidential information):

As per the requirement, the TP12 in the screenshot below should display Oct-2022 data. However, it does not show any data for the prior years.

Requirement:

If you observe the first column, you can see the data as 10. However, the same is not appearing in the TP12 column.

Ad hoc results: Looking for the period Sep-2023

Any assistance will be greatly appreciated. Thanks in advance.

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

Code Snippet (add any code snippets that support your topic, if applicable):