Have to one dashboard prompt data with another dashboard prompt — Oracle Analytics

Oracle Business Intelligence Applications

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

Have to one dashboard prompt data with another dashboard prompt

Received Response
122
Views
8
Comments

HI

I am using OBIEE 11.1.1.9.0

I have a dashboard prompt with two columns(year and name). For this prompt i have also used section condition.

BUt now i have reuirement as when i select year, i should be getting names under Name Prompt which are only related to that particular year. But as of now by defualt i am getting all names under name format.

How can i restrict values at prompt.

Example

Year             NAme

2016              JAck

                       Jill

2017              Humpty

                       Dumpty

                         JAck

BY default we will be getting all data under year and name when we use as prompts, what ever we have to filter we can apply them and view report at dashboard

But i need is when i select 2016 in prompt and check Name prompt i should see onlr Jack and Jill from these two names only i have to apply filter.


Can anyone please suggest

Thanks in advance

Answers

  • Hi,

    You just need to check the checkbox "Limit values by" in the options of your prompt for name.

    To make it work fine if the 2 columns aren't coming from the same logical table you must define the "Implicit Fact Column" in the RPD for that subject area. When querying dimensional attributes only the filter will be done based on that fact (because a fact it's the only way to "link" 2 different dimensions together).

    Capture.PNG

  • Jack
    Jack Rank 4 - Community Specialist

    Thank You it worked

  • Good to hear

    So can you maybe close the thread and mark answers as required? It will help others looking for the same and for now it's still This question is Not Answered.

  • Jack
    Jack Rank 4 - Community Specialist

    sure

    But how to close, i dont see any close link here

  • Based on https://community.oracle.com/docs/DOC-891037#jive_content_id_1322_Helpful_and_Correct_  you must have a button to mark an answer as correct and this will also flag the thread as solved/answered.

  • Jack
    Jack Rank 4 - Community Specialist

    hi

    I Have year from one dimension and name column from another dimension. When i am trying to use limit values, name column is giving odbc error as table does not exist.

    Can i get values in prompt, since this two columns are from two dimensions.

    How can i create implict column , i have 4 fact tables in this subject area

    can you please help

  • Jack
    Jack Rank 4 - Community Specialist

    i report i use columns from dimensions and 2 fact tables too

  • The "Implicit Fact Column" is defined by opening the properties of the subject area in the RPD.

    As said only one column can be defined as implicit per subject area. So you must manage to identify a measure being the most generic as possible.