Wednesday, May 02, 2012 12:00 PM
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.
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.
Thank you for your help
- Edited by Hezequias Vasconcelos Wednesday, May 02, 2012 12:21 PM
Wednesday, May 02, 2012 12:35 PM
Here is an excellent article from Paul.
Hope that helps.
Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
Wednesday, May 02, 2012 12:46 PM
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.
Thursday, May 03, 2012 2:23 PM
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
Thursday, May 03, 2012 2:37 PM
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
AttributeName as CustomFieldName
MSP_EpmMetadataAttribute INNER JOIN MSP_EpmLookupTable ON
DimensionUID = MSP_EpmLookupTable. LookupTableUID
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.
Monday, May 07, 2012 2:26 PMHello Friends,
The solution to this problem was achieved using this query:
[MSPLT_Empresa (P) _UserView]. MemberValue
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
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.
- Marked As Answer by Hezequias Vasconcelos Monday, May 07, 2012 2:27 PM