Hello All, We have a requirement to show last 12 months of data based on Current Month Period in OAC, we know this can be achieved through OAC Classic Home in FDI,Would like to know how this can be achieved in FDI OAC. In below example we have used filters in different columns to show data by period which is static. wanted to achieve this in dynamic method. Please let us know your thoughts on displaying last 12 months of data based on current month filter to accommodate dynamic solution Thanks, Vaigu

@Vaigu_27 1. Create a custom table with fiscal period column and corresponding custom date column containing the first date of the fiscal period. 2. Extend the prebuilt time dimension using this custom table. 3. Create a filter based on this custom date column and bind a parameter. 4. Create an expression filter using "Financials - GL Balance Sheet"."Time"."Custom Date" between TIMESTAMPADD(SQL_TSI_MONTH, -12,@parameter("Fiscal Date")(current_date)) and @parameter("Fiscal Date")(current_date) Other suggestions are welcome. Regards, Bala.

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Fusion Data Intelligence

Displaying last 12 Months of Data based on Current Month Parameter in OAC

Accepted answer

827

Views

Comments

Answers

User_WQKHO Rank 3 - Community Apprentice

Oct 30, 2024 6:46PM edited Oct 30, 2024 6:46PM

Hi @BalagurunathanBagavathy-Oracle ,
I'm implementing this last solution, and it works - only issue is that the filter prompt selection is not super user friendly - is there any way to use the "month" field (for example Oct 2024) and compare it to the fiscal period start date rather than having to choose a date value that looks like this?

Thank you!

0

Oracle Fusion Data Intelligence

Categories

Displaying last 12 Months of Data based on Current Month Parameter in OAC

Answers