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

Pass Presentation Variables to Drill down Reports

Received Response
72
Views
4
Comments
User_TYZ1T
User_TYZ1T Rank 3 - Community Apprentice
edited Aug 13, 2024 5:13PM in Oracle Analytics Cloud and Server

Hi All,

I have a report with a drill down report in a dashboard. I have created a dashboard prompt with 2 variable date prompts(Start date and End date) and few column prompts. When I run the report from the dashboard all the prompt values including variable prompts are getting applied to the main report but when I click on the drill down report only column prompts are getting applied but not variable prompt values.

I am using the below syntax for filters in drill down report:

"Date"."Start Date" <= (@{pv_start_date}{date '2016-01-01'})

"Date"."End Date" >= @{pv_end_date}{date '2016-01-01'} 

Can anyone please help me how can I achieve this.

Note : I am using OBIEE 12.2.1.4.0 version.

Thanks in Advance for the help!!!!

Answers

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

    Are you really talking about a "report"? A "report as in a BI Publisher object?

    Or do you mean an "analysis"?

  • User_TYZ1T
    User_TYZ1T Rank 3 - Community Apprentice

    Thanks for your response.

    I am talking about OBIEE report(Analysis) with drill down report on a dashboard not a BI Publisher object.

    Thanks again for the help!!

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

    "OBIEE report(Analysis)"

    It's either an analysis or a report. An OBIEE report(analysis) is an oxymoron.

  • User_TYZ1T
    User_TYZ1T Rank 3 - Community Apprentice

    Thanks for your response.

    Its report on a dashboard page. Here is my scenario:

    Dashboard prompt with column and date presentation variable prompts.

    Report 1 is on Dashboard page.Report1 has Report2 as Drill down report.

    Column and presentation variable values are passed to Report1 but for Report2 presentation variable values are not passed. Only Column prompt values are passed to Report2.

    Can you please suggest how can I achieve this.