Monday 23 April 2012

Constraining or Cascading Prompts in OBIEE11g

Constraining Prompts in OBIEE11g:

This is one of the features in OBIEE11g which is updated from 10g. In 10g we can constrain the prompts using the constrain check box while creating the prompts but the prompts can be controlled in a particular order only (This is especially so difficult when you create hard coded columns in the prompts). This problem is fixed in 11g.By default all the columns in the same prompt section will be constrained.But if we want to define the relationship explicitly we can follow the following procedure.We can control any column in the prompt section with respect to any of the columns in the same prompt section.Please follow the screenshots




Then edit the properties of the column as shown in the screenshot

Click on more options first then you can see Limit Values by check box.Select the column with whom you want to control this column values as shown in the screenshot.....

One more interesting thing in 11g prompts is we can set a presentation variable for the multi select prompt also unlike in 10g............

Below is the screen shot of constrained prompts in Dashboard
As Region = Asia , Sub Region = Asia and Country Name prompt showing only the Country Names in the Asia.




Thanks,
Nagarjuna
Posted by at

33 comments:

  1. Sara Jones2126 November 2012 at 10:21

    This was very helpful guidance! thanks so much ever. OBIEE Online Training

    ReplyDelete
  2. Me9 April 2013 at 18:05

    Hi,
    I am facing a weird issue with my dashboard prompts. I have prompts coming from different tables so I was expecting to see all the columns when I select "Limit values by", but instead I am seeing selected prompts and not all the prompts. Hence I am not able to restrict the values in my prompts.
    Is it somehow related to the joins between the tables? I am seeing different set of prompts in "Limit values by" option. Not sure on what basis it picks up the prompts. Any help on this.

    ReplyDelete
  3. Unknown30 April 2013 at 21:45

    Appreciation for nice Updates, I found something new and folks can get useful info about BEST obiee ONLINE TRAINING

    ReplyDelete
  4. Teju13 November 2014 at 17:09

    Hi Nagarjuna,

    I have a situation wherein, i have to restrict one parameter say x, based on other parameter say y, but at the same time, the x parameter output should display only values which satisfy a particular condition. Is that possible??

    ReplyDelete
  5. Unknown17 April 2015 at 11:15

    Hi Nagarjuna,

    I have a scenario here and need your help. There are two prompts 'X' and 'Y'. X is dependent on Y and the reverse is also true. So is it possible that when we select a value in prompt 'X', not only the values in prompt 'Y' should be filtered and displayed in drop down,but also should be displayed in the prompt box.

    Regards,
    Sreejith

    ReplyDelete
  6. Venkata Nagarjuna23 April 2015 at 20:32

    Hi Sreejith,

    I am not clear with your requirement. Can you explain me the scenario with the sample set of values in the prompts?

    Thanks,
    Nagarjuna

    ReplyDelete
  7. Meena28 August 2015 at 14:07

    Hi,

    I have a scenario where I want to limit the values of prompt 'X' based on columns 'Y' and 'Z' where 'Y' is not available in dasboard prompts or else where I can include column 'Y' in dashboard prompt and hard code itz value and is there any way where I can hide 'Y' in dashboard?

    My concern is 'x' data should be restricted based on 'Y' and 'z' but 'Y' should not be visible in dashboard.

    ReplyDelete
  8. Venkata Nagarjuna2 September 2015 at 08:46

    Hi Meena,

    with out placing the column Y on the dashboard how can the user select a value in Y to restrict X? We can limit the values of prompts on the dashboard depending on the selection criteria when you dont have the column prompt placed on the dashboard you can not select the value and hence data can not be restricted.

    Please try using Variable Prompt for this scenario.

    Thanks,
    Nagarjuna

    ReplyDelete
  9. Sureshkumar R3 February 2016 at 15:46

    Hi
    I have a scenario where I need to show all the month values in a prompt and in the next prompt the values should be restricted based on last 5 months . Eg : If I select 2015-05 , then the next prompt should display values satisfying the condition from 2015-01 to 2015-05.How to achieve this?

    ReplyDelete
  10. Venkata Nagarjuna5 February 2016 at 21:12

    Hi Suresh,

    It is difficult to explain in detail so i will give you an idea to achieve your requirement. As there is no condition required on the first prompt,create one presentation variable and just keep it as it is. for the second prompt you need to write the sql based on the presentation variable created in the first prompt and add between condition as Month Column between (presentation variable-4) and (presentation variable)

    Thanks,
    Nagarjuna

    ReplyDelete
    Replies
    1. Sureshkumar R10 February 2016 at 15:09

      Hi Nagarjuna

      Thanks for the reply. But the challenge is how to use a presentation variable in a select query in prompt

      Delete
  11. Sureshkumar R10 February 2016 at 15:11

    Hi Nagarjuna

    Thanks for the reply. But the challenge is how to use a presentation variable in a select query in prompt

    ReplyDelete
  12. Unknown23 February 2016 at 12:24

    Hi Nagarjuna,
    I am facing an issue in cascading prompts. There are 4 prompts A,B,C,D... Now all of them should be co dependent For eg selecting a value in prompt A should restrict values in B,C,D and henceforth. Now columns for prompts A,B,C are a part of hierarchy and D is not.
    For some reason D is not getting restricted by values selected in other prompts. Is not being a part of hierarchy a reason for that ?

    ReplyDelete
    Replies
    1. Venkata Nagarjuna24 February 2016 at 08:07

      Hi Sreejith,

      To constrain the prompts it not necessary that all the columns should be part of hierarchy. If those tables have the relationship then the constrain will work. Constraining will not work if those tables are not joined properly.

      Thanks,
      Nagarjuna

      Delete
  13. Anonymous19 April 2016 at 22:49

    Hi Nagarjuna,

    Is there a way to use the value of a constraint list as the default value?

    I have a prompt that has 2 column (start date,end date). I want the 2nd column to be dépendent on the first, so if i choose May 1st,2016 in the start date column, the end date column as a default value of May 31st,2016.

    Thanks in advance,

    Serge

    ReplyDelete
  14. Venkata Nagarjuna20 April 2016 at 00:50

    Hi Servoy,

    We dont have such option in obiee right now. We can only do constraining of columns but can not store or pass the selected value as constraint to other prompts. Hope we will have this option in the next release.

    Thanks,
    Nagarjuna

    ReplyDelete
  15. raj6 April 2017 at 09:36

    What are other options available to solve this?

    ReplyDelete
    Replies
    1. Venkata Nagarjuna6 April 2017 at 21:12

      Hi Raj,

      Can you elaborate your requirement, i am not sure what you are looking for.

      Thanks,
      Nagarjuna

      Delete
  16. Rajesh Reddy2 June 2017 at 20:29

    Hi Sir,
    I was trained by you ( Hyderabad ), good to see you.

    ReplyDelete
    Replies
    1. Venkata Nagarjuna2 June 2017 at 23:00

      Hi Rajesh,

      Good to see you comment here. Hope you are doing well. Thanks for leaving comment.

      Thanks,
      Nagarjuna

      Delete
  17. Mamta kumari31 July 2017 at 10:56

    When user is using BI Analytics, upon clicking ‘Analyze’ at the bottom of the result page of a report, the screen does not go to the usual edit page that we usually see.

    Please advice
    Thanks,
    Mamta

    ReplyDelete
    Replies
    1. Venkata Nagarjuna31 July 2017 at 21:23

      Hi Mamta,

      Analyze option is different from Edit. Analyze will preserve the prompt default values on the dashboard where as Edit will not but both the links takes you to the Criteria or Results tab depends on your default personal settings.

      Thanks,
      Nagarjuna

      Delete
    2. Mamta kumari7 August 2017 at 12:06

      Thanks for the reply

      Delete
  18. Mamta kumari7 August 2017 at 12:10

    This comment has been removed by the author.

    ReplyDelete
  19. Unknown22 August 2017 at 14:30

    Hi Nagarjuna

    In BI report from where the operating units are getting populating.Is it prebuilt or coming from sql query from EBS?
    Please advice

    ReplyDelete
    Replies
    1. Venkata Nagarjuna22 August 2017 at 19:42

      Hi Mamata,

      Which BI Report you are referring to? Please share more details.

      Thanks,
      Nagarjuna

      Delete
    2. Unknown23 August 2017 at 10:36

      In OBIEE analytics when I am opening a report then there is a option for operating unit.so i want to know from where these operating unit field are coming as options?

      Delete
  20. Unknown23 August 2017 at 15:52

    This comment has been removed by the author.

    ReplyDelete
  21. safeelyazar20 September 2017 at 21:52

    Is there a way to control the default selection of a prompt based on another prompt.

    Example; Prompt A (single select) has values - Yes (default), No
    Prompt B (Multi Select) has Values - (All Column Values), 1, 2, 3

    When Prompt A is selected as Yes, then Prompt B's default selection should be 1 and 3

    When Prompt A is selected as No, then Prompt B should check (All Column Values).

    I tried using SQL results but the prompt B default values are not refreshing back from 1 and 3 to (All Column Values)

    ReplyDelete
  22. Venkata Nagarjuna22 September 2017 at 19:11

    Hi Safeelyazar,
    I am not very sure about this functionality but i think the feature you are looking for is not available in Obiee as of today.
    Thanks,
    Nagarjuna

    ReplyDelete
  23. Unknown23 January 2019 at 17:37

    Thanks this is very helpful tips

    ReplyDelete

Subscribe to: Post Comments (Atom)