Evan ross principal
Download
1 / 19

Evan Ross Principal - PowerPoint PPT Presentation


  • 191 Views
  • 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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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

Principal


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

view.SetViewStatus(category,xtrViewStatus.trViewStatusApexAncestor)

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
Questions?


ad