10 Replies Latest reply on Nov 1, 2017 4:41 AM by Saro

    Time series measure turning into an attribute in Union Analysis

    Saro

      Hi friends,

       

      Im in obiee 11.1.1.7.150120

       

      When i create a YTD for my measure column named Forecast with below formula, i can see the aggregation(yellow mark) appears to it like below

      ifnull(TODATE("Fact_GL_balances"."Revopex BI Forecast", "Dim2_GL_periods"."2-Time"."Year"),0)

       

      Agg1.PNG

       

      Suppose if i do the union analysis for my same measure column Forecast like below, it is turning into an attribute column(no yellow mark) and not behaving like a measure column

       

      Agg2.PNG

       

      What could be the reason for the time series measure not appearing as a measure columns in the union analysis.

      Is this expected behaviour and is there any soln for this problem.

       

      Thanks in advance.

       

      Regards,

      Saro