Modify the NSQL statement so that the 'Dimension Key' returns unique values within the result set. This 'Dimension Key' can be created with any field type, but the results must be unique within the result set.
If you ignore this error message and continue to use the portlet, you may be using incorrect or incomplete data displayed in the Portlet result set.
The error message that you receive cannot be turned off. This error message is important to the end user to indicate that the information or data result set displayed from the Portlet may not contain all the appropriate data. Although you may need to have duplicate rows for a particular field, you can still construct your query in a manner that will retrieve a unique Dimensional Key. You are not required to display the Dimensional Key on the published Portlet. You may also consider creating a multiple dimensional portlet, that may resolve your issue. If you have a multiple dimensional portlet containing more than one Dimensional Key, the value in the Dimensional key can be non-unique if the combination of the data in all Dimensional Keys are unique.
Reference the Clarity Studio Guide documentation for more information on Portlet syntax and construction.