Is there a way to create the function to show the Quarter and Total Year as function from ADB cube
We want to create the report retrieved the data from ADB Cube in ERP. The thing is in the Accounting Period Dimension, it consists of Years, Quarters, Months and Dates.
The columns in the report should display i.e. FY21, Q1 FY FY22, Q2FY FY22, Q3 FY FY22, Q4 FY FY22, Previous Month and Current date
We know that we can put CurrentPOV function for current date and Parent with ReriodOffset Function for Previous Month
However, we are struggling on creating the function for Quarter and Year
Kindly advise us this matter
Thanks & Regards
Content (please ensure you mask any confidential information):