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

"Combine with similar request" in OBIEE11g ......

1) Go to Criteria tab of the first Subject Area  and add the columns and click on the combine results option as shown in the below screenshot

2) Now select the other subject area to combine the first request  as shown in the screenshot

3) Now you can see the following screenshot with the options UNION,UNIONALL,INTERSECTION,MINUS (same as 10g).

4) Do the same process that we are doing in 10g.........

No Results View in OBIEE11g .......

1) Go to Criteria tab and add the required columns and select the option "Edit Analysis Properties" as shown in the below screenshot

2) You can see a new window now as shown in the below screenshot and select the option "Display Custom Message"

3) Now you can see the Header and the Message boxes are enabled. Type your custom message and save it .