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.