Hi:
I am new to BI and am trying to join two tables in order to generate a report. But I seem to be getting some errors and was wondering if any of you could help me. The error I get is:
Cross joins (between query subjects: [Business Layer].[OAKS Employee MSTR], [OAKS Data Warehouse].[OAKS Benefit Billing Reporting Table]) are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Readers, Express Authors, Authors, Query Users, Consumers, Metrics Authors, Metrics Users, Planning Contributor Users, Controller Users, Analysis Users, Data Manager Authors, OH_BN_VIEWER, OH_EPM_COGNOS_PRIVATE, OH_EPM_COGNOS_RUN, OH_EPM_DAS_FOLDER_WRITE, OH_EPM_EMP_MASTER_INTERFACE, OH_EPM_FMLA_USAGE, OH_EPM_OBJ_EXPENSE_INTERFACE, OH_EPM_OHI_FOLDER_VIEW, OH_EPM_QUERY_PRIVATE, OH_HR_VIEWER, OH_PY_VIEWER}'.
Details
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-07-21-08:20:17.883-#31
Any advice/assistance is greatly appreciated.
Thanks in advance.
Kumar
Is the table relationship defined in framework manager? Or are you trying to join two queries?
In the properties for each query you are trying to join (you can get to the query properties through Query explorer), there is a property for Cross Join Allowed - set this to yes and try to run the report again.
Quote from: cognos_guru on 21 Jul 2009 10:07:28 AM
In the properties for each query you are trying to join (you can get to the query properties through Query explorer), there is a property for Cross Join Allowed - set this to yes and try to run the report again.
This is the fix if a cross join is your desired behavior.
I am relatively new to data warehousing in what situations would you want to actually use a cross join? Examples?