1 Reply Latest reply: Sep 2, 2013 9:05 AM by Christian Berg RSS

    OBIEE 11g Ago Function

    1010049

      Hi All,

       

      I am using ago function in Answers it works fine

       

      But

      when observing the data, data is mismatched at particular Product category, why because two category s (A,B)   has same subcategory name (Basic)

      CAT       Sub Cat

      A  ------        Basic

      A  ------       Value Add

      A  ------       High

      B -------     Basic

      B ------       low

      B ------     medium

       

      My report has five columns like CM -1 , CM-2,CM-3,CM-4,CM-5 ,

      when i was selecting cat A and subcat is Basic, Data as below ....

      CM-1         CM-2     CM-3     CM -4    CM -5

      A basic   A basic  B basic B basic   A basic

       

       

      if sub cat name is different no issue

       

      Please help me.


      Regards

      Rm