Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cross Source Relationships

Hi,

 

I have created a dataset for news and a dataset in which some dim tables are located for reuse. So I have a DirectQuery to the news dataset with one table and a direct query to the dim dataset with several tables.

 

In the news dataset there is a identifier for the sales organization and the date. The identifier for the sales org should connect n:1 to the dim table for the sales orgs and the date n:1 to the dim table for the dates.

 

Unfortunately it does not let me draw more than one relationship betweens the sources.

 

but I receive the following message:

 

Do I need a separate DS for each dim table as just one relationship is possible cross source?

Need Help

4 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    Reading the error message it sounds like you were trying to set a bidirectional relationship between sales org and news. Does it work if you set the cross filter direction to single ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    no. It does not let me change it. The settings window is not opening, but the error message comes right after I drag the Id over the related field.

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    Reading the docs it says that any cross-source relationship is created as many-to-many by default, so it would be trying to create a bidirectional relationship. As a workaround you could try and deactivate the relationship from date to news, create the new relationship and then make it one-to-many single direction and then reenable the relationship from date.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Making the relationship inactive does not change the error message.

     

    As a workaround I can establish a connection to the DS and chose just one table for each connection. This way I can create the relationships without error message.  ğŸ¤”