Extend Semantic model sandbox framework-Moving to Prod and semantic model refers to dev schema

Question

Hi, We are facing an issue in PROD after importing and deploying semantic model bundle from Non Prod to prod.

Steps followed so far-

* Create custom schema in Prod ADW.
* Create Custom table, synonym in custom schema. Grant select access to OAX$OAC and OAX_USER.
* Generate and export bundle for the semantic model in Non Prod
* Import and deploy Semantic Model bundle in PROD
* There were no errors in PROD after we validated Semantic model
* We can see the Subject area updated with the fact and Degen Dimension but when we add it to the workbook ,it throws an error that table does not exist.
* Based on the execution logs , the query is checking for DEV_ADW.CUSTOM_ACT.  Hence, it is erroring in PROD as DEV_ADW is not valid schema in PROD. We created custom schema PROD_ADW in Prod

When we create logical star, are we supposed to use custom schema and custom table as we did, or should we be using the seeded schema OAX_USER only?

Could anyone please advise?

Thanks

Veena

JohnW-Oracle · Accepted Answer

Hello @VeenaP,

It seems like you found your own solution with the schema name.

To clarify your earlier asks, if you have used data augmentation, FDI creates synonyms for each table in the OAX_USER schema. Did you use these synonyms in OAX_USER for semantic model extensions?

Have you migrated your data augmentations?

Regards,

John

VeenaP · Accepted Answer

Thanks for your responses.  I was able to resolve the issue by creating a synonym in OAX_USER for the custom schema.customtable and then use the OAX_USER synonym in the semantic model extensions.

We have a requirement to load external source data each month in to FDI so taking this approach.

Thanks,

Veena