Oracle Analytics Cloud and Server

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

OAC Data Action not working if Achor to calculated measure Columns

Accepted answer
35
Views
2
Comments

Hi,

My requirement is to use data action to drill down to detail report by using Anchor to few calculated measures in summary workbook.

But the link itself is missing if I 'anchor to' on multiple calculated measures. However it is working as expected only if it is Anchor to on one calculated measure.

I saw there is a document in oracle support it says it works on calculated measures , but I am not sure if it works for more than one measure.

https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=456411144416797&_afrWindowMode=0&id=2671512.1&_adf.ctrl-state=bxnfqkysh_4

Thanks in adance.

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hi @kusuma l -Oracle

    The KM article you are referring to is specific to circumstances where columns were removed from the project and this left stale pointers. The solution to that is:

    • 1. Copy Visualization to new project resolved the stale pointers to columns
    • 2. Retest " Anchor to" functionality.
    • 3. Or Try Re-creating the project.
    • If you have the same scenario where a calculated column was removed, this solution should help.
    • If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier.
    • Regards,
    • John

Answers