AnsweredAssumed Answered

RESOLVED >> NPT-217: This query produced duplicate dimensional data.

Question asked by stephen_forney on Aug 2, 2012
Latest reply on Jan 28, 2014 by another_martink
Hello All -

Any help would be appreciated ....

I am trying to create a NSQL-Based portlet to report on the time submitted for Ideas.
primary table is the prj_blb_slices_M_act table

The logic is producing a "duplicate dimensional data" message.

How do I alter the logic on the NSQL below to elimate the "duplicate dimensiona" issue.

Thanks ..
Stephen

>>>>>>>>>>>>>>>>>>>>>
NPT-217: This query produced duplicate dimensional data. The results shown here may be invalid or incomplete.

>>>>>>>>>>>>>>>>>>>>>
select @SELECT:DIM:USER_DEF:IMPLIED:IDEATIME:srm.id:srm_resource_id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:srm.full_name:srm_full_name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:srm.unique_name:srm_unique_name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:blb.slice_date:blb_slice_date@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:blb.slice:blb_slice@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:inv.code:inv_code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:inv.odf_object_code:inv_investment_type@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEATIME:inv.name:inv_investment_name@

from prj_blb_slices_M_act blb,
srm_resources srm,
inv_investments inv,
inv_ideas ida

where srm.id = blb.resource_id
and blb.investment_id = inv.id
and inv.id = ida.id

and @filter@


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
The native SQL is listed below seems to work fine when I run it directly against the database ...

select srm.unique_name, srm.full_name, inv.code, inv.odf_object_code, inv.name, inv.labor_actsum, blb.slice_date, blb.slice

from prj_blb_slices_m_act blb,
srm_resources srm,
inv_investments inv,
inv_ideas ida

where srm.id = blb.resource_id
and blb.investment_id = inv.id
and inv.id = ida.id
and inv.odf_object_code in ('idea')

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

end

Outcomes