Joining tables generates an error

[kumar_s]

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

[cschnu]

Is the table relationship defined in framework manager? Or are you trying to join two queries?

[cognos_guru]

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.

[cschnu]

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?