Hi, I am trying to create a filter in FAW workbook that shows last 3 Fiscal Years dynamically, say FY2021, FY2022 and FY2023 and users can select/deselect the options as per their requirement. I tried to create a parameter but it only let us select one particular option as the default value whereas I want all the years to be selected by default, also it doesn't seem to be working fine as it just shows the value that is selected as initial value in the LOV and doesn't show all the three Fiscal Years. Can anyone help me with this?

Hi @CarolineAnderson, I was able to create the dynamic filter for Fiscal Year as expected by using parameter. I was not able to do so earlier because somehow multi select option wasn't working for me, but now It works. So, I created a parameter and put up a SQL to get last 3 years dynamically in the possible values and used same query in the initial value.

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

Dynamic filter in FAW for Fiscal Year

Accepted answer

273

Views

Comments

Answers

Jamie Anderson-Oracle Admin

Apr 22, 2025 1:37PM

In addition to my above comment, here is the product documentation for what was formerly named Fusion Analytics Warehouse (FAW) but is now referred to as Fusion Data Intelligence:
https://docs.oracle.com/en/cloud/saas/analytics/25r1/index.html
You can also reference the Oracle Analytics product documentation since Fusion Data Intelligence uses the Oracle Analytics platform:
https://docs.oracle.com/en/cloud/paas/analytics-cloud/index.html
@User_2O5NO

1

Oracle Fusion Data Intelligence

Categories

Dynamic filter in FAW for Fiscal Year

Answers