2 Replies Latest reply on Aug 24, 2018 9:30 AM by choracy69

    NULL values in graph (running sum)

    choracy69

      i,

       

      I have problem in OBIEE 11.1.1.7 with area graph.

       

      I have on graph: YEAR, TYPE of ENERGY and POWER, I created graph on pivot table: in rows i have years // columns is type of energy // measures: power

      I have NULL values for some year and type energy - NULLvalues it's mean that table don't have record.

       

       

       

      I can't use IFNULL() because table don't have record for example for 2006 for water (BLUE COLOR).

       

      What I want to see: If 2006 Year don't have record for WATER I want see value from 2005 - display running sum it's warking fine but no with NULL.

       

       

       

      My aim is: don't see blank record in table and blank place in graph.

      What can I do?

      Can I do something only in OBIEE or Admin Tool (rpd)?

      Or must I write VIEW base on this table?

       

      Thanks for any help.

       

      PS. At now I can't customize source table with this data.