How to find the values ​​of a field Multiple Project Server in SQL Server

Toate mesajele

• 2 mai 2012 12:35

   

   
  

  1

  Hi There--

  Here is an excellent article from Paul.

  http://pwmather.wordpress.com/2011/09/07/accessing-custom-fields-that-allow-multiple-values-from-look-up-tables-in-projectserver-via-t-sql-msproject-ps2010-ps2007/

  Hope that helps.

  ---

  Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

  • Mesaj
  • Citare

   
• 2 mai 2012 12:46

   

   
  

  0

  Hi Amit Khare,

  So i already knew this post if you viewed the second print is exactly the same code but adapted to my needs.But my main question now is whether the company because the column is showing null value instead of the name of company name. Can you tell me why? I need to configure some information in SQL?

  Thanks for the help.

  ---

  Hezequias Vasconcelos

  • Mesaj
  • Citare

   
• 3 mai 2012 14:23

   

   
  

  1

  Hi Hezequias,

  I did this some times. The only difference is that I get the firm's names from the [LookupMemberUID] from the MSPCFPRJ_03.Empresa (P)_AssociationView and look in the MSPLT_03.Empresa (P)_UserView and retrieve the Empresas' name in the [MemberValue] field with same [LookupMemberUID].

  I hope this helps.

  ---

  Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

  • Mesaj
  • Citare

   
• 3 mai 2012 14:37

   

   
  

  0

  Hi Mr. Segawa,

  Thanks for the help.

  You have reason in relation to the concept, until the moment I could perform this operation to join the CustomFieldName MemberValue of the lookup table by running this query.

  SELECT
  
  dbo.MSP_EpmMetadataAttribute.

  AttributeName as CustomFieldName
  MSP_EpmLookupTable.MemberValue,
  MSP_EpmLookupTable.MemberFullValue,
  MSP_EpmLookupTable.MemberDescription,
  
  FROM
  
  MSP_EpmMetadataAttribute INNER JOIN MSP_EpmLookupTable ON
  MSP_EpmMetadataAttribute.DimensionUID = MSP_EpmLookupTable.LookupTableUID
  
  WHERE
  
  AttributeIsIntrinsic = 0 AND  MemberValue IS NOT NULL

  I'm still working on the development of unifying this information with the portfolio of projects and thus achieve the desired filter. Once you have the solution I post here.

  Thanks.

  ---

  Hezequias Vasconcelos

  
  
  

  • Editat de Hezequias Vasconcelos 3 mai 2012 14:38
  •  
  • Mesaj
  • Citare

   
• 7 mai 2012 14:26

   

   
  

  0

  Hello Friends,
  
  The solution to this problem was achieved using this query:
  
  SELECT
  
  MSP_EpmProject_UserView.ProjectName,
  [MSPLT_Empresa (P) _UserView]. MemberValue
  
  FROM
  
  dbo.MSP_EpmProject_UserView
  INNER JOIN [MSPCFPRJ_NameCustomField_AssociationView] ON [MSPCFPRJ_NameCustomField_AssociationView]. EntityUID = MSP_EpmProject_UserView.ProjectUID
  INNER JOIN [MSPLT_NameCustomField_UserView] ON [MSPLT_NameCustomField_UserView]. LookupMemberUID = [MSPCFPRJ_NameCustomField_UserView]. LookupMemberUID
  
  ORDER BY
  
  MSP_EpmProject_UserView.ProjectName,
  [MSPLT_NameCustomField_UserView]. MemberValue
  
  If you use the method to rename the field query will not generate inconsistencies identified the disso.Mas delete the field because they had problems and recreated it again. Thus when performing the same query worked perfectly. I hope that helps everyone.

  ---

  Hezequias Vasconcelos

  • Marcat ca răspuns de Hezequias Vasconcelos 7 mai 2012 14:27
  •  
  • Mesaj
  • Citare