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

OBIEE12C Limit by Not working

Received Response
12
Views
12
Comments
ferdous
ferdous Rank 2 - Community Beginner
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

In OBIEE 12c "limit by" option in dashboard prompt is not working in Internet Explorer 11. Any bug fixes/ solution for this?

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Works perfectly fine in IE11 on a 12.2.1.1.0 system (tested right now).

    So can you maybe be a bit more explicit on what you did and how did you analyzed the case to make sure it's not working because of a bug and not a data issue or something like that?

  • ferdous
    ferdous Rank 2 - Community Beginner

    Ok, I should have elaborated my real scenario. Let's say I have two drop down in dashboard prompt, for first drop down we've used Descriptor ID / double column and the second drop down is limited by the first one. So usual scenario would be like if I select specific item in first drop down then it would affect the second drop down. Usually it works when I do not use Descriptor ID / double column. But it doesn't work for double column. Do you have any idea about this? Thanks in advance.

  • nm.Mani
    nm.Mani Rank 6 - Analytics Lead

    Hi there,

    It is definitely working in IE and in chrome. Just make sure that you have checked Limit Values by All Prompts in Dashboard Prompt as shown below,

    pastedImage_0.png

    Thanks

    MM

  • ferdous
    ferdous Rank 2 - Community Beginner

    Thanks for your interest. I have described my scenario in my previous comment and it doesn't work if I select all prompts or some selective column.

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    So now the topic suddenly changed from "Not Working in IE11" to "Not Working with double columns"?

    Are you filtering two columns coming from the same dimension (e.g. Region and City) or from two different dimension (e.g. City and Product)?

    If the latter, are you sure that in your Fact table there is no row matching the City and Product selected?

  • ferdous
    ferdous Rank 2 - Community Beginner

    yes. dimension were different and there was matching row for these two dimensions.

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    have you checked if "Filtered by code" is checked?

    If so can you try uncheck? what is the behaviour?

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    filter by code column can be found in the prompt options

    2017-01-24_12-15-59.png

  • ferdous
    ferdous Rank 2 - Community Beginner

    yes I've done this in my local environment. No effect in IE 11. Here is the link for obiee sample app v511 (http://www.oracle.com/technetwork/middleware/bi-foundation/sampleapp-3118326.html) where you can deploy my given catalog (https://drive.google.com/file/d/0BwdOKeHblYCkWm5JaXhKY3BnYUk/view?usp=sharing) in Shared folder. This analysis has been done in obiee's sample rpd. Please have a look

  • ferdous
    ferdous Rank 2 - Community Beginner

    Thanks everyone for all your effort. I have discussed this issue with oracle service. This is oracle bug for OBIEE version 12c( 12.2.1.0.0). This issue has been fixed in OBIEE version 12c( 12.2.1.1.0)