1 2 Previous Next 20 Replies Latest reply on Oct 25, 2018 4:12 PM by Charles M

RPD Errors - "is not associated with any table(s)."

Charles M Oct 23, 2018 7:59 PM

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

1. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 23, 2018 8:14 PM (in response to Charles M)

"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?
Like Show 0 Likes(0)

Actions
2. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 23, 2018 8:22 PM (in response to Christian Berg)

Sorry. Good catch ...
Like Show 0 Likes(0)

Actions
3. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 23, 2018 8:27 PM (in response to Charles M)

Also, found these:
Like Show 0 Likes(0)

Actions
4. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 23, 2018 8:27 PM (in response to Charles M)

The fact that this is greyed out is pretty much a dead giveaway.

1 person found this helpful
Like Show 0 Likes(0)

Actions
5. Re: RPD Errors - "is not associated with any table(s)."

Gianni Ceresa Oct 23, 2018 8:42 PM (in response to Charles M)

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)
Like Show 0 Likes(0)

Actions
6. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 23, 2018 8:46 PM (in response to Gianni Ceresa)

That's my point. No tables = no work-y
Like Show 0 Likes(0)

Actions
7. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 23, 2018 8:52 PM (in response to Gianni Ceresa)

Thanks Gianni. Hmm ... I am not seeing them:

Bi Apps strikes again! I'm forseeing another SR in my future ...
Like Show 0 Likes(0)

Actions
8. Re: RPD Errors - "is not associated with any table(s)."

Gianni Ceresa Oct 23, 2018 8:56 PM (in response to Charles M)

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)?
1 person found this helpful
Like Show 0 Likes(0)

Actions
9. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 23, 2018 9:05 PM (in response to Charles M)

The dimension maps to a logical table, not a physical one.
1 person found this helpful
Like Show 0 Likes(0)

Actions
10. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 23, 2018 9:08 PM (in response to Gianni Ceresa)

Ok, I see. You are correct, I was looking in the physical layer.

I can see these objects in the BMM
Like Show 0 Likes(0)

Actions
11. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 23, 2018 9:09 PM (in response to Charles M)

So map them :-)
Like Show 0 Likes(0)

Actions
12. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 24, 2018 2:40 PM (in response to Christian Berg)

Thanks Christian. Is that a "drag & drop"?

I'm trying to find the instructions for it ...

Charles
Like Show 0 Likes(0)

Actions
13. Re: RPD Errors - "is not associated with any table(s)."

Christian Berg Oct 24, 2018 3:30 PM (in response to Charles M)

Yes, drag & drop the appropriate attribute columns to the dimension
1 person found this helpful
Like Show 0 Likes(0)

Actions
14. Re: RPD Errors - "is not associated with any table(s)."

Charles M Oct 24, 2018 5:36 PM (in response to Christian Berg)

Ok, thanks. But, (warning: dumb question ) how do we know which column(s) to put in the dimension? The error only states that it isn't associated with any tables. It doesn't mention any columns specifically.

Regards,

Charles
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.