1 Reply Latest reply on Mar 8, 2013 2:08 AM by Dhar

    Modeling look table in OBIEE


      I have country wise YTD revenue for the current year in my fact table. I also has a small look-up table that has the below values in 3 columns (Start_value, End_value and Rating)

      Start_value End_value Rating
      0 100K 3 (worst)
      100K 500K 2
      500K 1000K 1
      1000K 0 (Best)

      Now I need to show the Revenue and the Rating in a report.

      For this, I can logically write a case statement to show the rating. But this rating table keeps changing every 3 months.
      So, I want to keep this as a separate lookup table in the database. Could someone please advice how to model this lookup table in RPD?

      Version : OBIEE 10g