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

Extend the Explain feature

Needs Votes
31
Views
1
Comments
Joel Acha11111
Joel Acha11111 Rank 5 - Community Champion
in Oracle Analytics Cloud and Server Idea Lab

Description

Currently, users only have the ability to access the Explain feature of a column as seen in the attached image. If the user wants to run the Explain feature for example, for the Year (that OAC has derived from the TIME_ID date), this isn't currently possible.

Use Case and Business Need

Running the Explain at a user-defined level of a column may provide some additional insights to the user.

More details

At the moment, this can only be done at the top level  of the column.

Original Idea Number: f015f0d616

explain I.png

Tagged:
2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    True, Explain is processed as the server level and uses the base dataset. The auto-generated data parts are not part of the actual dataset. In order to run explain on a date part, go to Prepare, right-click on the date column, and choose Extract. Once you apply the script it will become part of the base dataset and you will be able to run Explain against it.