Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Issues when trying to use a Datamodel in different workbooks with different subject areas
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.
Best Answer
-
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:
0
Answers
-
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.
0 -
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.
0 -
Very helpful information.
Thanks for sharing!
0
