1 Reply Latest reply on Jun 22, 2016 10:40 AM by Christian Berg

    Obiee Essbase Integration - Time Dimension Issue

    1008490

      Hi All,

       

      I am creating a report Source as Essbase Cubes. Every thing is gone well. when I created a report with Time hierarchy and measure i am getting below error

       

      [nQSError: 42015] Cannot function ship the following expression: AggrExternal(GROSSCON_MEASURE by [ Pp.Gen1,Dim Time, Pp.Gen1,Dim Time - Member Key] ). (HY000).

       

      But when i create the same report with Year column, and measures it is working fine.

       

      Next I change the Hierarchy type from TIME to Ragged Then report is working fine but Time series Measures are not populating.

      Please Suggest. Thanks in Advance