Oracle Analytics Cloud and Server Idea Lab

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

OAC: Ago Function In DV Fails With nQSError: 27037 "Unresolved level" ( Doc ID 2585569.1)

Under Review
178
Views
3
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle Digiral Prime

Description (Required):

Ago Function In DV Fails ( I cannot drag time level in the hierachy to the calculation area)

Use Case and Business Need (Required):

Major customer want to use semantic model with time hierachy. and mainly want to use the ago function with it but failed

Enhancement Request / Service Request:

I think after semantic modeler (preeview) , there would be more needs to use ago function in DV.

please solve this issue ASAP

(I already raised a SR about this but guided to use this idealab)

7
7 votes

Under Oracle Review · Last Updated

Comments

  • Jahnavi-Oracle
    Jahnavi-Oracle Rank 6 - Analytics Lead

    Agreed, voting up. There is a specific format we use currently to make it work, but that is not user friendly.

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Current option is not easy to use. It would be a useful addition.

  • Nina Asenbauer
    Nina Asenbauer Rank 4 - Community Specialist

    One workaround I've found (not sure if this works for AGO): do a calculated column in DV classic analysis and copy the code. This usually resolves correctly.