Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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

Semantic Model: Refresh OAC physical table structure

Accepted answer
62
Views
4
Comments
AM HRE
AM HRE Rank 4 - Community Specialist
edited Dec 11, 2024 5:01PM in Oracle Analytics Forum

Hi community,

let's suppose that I have made many changes to a DB table (new columns, changes to column dimensions, name changes, etc.) and I don't want to manually apply these changes to the physical OAC table. Is there any way to automatically refresh the physical table structure to reflect the changes that occurred on the db?

Thanks in advance for your support.

Tagged:

Best Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    Hi,

    You mean in the Semantic Modeler? (you mentioned a "physical" table)

    Not really …

    But you can import it again in a different part of your model, or even a new model, copy the code definition (the JSON), replace it in your current model.

    Or, because it's just a piece of JSON defining your table, you can generate the new JSON from your database directly with a query and past it into your model definition replacing the existing one.

    Of course if you renamed columns and some used columns changed name, your model will break and you will need to remap things as needed.

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    Just as reference in case somebody else open this thread and it isn't directly obvious what I meant by "editing the JSON": right click an object in the semantic modeler > Open in SMML Editor.

    image.png

    And from there it's just a simple JSON that can be quickly edited (faster then the GUI sometime).

    image.png

Answers