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

Timestampadd function invokes default parameter value rather than presentation variable value

Received Response
32
Views
10
Comments
3713479
3713479 Rank 4 - Community Specialist
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

I previously was notified that I am using an obsolete version of OBIEE(11.1.1.7).  The request to upgrade to 12C was submitted.

In the interim, may I ask for ideas on why the filter shown below is executed with the default value in the argument list(2010-11-11) rather than the presentation variable default  defined in the catalog object( 2019-04-01).

The presentation variable is populated with the 2019-04-01 value and appears in the dashboard page, but that value is not used in the query.

"CCRS Activity Monthly"."Activity Date" > TIMESTAMPADD( SQL_TSI_MONTH, -6,@{PV-START}{DATE'2010-11-11'})

Thanks for any insights...

Answers

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello,

    Do you have the priviledges to see the queries? Can you please check the value generated/assigned in the Manage Session section for "PV-START"?

    Also, please share the screens of the FILETR condition and the location where you have defined the Presentation Variable.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you checked the Session Manager in your Admin Tool: Manage > Sessions where you can see the value of all variables per user logged on?

  • 3713479
    3713479 Rank 4 - Community Specialist

    Thanks for the feedback.

    I am waiting for the DBA to respond regarding access to the Admin tool

    I included the window where the presentation variable is defined and the filter window.

    pastedImage_2.png

    Activity begins with M910imageimageimageimage
    AND

    image "CCRS Activity Monthly"."Activity Date" > TIMESTAMPADD(SQL_TSI_MONTH, -6, @{PV-START}{DATE'2010-11-11'})

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    You need to name your presentation variable in the bottom box, where you currently have "2019-04-01".  It should say "PV-START"

  • Gianni Ceresa
    Gianni Ceresa Mod

    What Jerry said !

    Right now you never assign a value to your variable, therefore the default value is always used.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Yeah. Name is not the value. Value is not the name. With the above the variable's NAME is "2019-04-01"

  • 3713479
    3713479 Rank 4 - Community Specialist

    Thanks for the quick responses...

    Note that I was using the correct syntax in troubleshooting this, but when I was embedding the screen capture of the dialog, I inadvertently typed the date value rather than the variable name.

    Therefore, the problem I am reporting is still an issue for me.

    I am including the correct screen capture of the dialog as I used in testing.

    Note that the following syntax invokes the value of the presentation variable as intended, but NOT when used in conjunction with the TIMESTAMPADD function.  I need the functionality of the TIMESTAMPADD to adjust the date range as required for different analysis steps.

    Activity Date is greater than  @{PV-START}{%}

    pastedImage_6.png

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    This syntax works for me:

    pastedImage_0.png

    pastedImage_3.png

    You might try this alternative syntax and see if it makes any difference:

    pastedImage_4.png

    They both work for me, but I have had instances in the past where I had to use the latter.

    Beyond that, I can't see what the problem is with the information provided.

  • 3713479
    3713479 Rank 4 - Community Specialist

    Jerry

    Thank you for your input !!!

    The alternative syntax you suggested that precedes the presentation variable name with the keywords "dashboard.variables" is working !

    I am grateful for your insights !

    Jim

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Also, Is your date a "DATE" or a "TIMESTAMP"?

    This will also have some impact when accessing the presentation variable.