nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Issues when trying to use a Datamodel in different workbooks with different subject areas

Usha Athimakula

When trying to use a Datamodel in different workbooks with different subject areas, an existing join is being removed. A warning appears - There is an existing match that will be removed if you proceed, which will break any workbooks using it. Do you want to proceed? As a workaround, I am duplicating the datamodel and using it. But this is not sustainable in long run, as any changes to be made to the datamodel must be made in all the duplicates. Is this a bug or this is the way the product works? Ideally datamodels must be reusable, right? Please share any insights on this issue. Thank You.

Find more posts tagged with

Data Models

OAC

Accepted answers

Usha Athimakula

No, we are not copying and pasting. We are just reusing a data model in multiple workbooks to extend a dimension. Looks like that's the behavior. I recently came across an Oracle support article which is also suggesting the workaround we are using. i.e., duplicating the data models to use with different workbooks/different subject areas. Here is the link:

Document 2907849.1

All comments

Syamantak Saha

If Copy-Pasting objects across workbooks may cause this issue, as when you copy you actually inherit a large amount of attributes that may not be available in the new workbook. Re-using datamodels across workbooks may require consistent environments.

Usha Athimakula

Document 2907849.1

Syamantak Saha

Seems like the different Subject Areas have different semantic layer models causing it to drop joins. Check for differences between Subject Areas prior to attempting to use your datamodel.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/work-subject-areas.html#GUID-2D856E6B-2C6D-4674-961A-8802870C8564

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70525#Comment_70525

Very helpful information.

Thanks for sharing!