1 Reply Latest reply on Aug 17, 2015 11:00 AM by Sudha777

    How to give group by for a single column in OBIEE 11g

    Sudha777

      Hi,

       

      I have a pivot table , where I have dimensions like Desc, date and 1 fact columns.(OBIEE version 11117)

      I need the data to be placed in the format, date wise fact for 2 months and total of first month fact

                                                                      

      01-Jan-1502-Jan-1531-Jan-1501-Feb-1502-Feb-1528-Feb-15
      till date Total of Jan
      A36123456
      B917368163
      C918459153
      D1319586210

       

      Where Date is parameter, Till Date = 2nd Jan 15, (Report running date in parameter).

      I create time dimension , where in for AGO function if I take Year then it is working but if I take month or date it is not working.

      [nQSError: 27037] Unresolved level: "D0 Time"."H0 Time"."month_mon". (HY000)

       

      Request your Suggestions or help