Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Error in creating a trendline - OBIEE 12c

Received Response
11
Views
1
Comments
User_BCACP
User_BCACP Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

Hello,

I have a problem with TRENDLINE in OBIEE 12c.

I am trying to use a formula like this:

TRENDLINE(100 - ((IFNULL(Sum(DISTINCT "XX"),0) / ("YY"*24.0)) * 100.0), ("TIME"."DAY_DATE"), 'LINEAR','VALUE')

"XX" - type: double

"YY" - type: double

"TIME"."DAY_DATE" - type: date

I get this error:

State: HY000. Code: 42071. [nQSError: 42071] Trendline Y-axis grain can only be the same as or lower than Trendline X-axis grain. (HY000)

What I am doing wrong?

Best Regards

Tagged:

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist

    @User_BCACP - The error message indicates that the Y-axis grain (the data level used for the calculated values) must be at the same or a lower level than the X-axis grain (in this case, "TIME"."DAY_DATE").

    • The X-axis is based on "TIME"."DAY_DATE" (which is at a daily grain).
    • The Y-axis formula references "XX" and "YY" without explicitly ensuring they are also at the daily level.

    Make sure "XX" and "YY" are aggregated at the daily level before being used in the formula.
    Hope this helps!