Hello
we want to pass the cognos username to the ssas cube.
how can we do that ?
We tried to do it with a query detail filter, but it seems not to accept macros: #$account.personalInfo.email#
We want to handle the security in the SSAS
thanks in advance for any tips
#sq($account.personalInfo.email)#
It wraps the details in single quotes so it gets treated as a string.
Quote from: Fleschgordon on 28 Jan 2015 10:03:21 AM
Hello
we want to pass the cognos username to the ssas cube.
how can we do that ?
We tried to do it with a query detail filter, but it seems not to accept macros: #$account.personalInfo.email#
We want to handle the security in the SSAS
thanks in advance for any tips
What authentication provider are you using with your Cognos instance? Active Directory? Are the users in SSAS also AD users?
If so, you simply need to change the connection properties of your data source for SSAS to use the "An external namespace" option - so that the signon used to connect Cognos to SSAS for each user is the signon they used to authenticate in Cognos.
Cheers!
MF.
Quote from: MFGF on 28 Jan 2015 10:31:29 AM
What authentication provider are you using with your Cognos instance? Active Directory? Are the users in SSAS also AD users?
If so, you simply need to change the connection properties of your data source for SSAS to use the "An external namespace" option - so that the signon used to connect Cognos to SSAS for each user is the signon they used to authenticate in Cognos.
Cheers!
MF.
Hi cognos uses ldap, SSAS uses Windows Authentication.
the cognos ldap is different - we want to uses in SSAS Forms authentication and handle the data level security inside the SSAS
So SSAS needs to know the cognos userid.
Quote from: Fleschgordon on 28 Jan 2015 11:14:56 AM
Hi cognos uses ldap, SSAS uses Windows Authentication.
the cognos ldap is different - we want to uses in SSAS Forms authentication and handle the data level security inside the SSAS
So SSAS needs to know the cognos userid.
If you're using different authentication providers, I doubt you're going to achieve what you desire, sadly. The only method I know of to get this to work is as I suggested above.
MF.
Hi,
its now working - we connect SSAS through NT Authentication.
we pass the cognos username via filter to the ssas cube and add there a filter to the query with the username. and the usernames are inside ssas in a table where we assign the correct filter to the data we pass back to cognos.
thanks for your suggestions.