Skip to Content
0
Sep 15, 2023 at 10:41 AM

SAP HANA Redundancy

154 Views

There are bunch of HANA Views which are almost similar as per the business. The ask in hand is to optimize or reduce the HANA View in the present system. I am relatively new to the eco system. I am trying my best to consider the criteria for consolidation. The idea is to retire the redundant HANA views. Tools at my disposal is HANA Studio

Evaluation Criteria :

Complexity of calculation logic, Determine any dependent object modification as a result of consolidation, Dependent Objects, Data Volume and Performance, Data Model Alignment.

Where can i look out in the catalog table to mine the model details, i don't want to do manual mining but try to fetch from catalog table in System schema. Is there a better way to approach. Kindly guide.

Apologies for being verbose.