Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Time Series Calculation Functions don't work

Received Response
1
Views
1
Comments
choracy69
choracy69 Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 7:07PM in Oracle Analytics Forum

Hi,

I have question about Times Seriec Calculation and Time Hierarchy.

When I use AGO function, the results not show.

pastedImage_0.png

My formule for AGO is:

AGO("Fact_OM_DATA"."SOLD_HOURS", "TIME"."Dim_XX_W_CZAS_DDim"."Month", 1)

And I don't get any error with bad syntax. Therefore, I think it's a problem my time hierarchy.


My Time Hierarchy look like:

pastedImage_0.png

pastedImage_1.png

I have in each leve check: Chronological Key, for example for year:


pastedImage_2.png

Or month:

pastedImage_3.png

And my Dimension for Time:

pastedImage_0.png

I would add that I use OBIA and original hierarchy running everything correctly, but on their own hierarchy can not see the results.

Does anyone know what the problem might be?

Answers