I tried to re-export the Activity Universe and received a cartesian error on the User Name object.
The sql generated by for the LOV does not appear to be correct 
I’d appreciate anyone confirming the same (the object does not have this code and a copy of the object does not generate the same …)
SQL Server 2000
SELECT DISTINCT
auditor.WA_OBJ_A_EVENT_LOG.A_C_USER
FROM
(((((((((((((((((((((((((((((((((((auditor.WA_OBJ_A_CLUSTER RIGHT OUTER JOIN auditor.WA_OBJ_A_EVENT_LOG ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_CLSTRIDF=auditor.WA_OBJ_A_CLUSTER.A_CLUSTER_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=auditor.WA_OBJ_A_EVDET.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_OBJECT_TYPE ON (auditor.WA_OBJ_A_EVDET.A_EVDET_N_OBJTYPID=auditor.OBJ_A_OBJECT_TYPE.A_OTYPE_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_NAME ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_TYPEID=auditor.OBJ_A_EVENT_NAME.A_EVNAM_N_ID) )
INNER JOIN auditor.WA_DOCUMENT_NAME ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Description ON (Description.A_EVDET_N_ID=auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Category ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Category.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Refresh_Options ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Refresh_Options.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Overwrite ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Overwrite.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Keywords ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Keywords.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Report_name ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Report_name.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Document_type ON (Document_type.A_EVDET_N_ID=auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Page_range ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Page_range.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Target_actor ON (auditor.WA_DOCUMENT_NAME.A_EVDET_N_ID=Target_actor.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET TotalSizeDocInList ON (TotalSizeDocInList.A_EVDET_N_ID=auditor.WA_OBJ_A_EVENT_LOG.A_N_ID) )
INNER JOIN auditor.WA_SESSION ON (auditor.WA_OBJ_A_EVENT_LOG.A_C_SESSION=auditor.WA_SESSION.SESSION_ID) )
LEFT OUTER JOIN auditor.WA_OBJ_A_CLUSTER Cluster_Session ON (Cluster_Session.A_CLUSTER_N_ID=auditor.WA_SESSION.SESN_CLSTRIDF) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Browser_OS ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=Browser_OS.A_EVDET_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Browser_IP ON (Browser_IP.A_EVDET_N_ID=auditor.WA_OBJ_A_EVENT_LOG.A_N_ID) )
INNER JOIN auditor.OBJ_A_EVENT_DETL Browser_Name ON (Browser_Name.A_EVDET_N_ID=auditor.WA_OBJ_A_EVENT_LOG.A_N_ID) )
INNER JOIN auditor.OBJ_A_APPLICATION ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_APPID=auditor.OBJ_A_APPLICATION.A_APPLI_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Parent_group_name ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=Parent_group_name.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET User_Name ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=User_Name.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Profile_Name ON (User_Name.A_EVDET_N_ID=Profile_Name.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Password ON (User_Name.A_EVDET_N_ID=Password.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Password_Enabled ON (User_Name.A_EVDET_N_ID=Password_Enabled.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK MustChangePassword ON (User_Name.A_EVDET_N_ID=MustChangePassword.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK PasswordCanChange ON (User_Name.A_EVDET_N_ID=PasswordCanChange.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK ObjectSecLevel ON (User_Name.A_EVDET_N_ID=ObjectSecLevel.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Password_checking ON (User_Name.A_EVDET_N_ID=Password_checking.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Password_Ltd_Valid ON (User_Name.A_EVDET_N_ID=Password_Ltd_Valid.A_EVDET_N_ID) )
LEFT OUTER JOIN auditor.WA_ADMIN_SDK Validity_Period ON (User_Name.A_EVDET_N_ID=Validity_Period.A_EVDET_N_ID) )
INNER JOIN auditor.WA_OBJ_A_EVDET Group_Name ON (auditor.WA_OBJ_A_EVENT_LOG.A_N_ID=Group_Name.A_EVDET_N_ID) )
WHERE
( Browser_IP.A_EVDET_N_OBJTYPID=10 )
AND ( Browser_OS.A_EVDET_N_OBJTYPID=11 )
AND ( Browser_Name.A_EVDET_N_OBJTYPID=12 )
AND ( TotalSizeDocInList.A_EVDET_N_OBJTYPID=13 )
AND ( Description.A_EVDET_N_OBJTYPID=14 )
AND ( Category.A_EVDET_N_OBJTYPID=15 )
AND ( Keywords.A_EVDET_N_OBJTYPID=16 )
AND ( Refresh_Options.A_EVDET_N_OBJTYPID=17 )
AND ( Overwrite.A_EVDET_N_OBJTYPID=18
)
AND ( Page_range.A_EVDET_N_OBJTYPID=20 )
AND ( Document_type.A_EVDET_N_OBJTYPID=21 )
AND ( Report_name.A_EVDET_N_OBJTYPID=22 )
AND ( Target_actor.A_EVDET_N_OBJTYPID=4 )
AND ( Parent_group_name.A_EVDET_N_OBJTYPID=23 )
AND ( Profile_Name.A_EVDET_N_OBJTYPID=24 )
AND ( Password.A_EVDET_N_OBJTYPID=25 )
AND ( Password_Enabled.A_EVDET_N_OBJTYPID=26 )
AND ( MustChangePassword.A_EVDET_N_OBJTYPID=27 )
AND ( PasswordCanChange.A_EVDET_N_OBJTYPID=28 )
AND ( ObjectSecLevel.A_EVDET_N_OBJTYPID=29 )
AND ( Password_checking.A_EVDET_N_OBJTYPID=30 )
AND ( Password_Ltd_Valid.A_EVDET_N_OBJTYPID=31 )
AND ( Validity_Period.A_EVDET_N_OBJTYPID=33 )
AND ( User_Name.A_EVDET_N_OBJTYPID=4 )
AND ( auditor.WA_SESSION.SESN_USER != 'unknown' )
AND ( floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60/5) > 0 )
AND ( floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60) > 0 )
GROUP BY
auditor.WA_OBJ_A_EVENT_LOG.A_C_USER,
auditor.WA_OBJ_A_CLUSTER.A_CLUSTER_C_NAME,
auditor.WA_OBJ_A_CLUSTER.A_CLUSTER_N_ID,
auditor.OBJ_A_EVENT_NAME.A_EVNAM_C_NAME,
auditor.OBJ_A_EVENT_NAME.A_EVNAM_N_ID,
auditor.OBJ_A_OBJECT_TYPE.A_OTYPE_C_NAME,
auditor.WA_OBJ_A_EVDET.A_EVDET_C_OBJNAME,
auditor.WA_OBJ_A_EVDET.A_EVDET_C_OBJN_LAB,
auditor.OBJ_A_APPLICATION.A_APPLI_C_NAME,
auditor.OBJ_A_APPLICATION.A_APPLI_N_ID,
auditor.WA_OBJ_A_EVENT_LOG.A_D_STARTIME,
auditor.WA_OBJ_A_EVENT_LOG.A_C_HOST,
auditor.WA_OBJ_A_EVENT_LOG.A_N_ERRORID,
auditor.WA_OBJ_A_EVENT_LOG.A_C_USER_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_N_ID,
auditor.WA_OBJ_A_EVENT_LOG.A_C_SESSION,
TotalSizeDocInList.A_EVDET_C_OBJN_NUM,
auditor.WA_DOCUMENT_NAME.A_EVDET_N_OBJECTID,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJNAME,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJN_LAB,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJN_TYP,
Description.A_EVDET_C_OBJNAME,
Category.A_EVDET_C_OBJNAME,
Keywords.A_EVDET_C_OBJNAME,
Refresh_Options.A_EVDET_C_OBJNAME,
Overwrite.A_EVDET_C_OBJNAME,
Target_actor.A_EVDET_C_OBJNAME,
Report_name.A_EVDET_C_OBJNAME,
Document_type.A_EVDET_C_OBJNAME,
Page_range.A_EVDET_C_OBJNAME,
Browser_Name.A_EVDET_C_OBJNAME,
Browser_IP.A_EVDET_C_OBJNAME,
Browser_OS.A_EVDET_C_OBJNAME,
User_Name.A_EVDET_C_OBJNAME,
Group_Name.A_EVDET_C_OBJNAME,
Parent_group_name.A_EVDET_C_OBJNAME,
Password.A_C_PSWD,
Password_Enabled.A_C_IS_ENABLED,
Password_checking.A_C_PSWD_CHECKING,
MustChangePassword.A_C_PSWD_MUST_CHG,
PasswordCanChange.A_C_PSWD_CAN_CHG,
Password_Ltd_Valid.A_C_PSWD_LTD_VALID,
Password_Ltd_Valid.A_C_VALID_PERIODIC,
Validity_Period.A_N_VALID_PERIOD_D,
ObjectSecLevel.A_C_OBJ_SEC_LEVEL,
Profile_Name.A_C_PROFILE_NAME,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YMDHMS,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YMD,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Y,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Q,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_M,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MN,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_W,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_D,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24MISS,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HHAMPM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MI,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_S,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Y_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Q_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_M_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_W_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_DM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MD,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_D_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24_L,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MI_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_S_LAB,
Cluster_Session.A_CLUSTER_C_NAME,
Cluster_Session.A_CLUSTER_N_ID,
auditor.WA_SESSION.SESSION_ID,
auditor.WA_SESSION.SESN_USER,
auditor.WA_SESSION.SESN_USER,
auditor.WA_SESSION.SESN_HOST,
auditor.WA_SESSION.SESN_START_YMDHMS,
auditor.WA_SESSION.SESN_END_YMDHMS,
floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60/5)*5,
floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60),
auditor.WA_SESSION.SESN_START,
auditor.WA_SESSION.SESN_START_YMD,
auditor.WA_SESSION.SESN_START_YM,
auditor.WA_SESSION.SESN_START_Y,
auditor.WA_SESSION.SESN_START_Q,
auditor.WA_SESSION.SESN_START_M,
auditor.WA_SESSION.SESN_START_W,
auditor.WA_SESSION.SESN_START_D,
auditor.WA_SESSION.SESN_START_HH24,
auditor.WA_SESSION.SESN_START_MI,
Cluster_Sitelog.A_CLUSTER_C_NAME,
Cluster_Sitelog.A_CLUSTER_N_ID,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGHOST,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGINFO,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGMODUL,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_D_LOGTIME,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_LOGLEVEL,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_ID,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_LOGPID
ORDER BY
auditor.WA_OBJ_A_CLUSTER.A_CLUSTER_C_NAME,
auditor.WA_OBJ_A_CLUSTER.A_CLUSTER_N_ID,
auditor.OBJ_A_EVENT_NAME.A_EVNAM_C_NAME,
auditor.OBJ_A_EVENT_NAME.A_EVNAM_N_ID,
auditor.OBJ_A_OBJECT_TYPE.A_OTYPE_C_NAME,
auditor.WA_OBJ_A_EVDET.A_EVDET_C_OBJNAME,
auditor.WA_OBJ_A_EVDET.A_EVDET_C_OBJN_LAB,
auditor.OBJ_A_APPLICATION.A_APPLI_C_NAME,
auditor.OBJ_A_APPLICATION.A_APPLI_N_ID,
auditor.WA_OBJ_A_EVENT_LOG.A_D_STARTIME,
auditor.WA_OBJ_A_EVENT_LOG.A_C_HOST,
auditor.WA_OBJ_A_EVENT_LOG.A_N_ERRORID,
1,
auditor.WA_OBJ_A_EVENT_LOG.A_C_USER_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_N_ID,
auditor.WA_OBJ_A_EVENT_LOG.A_C_SESSION,
TotalSizeDocInList.A_EVDET_C_OBJN_NUM,
auditor.WA_DOCUMENT_NAME.A_EVDET_N_OBJECTID,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJNAME,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJN_LAB,
auditor.WA_DOCUMENT_NAME.A_EVDET_C_OBJN_TYP,
Description.A_EVDET_C_OBJNAME,
Category.A_EVDET_C_OBJNAME,
Keywords.A_EVDET_C_OBJNAME,
Refresh_Options.A_EVDET_C_OBJNAME,
Overwrite.A_EVDET_C_OBJNAME,
Target_actor.A_EVDET_C_OBJNAME,
Report_name.A_EVDET_C_OBJNAME,
Document_type.A_EVDET_C_OBJNAME,
Page_range.A_EVDET_C_OBJNAME,
Browser_Name.A_EVDET_C_OBJNAME,
Browser_IP.A_EVDET_C_OBJNAME,
Browser_OS.A_EVDET_C_OBJNAME,
User_Name.A_EVDET_C_OBJNAME,
Group_Name.A_EVDET_C_OBJNAME,
Parent_group_name.A_EVDET_C_OBJNAME,
Password.A_C_PSWD,
Password_Enabled.A_C_IS_ENABLED,
Password_checking.A_C_PSWD_CHECKING,
MustChangePassword.A_C_PSWD_MUST_CHG,
PasswordCanChange.A_C_PSWD_CAN_CHG,
Password_Ltd_Valid.A_C_PSWD_LTD_VALID,
Password_Ltd_Valid.A_C_VALID_PERIODIC,
Validity_Period.A_N_VALID_PERIOD_D,
ObjectSecLevel.A_C_OBJ_SEC_LEVEL,
Profile_Name.A_C_PROFILE_NAME,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YMDHMS,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YMD,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_YM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Y,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Q,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_M,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MN,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_W,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_D,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24MISS,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HHAMPM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MI,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_S,
min(auditor.WA_OBJ_A_EVENT_LOG.A_D_STARTIME),
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Y_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_Q_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_M_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_W_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_DM,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MD,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_D_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_HH24_L,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_MI_LAB,
auditor.WA_OBJ_A_EVENT_LOG.A_D_START_S_LAB,
Cluster_Session.A_CLUSTER_C_NAME,
Cluster_Session.A_CLUSTER_N_ID,
auditor.WA_SESSION.SESSION_ID,
auditor.WA_SESSION.SESN_USER,
auditor.WA_SESSION.SESN_USER,
auditor.WA_SESSION.SESN_HOST,
auditor.WA_SESSION.SESN_START_YMDHMS,
auditor.WA_SESSION.SESN_END_YMDHMS,
floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60/5)*5,
floor(auditor.WA_SESSION.SESN_DURATION_SEC / 60),
auditor.WA_SESSION.SESN_START,
auditor.WA_SESSION.SESN_START_YMD,
auditor.WA_SESSION.SESN_START_YM,
auditor.WA_SESSION.SESN_START_Y,
auditor.WA_SESSION.SESN_START_Q,
auditor.WA_SESSION.SESN_START_M,
auditor.WA_SESSION.SESN_START_W,
auditor.WA_SESSION.SESN_START_D,
auditor.WA_SESSION.SESN_START_HH24,
auditor.WA_SESSION.SESN_START_MI,
Cluster_Sitelog.A_CLUSTER_C_NAME,
Cluster_Sitelog.A_CLUSTER_N_ID,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGHOST,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGINFO,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_C_LOGMODUL,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_D_LOGTIME,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_LOGLEVEL,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_ID,
auditor.WA_OBJ_A_SITE_LOG.A_STLOG_N_LOGPID[added bbc CODE formatting - Andreas]
MikeD 
(BOB member since 2002-06-18)