Oracle Analytics Cloud and Server

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

OBIEE 12c Report Slider Prompt issue

Received Response
22
Views
9
Comments
3030927
3030927 Rank 3 - Community Apprentice

Hi All,

I have a slider prompt in summary Report and when I change any values in the slider and click on the measure to detail report I have an issue. Detail report is not filtering based on the selection on slider values.

Thanks

Krishna

Answers

  • Hi,

    You will have to give a bit more ...

    What value is your detail report filtered if not the one of the slider?

    Is the column of the slider there and set as a filter?

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

    Are you talking about master detail linking?

    OBIEE 11G - Master Detail [Gerardnico]

    I just build an example in SampleApp (12.2.1.0) and even there it works perfectly fine. It's all about the channel...

  • 3030927
    3030927 Rank 3 - Community Apprentice

    Its not about the master detail linking.

    Lets me explain you more.

    I have graph report as summary and made payment status column as slider in Graph. User can move the slider as he can see values of payment status column.--Report 1

    I have a detail report with all the details related to the graph. ----Report 2

    I have given a action link from report1 to report2.

    When user clicks on the chart it navigates to the detail report. Perfectly working.

    Issue: when I move the values(payment status from paid to unpaid) of the slider and click on the graph to navigate detail report. The detail report is not filtering with payment status unpaid. Every time it is showing paid in the filters.

    Hope u understand.

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

    Maybe you're just using a protected filter in the target analysis? Or you're jumping Subject Areas or your columns don't actually match so the promtped values don't get passed down.

  • 3030927
    3030927 Rank 3 - Community Apprentice

    My Oracle Business Intelligence Product Version 12.2.1.0.0 (Build BIPS-20151008013645 64-bit)

  • 3030927
    3030927 Rank 3 - Community Apprentice

    Hi All,

    The below is attachments for my issue.

    Summary 1.PNG

    I moved the slider prompt from Accessories to Plasma.

    Summary 2.PNG

    I clicked on Plasma HD television. The detail report is not filtered with the value I selected.

  • 3030927
    3030927 Rank 3 - Community Apprentice

    The detail report is above.Detail 1.PNG

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you provide the column formula of the Product fcolumn  both master and detail reports. Could you also send a screenshot of the filter criteria in your detail report?

  • 3030927
    3030927 Rank 3 - Community Apprentice

    I tried the same scenario. It worked in 11g and its bug in 12c. Will raise SR to Oracle.