Oracle Analytics Cloud and Server Idea Lab

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
25
Views
2
Comments
Ancy Paul-Oracle
Ancy Paul-Oracle Rank 5 - Community Champion

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
7
7 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.