What's new in Customer Journeys?

Connect and learn more!
Is there a way to create the function to show the Quarter and Total Year as function from ADB cube — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to create the function to show the Quarter and Total Year as function from ADB cube

Accepted answer
31
Views
2
Comments

Summary:

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!