Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
RPD Errors - "is not associated with any table(s)."
Hi All,
I need to fix two RPD errors, as part of an upgrade we are doing. I found the specific errors in the upgrade logs and was able to trace them back to one of the RPD's it was patching/merging.
Business Model Core:
[38120] Dimension '"Core"."SIA Instructor Snapshot"' is not associated with any table(s).
[38120] Dimension '"Core"."SIA Scholar Snapshot"' is not associated with any table(s).
I haven't been able to find very much information on this type of stuff (one Ateam article, and one community discussion). Does anyone have any suggestions? Realistically, we don't even need these objects for anything. Not sure if it is simpler to "drop" them ... or fix them.
Thanks in advance!
OBIEE 11.1.1.9.3 - Bi Apps 11.1.1.10.1
Regards,
Charles
Answers
-
"If you can read this screenshot, you have an electron microscope as eyes" :-)
Is there really no table attached to the LTS of the dimensions?
0 -
Sorry. Good catch ...
0 -
Also, found these:
0 -
The fact that this is greyed out is pretty much a dead giveaway.
0 -
In my "random" RPD I have a table associated:
Do you have these 2 tables? Maybe you "just" need to associate them again (not sure why it wasn't the case already)
0 -
That's my point. No tables = no work-y
0 -
Thanks Gianni. Hmm ... I am not seeing them:
Bi Apps strikes again! I'm forseeing another SR in my future ...
0 -
What you are looking now seem to be "physical tables", while the dimension link to a logical table (with spaces in names instead of '_').
You really don't have them in your 'Core' business model (in the middle of those hundreds of things)?
0 -
The dimension maps to a logical table, not a physical one.
0 -
Ok, I see. You are correct, I was looking in the physical layer.
I can see these objects in the BMM
0
