COGNOiSe.com - The IBM Cognos Community

Hi frnds...Can anyone tell me how to use session parameters in tabular SQL..I searched forÃ,  this topic and didnt find any...Waiting for ur Reply ;)



Thanks,
S

This is what I did for one of my customers.

The SQL is native SQL, make sure you've got connection to your datasource (you can select this in the properties of the tabular SQL).

Select dbo.tblGebruiker.strNTUsername,dbo.tblItemOnzichtbaar.intItemID
from dbo.tblItemOnzichtbaar, dbo.tblGebruikerSecurityGroep, dbo.tblGebruiker
where dbo.tblItemOnzichtbaar.intSecurityGroepID=dbo.tblGebruikerSecurityGroep.intSecurityGroepID
andÃ,  Ã, dbo.tblGebruikerSecurityGroep.lngGebruikerID=dbo.tblGebruiker.lngGebruikerID
andÃ,  Ã, dbo.tblGebruiker.strNTUsername=#sq($account.personalInfo.userName)#Ã, 

This works like a charm.

Cornelis

Thnx....its helpful...