"the query"?
I can give you an example on what you would need to do to your query using the default example NSQL that the system uses - I've added the highlighted line;
SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:R.FULL_NAME:RSRC@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:MR.FULL_NAME:MANAGER@,
@SELECT:METRIC:USER_DEF:IMPLIED:COUNT(*):PROJECT_COUNT:AGG@
FROM INV_INVESTMENTS I,
SRM_RESOURCES R,
SRM_RESOURCES MR,
CMN_SEC_USERS U
WHERE I.CREATED_BY = U.ID
AND U.ID = R.USER_ID
AND U.ID = @WHERE:PARAM:USER_ID@
AND R.MANAGER_ID = MR.USER_ID
AND @FILTER@
GROUP BY R.FULL_NAME,
MR.FULL_NAME
HAVING @HAVING_FILTER@