I'm creating a custom portlet similar to the out of the box Cost plan detail under the financial plan. Does anyone have a similar portlet? can you provide the NSQL used for that? Please help.
What product does your question refer to? I'd be happy to move it to the right community so it is answered faster.
Clarity PPM we're on version 13.3
Check this -
How do I get the actual costs too?
from ppa_wip, you can get actual costs
After creating the Grid portlet I'm getting the following error message:
ERRORNPT-217: This query produced duplicate dimensional data. The results shown here may be invalid or incomplete.
my values are not unique in all columns, how can I go around that and create a multi dimensional portlet?
That NPT-217 is one of the most common errors that we get with NSQL portlets (there will be lots of threads on here talking about it if you search for them). What it is telling you is that what you have defined in your NSQL as the DIM is not unique in the data-set that is returned.
So to make the error go away you just "correct" your NSQL - either fix it so what you have defined as the DIM is unique or define a different (unique) DIM.
Retrieving data ...