Skip to Content
0
Former Member
Jun 24, 2015 at 04:33 PM

Web Intelligence r3.3 showing single record

15 Views

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

DT_usm_subscription_detail_EU.tenant_name

FROM

(

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)

) DT_usm_subscription_detail_EU

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

Thanks,

Mohit