Forum Discussion

seanburns76's avatar
seanburns76
Regular Visitor
8 years ago

Artificial Duplication being created

I am getting the dreaded "Can't Display this visual" due to duplicate in a 1:many relationship. But there is no duplication.

The data consists of a Date(Date Format)/Workcenter(text)/Hour(whole num)/Duration(decimal)/ and the error column is a concatenated field of Date/Workcenter/Hour. Which I then use as a distinct field to connect to other datasets.

The shot below shows a duplication in Data view, but when I go to Edit Queries and drill down to this date, and workcenter

the duplication doesn't show(shown in the second shot). 

I've covered all of the angles of this report from the sql server table, the query that builds the view I connect to, the underlying table in the dataset, and the aggregated dataset that is used for the visual. 

Has anyone else experienced this? I can't seem to find my user error, IF it exists. 

Thank you for any feedback you may have....

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi seanburns76,

     

    I think your tables has used multiple 'one to many' relationships to link each tables, right?

    According to your error message, it seems like you're try to use multiple 'many' side columns at same time. If this is a case, please drag unique column from bridge table to this visual to fix this issue.

     

    If above not help, please provide more detail information about your scenario.

    How to Get Your Question Answered Quickly

     

    Regards,
    Xiaoxin Sheng