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.
精彩评论