Evan ross principal
1 / 19

Evan Ross Principal - PowerPoint PPT Presentation

  • Updated On :

Automating Security in IBM Cognos 8 Transformer. Evan Ross Principal. IBM Services Partner. Expertise in the BI platform for more than 12 years Cognos BI Dashboarding Reporting Analysis Scorecarding Data Manager. Some of our Cognos Clients. Cognos security.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Evan Ross Principal' - solada

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Evan ross principal l.jpg

Automating Security in IBMCognos 8 Transformer

Evan Ross


Ibm services partner l.jpg
IBM Services Partner

  • Expertise in the BI platform for more than 12 years

    • Cognos BI

      • Dashboarding

      • Reporting

      • Analysis

      • Scorecarding

    • Data Manager

Slide3 l.jpg

Some of our Cognos Clients

Cognos security l.jpg
Cognos security

  • Great Active Directory integration for Framework Manager

  • Functionality added in Transformer 8.3 for Custom Views

The problem l.jpg
The problem:

  • Hospital ERP system

  • Complex security by department

  • Security table available in SQL

  • Framework Manager can easily connect to the SQL table

  • Hard to maintain in Transformer

    • Security Concerns

    • Timeliness

Transformer views l.jpg
Transformer views

  • Exclude

    • Not in cube

  • Cloak

    • In totals, not visible

  • Suppress

    • Hide level

  • Summarize

    • Hide lower levels

  • Apex

    • Hide upper levels

What does the user see l.jpg
What does the user see?

  • Two options:

    • Supress all categories at the lowest level and then unsuppress applicable categories

    • Apex on applicable categories

The solution l.jpg
The solution

  • Cognos 8.3 and higher allows for OLE automation of Transformer Model

  • Read SQL database and create User Views for each class

  • Tools needed:

    • Transformer

    • Visual Studio – free Express version is fine

    • Does NOT need Cognos SDK!

The next problem active directory names l.jpg
The next problem – Active Directory names!

  • Security tables uses login name

    • RossE

  • Cognos expects full name

    • Ross, Evan

  • The answer – link directly to Active Directory

Connecting to active directory l.jpg
Connecting to Active Directory

  • SQL Server supports linking directly to AD

Once connected it s a simple query l.jpg
Once connected, it’s a simple query…

Insert Into L_activedirectory Select Cn, Samaccountname From Openquery(adsi, 'Select Cn, Samaccountname From ''Ldap:// Dc1'' Where Objectclass = ''User'' And Objectcategory = ''Person'‘ Order By Givenname') End

Vb net code what does it do l.jpg
VB.NET code – what does it do?

For intX = 1 To dimension.DrillDowns.Item(1). Categories.Count

Dim category As Category = dimension.DrillDowns.Item(1).Categories(intX)

If category.Name = deptName Then


End If

Next intX

The end result l.jpg
The end result

  • No manual maintenance of Transformer security

  • Security preserved in all Cognos tools – relational, dimensionally modeled relational (DRM), and cubes

  • No more headaches for BI team!

Questions l.jpg