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

Need a mechanism to identify table/calculation dependency in workbook to safely delete unused ones

Needs Votes
52
Views
6
Comments
Ancy Paul-Oracle
Ancy Paul-Oracle Rank 5 - Community Champion
edited Sep 26, 2025 7:06AM in Oracle Analytics Cloud and Server Idea Lab

We need to establish a way to clearly identify both the table and the associated calculation reference. Its highly possible to have a change in table structure which will break the dashboard and its associated calculations. Need a method/ability to see the calc references, so that we can easily delete/change the calcs without the fear of breaking any viz. This helps in data preparation .

Same applies in data set. If a complex data model includes 12 tables, and there is a situation to delete/replace table, currently workbook will fail. we dont have any method to identify the dependency.
Example:
I create a calculation "programs" . Later we change the logic how this is being calculated and another team member create a new calculation Programs#. Now Programs is obsolete. But to identify where and all this is being used, there is no way.

image.png
Tagged:
11
Up
11 votes

Needs Votes · Last Updated

Comments

  • Ancy Paul-Oracle
    Ancy Paul-Oracle Rank 5 - Community Champion

    We have requested for this and exactly same happened . Currently when you delete a table, associated calculations are not getting deleted with July 2025 release and your entire calculations won't load
    It keeps on loading and never load

    image.png
  • Ambili
    Ambili Rank 6 - Analytics Lead

    Definitely a valuable enhancement to add.

  • R Stonaker
    R Stonaker Rank 6 - Analytics Lead

    Definitely needed, will make maintaining workbooks much easier and cleaner.

  • Brendan T
    Brendan T Rank 6 - Analytics Lead

    I like this idea suggestion and it would be helpful

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Great idea; it'll be a very useful feature to have. Upvoted.

  • philipgodfrey
    philipgodfrey Rank 6 - Analytics Lead

    @Ancy Paul-Oracle really like this suggestion, it would certainly aid development. It could be a simple solution such as adding bold formatting applied to a calculation that is in use on the canvas. This would make it much easier to remove un-used calculations.