Categories
- All Categories
- 147 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Semantic Model: Refresh OAC physical table structure
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.
Best Answers
-
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.
0 -
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.
And from there it's just a simple JSON that can be quickly edited (faster then the GUI sometime).
0
Answers
-
Hi Gianni,
I'm sorry.. yes, I'm talking about the semantic modeler.
Thanks for the reply, I'll try right away!
0 -
Thank you very much
0