Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICS dashboard prompt - Filtering fiscal year prompt to only show years greater than 2000

Received Response
51
Views
2
Comments
Ryanj Kocher94
Ryanj Kocher94 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BICS dashboard prompt - Filtering fiscal year prompt to only show years greater than 2000

Content

BICS dashboard prompt - Filtering fiscal year prompt to only show years greater than 2000

I am creating a dashboard that has a prompt for fiscal years. When you select the dropdown it gives the following values: (1, 2, 3, 2000, 2001, 2002, etc.) I want to create a SQL statement to only show years greater than 2000. Here is the SQL statement I have drafted.

SELECT "Time"."Fiscal Year" FROM "Financials - GL Balance Sheet" WHERE "Time"."Fiscal Year" >= 2000

Thanks,

Answers

  • Sarah Zumbrum-Oracle
    Sarah Zumbrum-Oracle Rank 3 - Community Apprentice

    Since Time is sometimes not stored as a numeric value, I would try something like

    SELECT "Time"."Fiscal Year" FROM "Financials - GL Balance Sheet" WHERE "Time"."Fiscal Year" LIKE ‘20%’;

    Sarah Craynon Zumbrum | Enterprise Cloud Architect

    Public Sector BI/Analytics

    Mobile: +1 919 917 6571

     

  • Ryanj Kocher94
    Ryanj Kocher94 Rank 2 - Community Beginner

    Thank you! The corrected code for my specific problem was:

    SELECT "Time"."Fiscal Year" FROM "Financials - GL Balance Sheet" WHERE "Time"."Fiscal Year" >= '2000';