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

Charles M

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

[Deleted User]

"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?

Charles M

Sorry. Good catch ...

Charles M

Also, found these:

[Deleted User]

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

Gianni Ceresa

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)

[Deleted User]

That's my point. No tables = no work-y

Charles M

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

Bi Apps strikes again! I'm forseeing another SR in my future ...

Gianni Ceresa

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)?

[Deleted User]

The dimension maps to a logical table, not a physical one.

Charles M

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

I can see these objects in the BMM