Ironside Group
  • Home
  • About
  • AWS Ascent Solutions
  • IBM Data Analytic Services
  • Resources
  • Blog
  • Careers
  • Contact
  • Search
  • Menu Menu
Request a Meeting
Business Analytics, Technology Spotlight

Enhanced Security in IBM Cognos BI 10.2.1 Dynamic Cubes

enhanced security bodyguard concept
February 3, 2014/by Ironside Group

The IBM Cognos BI 10.2.1 release made significant enhancements to the Dynamic Cube options available in the product. One major boost to functionality is that you can now add enhanced security within Cube Designer and not have to restart the Dynamic Cube, and there are many other similar benefits included as well.

The enhanced security features listed below have been added in the 10.2.1 release:

  • Dynamic Cube Security Refresh: It is now possible to refresh security without having to restart a Dynamic Cube as long as there is no model change.
  • Role-Based Security:

Dimension Security: It is now possible to secure entire dimensions within a dynamic cube.
Attribute Security: You can now restrict user access to specific member attributes in a hierarchy.

  • Lookup Table-Based Security:

Security can now be implemented at the member level within a Dynamic Cube.
If security rules are stored in a relational database table, you can import the data source and use the lookup table in a security filter.

Note: A design change to the cube model (like adding new level to a hierarchy), will still require restarting the Dynamic Cube.

Implementing Enhanced Security on Lookup Tables

Lookup tables must contain the following:

  • User identity information (username, groups, or roles).
  • Data values corresponding to hierarchy level keys in the hierarchy.
  • (Optional) Additional columns to refine filtering based on scope and/or access type, for example, scopes like members, members and descendants, etc. and access types like grant or deny.

Lookup database table-based security can be implemented in following three steps:

1. Add the lookup table as a query subject in the Dynamic Cube model.

lookup table as query subject

2. Within a dimension hierarchy, match query items in the query subject to member keys in the level(s).

match member keys

3. Add a filter expression that serves as selection criteria for records in the lookup table. The filter express may contain session parameter macros like $account.personalInfo.userName.

filter expression

Implementing Role-Based Security

Role-based security in Dynamic Cubes can still be implemented in three steps. These steps are:

1. Create a member filter on a Dimension Hierarchy (grant or deny members with or without ancestors/descendants).

2. Create cube views on the security tab of the Dynamic Cube. Select which hierarchy filters to apply to the view, and which measures to grant or deny.

3. In Cognos Administration, under the data source connection, assign groups/roles/users to the cube view that you created in step.

You can combine lookup table-based and role-based security filters. For example, you can restrict access to finance data to the Finance user group by using a security view and then use IBM Cognos Administration to further restrict access for each finance team member in the lookup table for payroll data. Alternatively, you could restrict the view of a Dynamic Cube to the finance group in the portal, and then use the lookup table to grant/deny access to different areas of the hierarchy to individual member of finance team.

If you’d like to unlock the power of Dynamic Cubes in your Cognos environment, Ironside can help. In our IBM Cognos Dynamic Cubes course, our expert instructors equip you with all the fundamental and advanced insights required to make Dynamic Cubes fit seamlessly in your environment. Find a public course today or reach out and ask how you can schedule a private course for a group at your home location.

 

Tags: Business Analytics, Business Intelligence, Cognos, Dynamic Cubes, IBM, IBM Cognos, Metadata, Platform
Share this entry
  • Share on Twitter
https://www.ironsidegroup.com/wp-content/uploads/2014/02/Bodyguard-Resized.jpg 350 750 Ironside Group https://www.ironsidegroup.com/wp-content/uploads/2018/03/logo-with-words.png Ironside Group2014-02-03 19:18:092019-01-22 11:55:31Enhanced Security in IBM Cognos BI 10.2.1 Dynamic Cubes

See 3 reasons why AWS analytics are well within your reach.

Recent Posts

  • Why outsourcing can make all the difference when it comes to successful data and analytics transformation
  • What’s keeping mid-market companies from leveraging advanced analytics and AI in 2023?
  • Learn Why So Many Companies Are Turning to
    a Hub-and-Spoke Data Model
  • Data governance presents big challenges in the mid-market
  • Mid-market Leaders Report Back from the Road

Categories

  • Awards & Recognition
  • Business Analytics
  • Data Management
  • Data Science
  • Featured
  • Technology Spotlight
  • Uncategorized

Newsletter

Twitter feed is not available at the moment.

Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.

LINKS

  • Home
  • About
  • AWS Ascent Solutions
  • IBM Data Analytic Services
  • Resources
  • Blog
  • Careers
  • Contact

GET IN TOUCH

781-860-8840

GetInsights@IronsideGroup.com

Corporate Mailing Address
177 Huntington Ave Ste. 1703
PMB 89714
Boston, Massachusetts 02115-3153

131 Hartwell Ave
Lexington, MA 02421

Regional offices in Atlanta, Austin, Boston, Minneapolis, New York City, Orlando and Philadelphia

>>Managed Services Support

  • linkedin
  • twitter
  • youtube
  • mail
Also of Interest
  • Dynamic Cubes Archives
  • Ironside Webinar Series: Overview of...
  • IBM Cognos 10.2 Dynamic Cubes Overview
© 1999-2022 Ironside Group. All Rights Reserved.
IBM Cognos Dynamic Cubes for Existing PowerPlay Customersassembling cubes powerplay and dynamic cubes conceptman working on computerTop 5 Incentive Compensation Management Pain Points Solved
Scroll to top
Send this to a friend