joins between data cubes in version 7

Ok, I’m sure I just missed the memo or something, but I can no longer bring in fields from different cubes into a single metric set since we updated to version 7. I remember reading in the upgrade notes that you could no longer View Relationships by right clicking on the data cube, but I don’t remember notice about how you are supposed to join data cubes now into one metric set. Can someone point out what I am missing? Thanks very much.

Error when bringing in field from data cube 2 into a metric set containing data cube 1, where there was a relationship defined between data cube 2 and 1: The application settings do not allow automatic joins between different data cube

I went to support on this question and it appears there may be a new setting or maybe just a new default with the upgrade in the config: Allow Automatic Cube Joins. Changing this solved the error.

2 Likes