3 Replies Latest reply on Nov 19, 2012 10:36 AM by Russell Christopher

    Why are my data relationships being removed when I refresh the data?

    Weston Cronkite

      Hi,

       

      So I am looking to blend two SQL data sources based on date so that I can present a weekly trend of information.  I set both date fields as dimensions and then added both Date1 and Date2 in the Relationships screen as well as WEEK(Date1) and WEEK(Date2)   When I do this the numbers look just as I'd like them to in my worksheet.  I then refresh the data or publish to the server and the numbers show up in aggregate across all weeks.  When I look the Date1 and Date2 relationships are all that remain and the WEEK(Date1) and WEEK(Date2) are removed.

       

      Why is this happening???

       

      Thanks!