Dynamic Filter

Hi friends , Today I'm showing you very interesting dynamic filter where we can change out filter parameter dynamically.

Step1:  Create a "Variable Prompt" type dashboard prompt and give the prompt name,some static values(here is "One' and "Two")

Step 2: 

Select filter for Product type

Edit the filter formula and click OK.

case when '@{filtervariable}'='One' then "Products"."P2  Product Type" end

Add Filter value and OK.

Add the prompt and Report in your Dashboard-

Run the report and Enjoy-

Aggregate at

• The usage of Aggregate at Function in OBIEE 11g

Step 1: Include the Revenue column

Step 2: Apply the Aggregate at  function on revenue column

Step 3: Fill up the function parameter

or you can do multiple levels from different Hierarchies.