Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
How to find the values ​​of a field Multiple Project Server in SQL Server

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

  • quarta-feira, 2 de maio de 2012 12:00
     
     
    Entrar para Votar
    0

    Hello,

    Do not know much about SQL and I am with the following scenario.

    I have a database with a field in ProjectServer_ReportingEPM2010, I called the company,it is configured to use multiple values​​ , these multiple values ​​are displayed in Project Professional 2010 through the project information that is integrated with Project Web Access - PWA.

    example:

    I found a table called MSPCFPRJ_03.Empresa (P) _AssociationView where I imagine that is the values​​, only values ​​are in unreadable format would unify this information to display a more user-friendly?

    What call is garbled because the Company column (P) is being displayed information "Null" and that the information being displayed should be the name of the selected companies.

    Example:

    Thank you for your help


    Hezequias Vasconcelos


     

Todas as Respostas

  • quarta-feira, 2 de maio de 2012 12:35
     
     
    Entrar para Votar
    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

     
  • quarta-feira, 2 de maio de 2012 12:46
     
     
    Entrar para Votar
    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

     
  • quinta-feira, 3 de maio de 2012 14:23
     
     
    Entrar para Votar
    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

     
  • quinta-feira, 3 de maio de 2012 14:37
     
     
    Entrar para Votar
    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



     
  • segunda-feira, 7 de maio de 2012 14:26
     
     Respondido
    Entrar para Votar
    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