Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Get 14025 error only when combining dimensions

user4109719Jan 27 2021

I am using OBIEE 12.2.1.4.0. In the RPD, I have a fact table joined to four dimensions, dim1, dim2, dim3 and a date dimension. I get the "No fact table exists at the requested level of detail" error when using columns from dim1 simultaneously with dim2 or dim3 in the Analysis. There is no error when using columns from dim1 alone. Columns from dim1 can be used with date dimension columns with no error.
One of the other dimensions, dim2, is joined to dim1 in the physical layer, with dim2 having many to one in dim1. It is not joined to dim3 which relates to a totally different set of attributes.
All of the dimensions have a hierarchy and I have set the level for them in the fact table.

Comments

Processing

Post Details

Added on Jan 27 2021
0 comments
95 views