Passing Cognos Username to SSAS

[Fleschgordon]

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

[Robl]

#sq($account.personalInfo.email)#

It wraps the details in single quotes so it gets treated as a string.

[MFGF]

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.

[Fleschgordon]

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.

[MFGF]

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.

[Fleschgordon]

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.