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

    Time series measure turning into an attribute in Union Analysis


      Hi friends,


      Im in obiee


      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)




      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




      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.