AnsweredAssumed Answered

Duplicate dimensional data error

Question asked by ma12 on May 9, 2014
Latest reply on May 9, 2014 by ma12

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

 

 

Outcomes