Hi,
Am working on one some universe where they have used @variable(‘BOUSER’) in where condition.But whenever am using those particular objects, it is not fetching the data.If am commenting this condition, it is fetching the records.
Could any one please throw some light on this why it is happening.
Thanks,
Anu
anuaina (BOB member since 2009-07-30)
They have put row restrictions on using the BO user name and are using them to restrict the results…
Please put the exact syntax on here, of the where clause…
Mak 1 
(BOB member since 2005-01-06)
Hi,
The following is the query which is generated by that particular universe objects.If I use the object like this, it will say no data to fetch.But if am commenting the condition
AND ( PORTFDM.DM_USER_BR.BOUSER= @Variable(‘BOUSER’) ) it will fetch the records.There are some more objects like this which use the same kind of condition.In all of that, am commenting the conditio and using it.
As per my knowledge,@variable(‘BOUSER’) is used to know the loginids who have run the report on the particular universe.Am i right?
SELECT DISTINCT
PORTFOLIONAME.DESCRIPTION
FROM
PORTFDM.DM_USER_BR,
PORTF.PORTAL_MEMBER,
PORTF.STRUCTURE PORTFOLIONAME
WHERE
( PORTF.PORTAL_MEMBER.USER_NAME=PORTFDM.DM_USER_BR.PVUSER )
AND ( PORTFOLIONAME.STRUCTURE_CODE=PORTF.PORTAL_MEMBER.STRUCTURE_CODE )
AND ( PORTFDM.DM_USER_BR.BOUSER= @Variable(‘BOUSER’) )
AND ( PORTF.PORTAL_MEMBER.PORTAL_TYPE= ‘PORTFOLIO’ )
ORDER BY
1
Could you please throw some light on this???
anuaina (BOB member since 2009-07-30)
Not in this instance…:).
Here it is being used to restrict rows as per a security table; PORTFDM.DM_USER_BR to get this to work as it should you need to be given access, via your user ID, to these rows.
You should speak to your DBA.
Mak 1 
(BOB member since 2005-01-06)
Hi,
Thanks a lot for your timely help. 
Shall I know in which all situations this will be used.
Thanks,
Anu
anuaina (BOB member since 2009-07-30)
Thanks a lot for that
anuaina (BOB member since 2009-07-30)