AnsweredAssumed Answered

Clarity :  Report Query and duplicate dimension data issue ?

Question asked by suraj.rajendran on Aug 24, 2011
Latest reply on Sep 21, 2011 by Keri Taylor
Hi Support team,

I am your one of UK client, I have two questions on below query

1) Can you please check if the below query if the query is ok with given joins table correctly ?
If not , please let me know the possible correction/solution .

i need to create a grid portlet showing project name , report date , project status indicator, Invetment stage, status report(current phase), prtask forecast finish data, prtask actual finish date, prtask baseline finish date,

SELECT
DISTINCT prtask.prprojectid ,inv_investments.ID, odf_ca_project.ID,
odf_ca_task.ID, odf_ca_cop_prj_statusrpt.ID,
inv_investments.name,odf_ca_cop_prj_statusrpt.cop_report_date,
inv_investments.STATUS_INDICATOR,
inv_investments.STAGE_CODE,
odf_ca_cop_prj_statusrpt.cop_phase,
odf_ca_project.bg_buslead,
odf_ca_project.bg_islead,
odf_ca_project.bg_nextqg_lookup,
prtask.prIsMilestone,
prtask.prIsKey,
odf_ca_task.bg_taskqualgate,
prtask.prstatus,
prtask.prFinish
FROM
clarity.inv_investments,
clarity.prtask,
clarity.odf_ca_project,
clarity.odf_ca_task,
clarity.odf_ca_cop_prj_statusrpt

WHERE
( (inv_investments.ID = prtask.prprojectid)
AND (prtask.prprojectid = odf_ca_project.ID)
AND (prtask.prprojectid = odf_ca_task.ID)
AND (prtask.prprojectid = odf_ca_cop_prj_statusrpt.ID) and inv_investments.IS_ACTIVE <> 0
)
2) why the above query in portlet gives error saying "NPT-217: This query produced duplicate dimension data The results shown here may be invalid or incomplete"

Outcomes