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

How to constrain fiscal period based on fiscal year in BI 11g prompts?

Received Response
4
Views
3
Comments
3136676
3136676 Rank 1 - Community Starter
edited Aug 13, 2024 7:03PM in Oracle Analytics Cloud and Server

Hi ,

i am working on OBIEE 11g  . I have requirement to constrain fiscal period based on fiscal year . i was able to constrain all the fiscal year based on previous prompts because those were on different presentation tables but fiscal year and fiscal period are on same presentation table .

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Can't you just enable "Limit values by" and let OBIEE care about it? If the both come from the same table (you say presentation but I guess it's also the same logical table) OBIEE will filter the list of fiscal periods based on the value selected in the fiscal year prompt.

    Capture.PNG

  • 3136676
    3136676 Rank 1 - Community Starter

    I tried that it filters fiscal period only until current fiscal year. i want fiscal period to be displayed for which there is data . Like if FY 2014 and Fiscal Period : 1 doesn't have data i don't want to display that fiscal period in my prompt.

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics & AI Lead

    Use SQL for that prompt to include specific metric in where clause like

    select fiscalPeriod from TimeDim WHERE Metric>0