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

Actaul Forecast problem

Received Response
1
Views
1
Comments
User_3K65B
User_3K65B Rank 1 - Community Starter
edited Aug 13, 2024 5:11PM in Oracle Analytics Cloud and Server

Hi ,I have below columns in my obiee report

Calendar Date , Actual, Forecast

Now i want the required result like - Actual and forecast AUM shouldn't show for the same period. AUM should show from actual if available and it actual isn't available, show forecast. If neither are available show nothing on the same dashboard page .. how to do this in obiee?Plz let me know.reply asap....

regards,

Sony

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    A detail first: "reply asap" in a community forum where users are investing their own personal time and aren't paid to post any reply is considered unpolite, try to avoid it in the future (or hire a consultant and he will be paid to reply "asap").

    Did you try with a CASE WHEN ? It's the IF-ELSE in an OBIEE analysis.