Creating web intelligence report and dragged only one attribute and I am getting the only record result. Took the sql query also and run that query also in SQL Server query there also showing one record but there is 5 records but web intelligence sql query showin 1 records. Below is the query
select usm_vw_subscription_times.*,usm_tenant.tenant_name,account_tenant.tenant_name account_tenant from
usm_vw_subscription_times inner join usm_vw_user_tenant_role
on (usm_vw_subscription_times.domain = usm_vw_user_tenant_role.tenant_id and usm_vw_user_tenant_role.user_id = @VARIABLE('BOUSER'))
inner join usm_tenant on (usm_tenant.tenant_id=usm_vw_user_tenant_role.tenant_id)
inner join usm_tenant account_tenant on (account_tenant.tenant_id=usm_vw_user_tenant_role.account_tenant_id)
But when I write in SQL "select tenant_name from usm_tenant" it will show all 5 result.
Can anyone let me know whats wrong with universe or my web intelligence for BOXI R3.3