Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Time series measure turning into an attribute in Union Analysis

Received Response
71
Views
10
Comments
Saro
Saro Rank 5 - Community Champion
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

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

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    What is the aggregation rule in both criteria?

  • Saro
    Saro Rank 5 - Community Champion

    Hi Asim,

    In my formula ifnull(TODATE("Fact_GL_balances"."Revopex BI Forecast", "Dim2_GL_periods"."2-Time"."Year"),0), i have my Forecast column with an aggregation rule of sum in both criteria.

    Regards,

    Saro

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Icons are changed in 12c for measures and non measures. is it not aggregating properly. Each criteria?

    pastedImage_0.png

  • Saro
    Saro Rank 5 - Community Champion

    Hi Asim,

    Yes it is not aggregating properly in the union analysis. This is happening only for the time series measures(That too in the union analysis). But for the measure without any time series formula it is working fine. What could be the issue with the time series measure in the union analysis.

    Regards,

    Saro

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Can you push the logic for YTD into the rpd and try it?

  • Saro
    Saro Rank 5 - Community Champion

    Hi Robert,

    I tried that also, but it results in the same way of behaving like an attribute.

    Regards,

    Saro

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Have you looked at the physical sql to see what is happening there?

    Is your answers presentation table, as opposed to pivot, where there can be extra logic applied over and above the 'base logic'?

  • Saro
    Saro Rank 5 - Community Champion

    Hi Robert,

    The problem is because of wrong formation of time series calculation. After correcting the time dimension with the proper chronological key, the measures are appeared fine.

    Thanks,

    Regards,

    Saro

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    So often the keys are the answer when you get 'strange' behaviour....

  • Saro
    Saro Rank 5 - Community Champion

    w.r.t to time series for its abnormal behaviour, the wrong formation of chronological key is the main reason in my case.

    Regards,

    Saro