Trailing Twelve Months in Oracle EPM ASO Cube
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.
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):