Is possible to join a dimension to an OLAP cube using fields that do not have a foreign-key relationship in the underlying relational DB?
Yes it is possible. It is called logical relationship and is defined in DSV - data source view. Just drag a many side field (logical FK) from one table to logical PK field of another table.