<p>OAC: Ago Function In DV Fails With nQSError: 27037 "Unresolved level" ( <a target="_blank" class="oracl-km-link" href="https://support.oracle.com/rs?type=doc&amp;id=2585569.1">Doc ID 2585569.1</a>) — Oracle Analytics</p>

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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
173
Views
3
Comments
JasonJang-Oracle
JasonJang-Oracle Rank 5 - Community Champion
in Oracle Analytics Cloud and Server Idea Lab

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)

Tagged:
8
Up
8 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.