Blog Pro de Jean-Baptiste HEREN

Notes d'un consultant Freelance en Informatique

To content | To menu | To search

setup cognos to work with OLAP MSAS cubes security

Usually, when we create a data source in Cognos, it is easier to specify a connection using Cognos Service Credentials. This means that all connections to the data source are done using the Cognos service user's profile.

  • Advantage of this method is that it needs less setup on the corresponding database server (only one account).
  • Disadvantage is that you cannot make use of "row level security" as all Cognos users will connect using the same profile (Data source has no information about current Cognos user).

To take advantage of an eventual user level security setup behind Cognos data sources, we need to connect using the current Cognos user's profile.

In the following example, we are editing a Microsoft Analysis services data source. We will setup that Cognos connection so that user's own credentials are transmitted to the database server:

  • Remove SSO  : just because it didn't work for me when combined with MSAS active directory connections to data sources, on Cognos 8.2. It may work on later releases… If someone can help, let me know :).
  • Using the portal, change connection's setup so that it uses an external namespace (AD).
  1. In Cognos directory, select data sources tab and click on the connection

  2. On the connexion page, click on the properties icon to edit parameters.

  3. On connection string, click on the pen icon to edit credentials.

  4. In the connection string, we change from "Cognos 8 service credentials" to "External Namespace: Active Directory". Then click OK on each page to validate.

Jean-Baptiste Heren

Author: Jean-Baptiste Heren

Stay in touch with the latest news and subscribe to the RSS Feed about this category

Comments are closed

no attachment

You Might Also Like


Cognos Report : Display a different measure in row for the aggregated column

Following tip is when you use a Relational Datamodel (DMR). In a Cognos Report crosstab, If You need to Display different measure in the aggregated column, you can do it using a simple if-then-else...

Continue reading

Cognos 8 - convert a member unique name from one hierarchy to another

If you need to build any report or Event studio Query using the same data from different packages; and you want to prompt just once. You can convert the member unique name from one hierarchy to...

Continue reading