none
what is key to create odata feed relationship between AssignmentBaselineTimephasedData AND AssignmentTimephasedData RRS feed

  • Question

  • Dear Team,

    what is key element to create odata feed relationship between AssignmentBaselineTimephasedData AND AssignmentTimephasedData? I tried assignment Id but it not accepting??

    Thanks In Advance.


    • Edited by donivm Friday, March 27, 2015 7:13 AM
    Thursday, March 26, 2015 5:25 PM

Answers

  • Hello. I think as these two probably require joining in two keys (assignmentid and timebyday) to get a unique relationship. Unfortunately I dont think that is possible in Excel data relationships. Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, March 27, 2015 7:26 AM
    Moderator
  • Paul is right in that you need both keys. PowerPivot in v1 had a single column limitation for primary keys. I haven't tested to see if PowerPivot/PowerQuery have been updated to resolve this.

    Another way to get around this is to create a composite key. I would create a derived field that concatenates TimeByDay to AssignmentId. If done properly, this would provide your single unique key.

    Treb Gatte, Project MVP | Blog | Twitter | YouTube Channel

    Friday, March 27, 2015 4:39 PM
    Moderator

All replies

  • Hello. I think as these two probably require joining in two keys (assignmentid and timebyday) to get a unique relationship. Unfortunately I dont think that is possible in Excel data relationships. Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, March 27, 2015 7:26 AM
    Moderator
  • Paul is right in that you need both keys. PowerPivot in v1 had a single column limitation for primary keys. I haven't tested to see if PowerPivot/PowerQuery have been updated to resolve this.

    Another way to get around this is to create a composite key. I would create a derived field that concatenates TimeByDay to AssignmentId. If done properly, this would provide your single unique key.

    Treb Gatte, Project MVP | Blog | Twitter | YouTube Channel

    Friday, March 27, 2015 4:39 PM
    Moderator