5 Replies Latest reply on Jul 21, 2014 12:30 PM by obiee_newbie

    OBIEE 11g - Apply aggregation and Filter on same physical column

    obiee_newbie

      Hi All,

       

      Please suggest a way to achieve the below scenario. Any help will be greatly appreciated.

       

      I have below table data with a single prodcut having more than one manufacturing year. My requirment is to have a year filter in dashboard and also to display the max of year in the report if the product is having more than 1 manufacturing year.

      In the below example,if the user is selecting year 2014 in dashboard prompt then the result should be as in 'result' view whereas 'tab 1' is the source data.

      Note: In actual scenario the data are available in different table for simplicity i have combined data into single view.

       

      tab 1:

       

      Prod_idProd_nbr  year_nbr
      1PR12014
      1PR12013
      1PR12015
      2PR22013
      2PR22014
      3PR32014

       

      Result:

      Prod_idProd_nbr  max year
      1PR12015
      2PR22014
      3PR32014

       

      Thanks,

      Ram