Hello,
I am getting the standrad "This query produced duplicate dimensional data." error.
I added the rownum too but still getting the same error.
Apperciate help.
Thanks,
MN
select
@SELECT:DIM:USER_DEF:IMPLIED:resource:q.id:res_id@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:secug.id:secug_id@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:q.full_name:resname@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:q.email:resemail@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:q.is_active:resactive@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:secg.group_name:group_name@
FROM SRM_RESOURCES q
INNER JOIN CMN_SEC_USER_GROUPS secug ON secug.user_id = q.user_id
INNER JOIN CMN_SEC_GROUPS_V secg ON secug.group_id = secg.id
AND secg.language_code = 'en'
AND @FILTER@
ORDER BY secg.group_name