11 Comments

  1. Michael Charleson
    22 May, 2022 @ 00:28

    If you have the following tables in your .xer file do you need to transpose the data in these tables to link them to the other tables in the P6 datasets:

    UDFType
    UDFValue

    Reply

    • Project 2080
      23 May, 2022 @ 10:02

      Hi Michael,

      thanks for your message. The UDFType (User Defined Fields) and UDFValue (User Defined Field Values) tables are not needed to be transposed. You should link both tables via “udf_type_id” column. This field is Unique ID for UDFTYPE table, and part of the UDFVALUE table.

      I hope this helps you.

      Regards,

      Reply

  2. Greg
    6 July, 2022 @ 11:16

    Hi, Thanks for the blog above.

    We’ve connected the P6 SQL tables directly to Power BI and are looking to create an S-curve from the data. I’ve noticed that each individual task code (TASK) has multiple rows with a new one being generated whenever the overall baseline gets updated. Do you know of any flag columns/filter columns that automatically filter for the most recent entry? I can get this data anyway in power bi but I’d rather use a built in column if theres one there.

    Thanks,

    Reply

  3. Abdul Raheem
    12 July, 2022 @ 20:12

    In Step 1 XER to Power BI, its better to select Text file and then split using tab delimiter, else Task Name (if it has commas) it will be big mess for XER file containing 50,000 or more activities.

    Reply

    • Project 2080
      13 July, 2022 @ 06:31

      Thanks for your comment. Really appreciate, Abdul !!

      Reply

  4. Doug Galt
    3 September, 2022 @ 04:14

    Is there a way to take the steps structure from within p6 and link within power bi?

    Reply

    • Project 2080
      5 September, 2022 @ 15:29

      Dear Doug,

      you can find all related to the activity steps on the TASKPROC Table, within the XER file.

      Regards,

      Reply

  5. Zahir HADDAD
    3 November, 2022 @ 21:51

    Hi, I followed all the steps unfortunately it is not working for me! Am I doing anything wrong?

    Reply

    • Project 2080
      10 November, 2022 @ 21:08

      Hi Zahir,

      please drop us an email with some screenshots in order to find out where it is not working.

      Regards,

      Reply

  6. Stephen
    8 November, 2022 @ 22:25

    How is the Activity Code related to the Task. I can’t find an Activity_Code_id in the Task record?
    Thanks

    Reply

    • Project 2080
      10 November, 2022 @ 21:06

      Hi Stephen

      They are related within the TASKACTV table. If you do not find it, please drop us an email.

      Regards,

      Reply

Leave a Reply

Your email address will not be published.