I am getting the following error
' Query will create a Cartesian Product Do you want to continue '
If I click OK, the results are coming fine. But I am not sure of why this message is coming.
The field that is causing this problem is max(( DM_EXTRACT.LOAD_FINISH )and it is from the table DM_EXTRACT.
Below is my Query
SELECT
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39,
max(( DM_EXTRACT.LOAD_FINISH ))
FROM
DM_EXTRACT,
DM_VW_BUDGET_UNIT_DIM,
DM_VW_WORK_ATTRIBUTE_DIM,
DM_VW_NOTES_DIM,
DM_BUDGET_DATA_FACT
WHERE
( DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE=DM_VW_BUDGET_UNIT_DIM.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.ACTIVITY_CODE=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_NOTES_DIM.ACTIVITY_CODE(+)=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.WBS30 = @Prompt('Select the Project Report Type','C','Project Alternate Structures\Project Report Type',Mono,) )
GROUP BY
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39
Please update on how to get rid of this message. I looked at some previous solutions that point to Joins, I tried defining a Join DM_EXTRACT & DM_VW_BUDGET_UNIT_DIM (one of the existing tables) I am still getting the same error.
Any help would be appreciated.
Regards
Jags
' Query will create a Cartesian Product Do you want to continue '
If I click OK, the results are coming fine. But I am not sure of why this message is coming.
The field that is causing this problem is max(( DM_EXTRACT.LOAD_FINISH )and it is from the table DM_EXTRACT.
Below is my Query
SELECT
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39,
max(( DM_EXTRACT.LOAD_FINISH ))
FROM
DM_EXTRACT,
DM_VW_BUDGET_UNIT_DIM,
DM_VW_WORK_ATTRIBUTE_DIM,
DM_VW_NOTES_DIM,
DM_BUDGET_DATA_FACT
WHERE
( DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE=DM_VW_BUDGET_UNIT_DIM.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.ACTIVITY_CODE=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_NOTES_DIM.ACTIVITY_CODE(+)=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.WBS30 = @Prompt('Select the Project Report Type','C','Project Alternate Structures\Project Report Type',Mono,) )
GROUP BY
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39
Please update on how to get rid of this message. I looked at some previous solutions that point to Joins, I tried defining a Join DM_EXTRACT & DM_VW_BUDGET_UNIT_DIM (one of the existing tables) I am still getting the same error.
Any help would be appreciated.
Regards
Jags