How do I join custom attributes
I have consulted several articles from jazz on how to create custom attributes. I have created 3 queries- queries 3, 4 5, I added enumerations - enumerations id to query 4 and i added value /name to request string extension in query 5 and I also tried to link through the join button and when i try to run the report i get an error
RQP-DEF-0103
Cross joins (between query subjects: [Physical Metadata].[VW_PROJECT_RESOURCE_LOOKUP], [Physical Metadata].[VW_RQST_ENUMERATION], [Request Metrics].[Requests Detail (Total)], [Business View].[Request]) are not permitted for the user who has the identity '*
I am a little confused as to how to properly do the join and then add it to a report.
RQP-DEF-0103
Cross joins (between query subjects: [Physical Metadata].[VW_PROJECT_RESOURCE_LOOKUP], [Physical Metadata].[VW_RQST_ENUMERATION], [Request Metrics].[Requests Detail (Total)], [Business View].[Request]) are not permitted for the user who has the identity '*
I am a little confused as to how to properly do the join and then add it to a report.
Accepted answer
Hello Brandy,
the following technotes explain what is a cross join and how to avoid the RQP-DEF-0103 error:
RQP-DEF-0103 Cross joins are not permitted.
Cross Join error when creating a report on query subjects from the business view.
Best Regards
Francesco
the following technotes explain what is a cross join and how to avoid the RQP-DEF-0103 error:
RQP-DEF-0103 Cross joins are not permitted.
Cross Join error when creating a report on query subjects from the business view.
Best Regards
Francesco