AnsweredAssumed Answered

Error:  NPT-217: This query produced duplicate dimensional data.

Question asked by picis on Dec 12, 2008
Latest reply on Jun 15, 2012 by another_martink
I'm somewhat new to writing nSQL queries.  We have a couple of custom portlets that are pulling Actuals referencing the Timeslice table (prj_blb_slices).  The existing queries are pulling Project & Resource details with the hours.  I'm trying to create a new query/portlet that also captures/displays the task level details, but no matter how I construct the query, I always get this result on the portlet:   Error    NPT-217: This query produced duplicate dimensional data. The results shown here may be invalid or incomplete.   The core SQL code of the query produces the result I want, but I'm struggling with getting the right dimensions/configuration.  I can get the query to produce results if I don't have the task level fields, but as soon as I add those it it fails.   Thanks,- Mark

Outcomes