Adding a Relationship in olap Cube

Is possible to join a dimension to an OLAP cube using fields that do not开发者_C百科 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.