Ironside Group
  • Home
  • About
  • Ascent Solutions
  • Capabilities
  • 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
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

Recent Posts

  • Homer leverages Amazon QuickSight to help solve marketing challenges attached to digital privacy
  • Ironside’s smart, time-bound, and ROI-focused approach to AI
  • Modern Analytics Framework Series – Part 5: Our approach is as fluid as data itself
  • Modern Analytics Framework Series – Part 4: The value of an iterative approach
  • Modern Analytics Framework Series – Part 3: Creating Data as a Service (DaaS)

Categories

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

Newsletter

Ironside Follow

We make the world of business smarter. A trusted partner who turns data into valuable insights that drive positive business outcomes #Data #Analytics #AI #Cloud

IronsideGroup

Join us in welcoming our newest Solutions Architect, Praveen Kanniappa Sadasivan! Praveen joins Ironside with more than 18 years of experience in #DataArchitecture , #CloudArchitecture, #CloudMigration, #BigDataAnalytics & #DataScience across multiple industries.

Reply on Twitter 1542586172232310784 Retweet on Twitter 1542586172232310784 Like on Twitter 1542586172232310784 Twitter 1542586172232310784

Next week's Take30 on eight areas of the #HigherEducation Lifecycle features @IBM CTO of #Data & #AI Nick Holmes. Ironside & #IBM will dive into the ecosystem which influences student, educator, and institutional outcomes. #advancedanalytics
https://irns.de/3Olpipk

Reply on Twitter 1540404185912541184 Retweet on Twitter 1540404185912541184 Like on Twitter 1540404185912541184 Twitter 1540404185912541184

At the beginning of 2022, Chris Dedmon joined us as our new Channel Manager. Coming from our partner @PreciselyData with over 25 years of experience in #channel consulting and software sales, he has managed multiple initiatives driving growth and technical development.

Reply on Twitter 1539716871922094081 Retweet on Twitter 1539716871922094081 Like on Twitter 1539716871922094081 Twitter 1539716871922094081

On June 23rd, join our free #Cognos Lab Session w/ @motio_inc -- Ironside's De Hsieh will dive into the high expectations customers have for their user experience, report design and usability that comes in today’s app driven and self-service world.
https://irns.de/3tIt3Na

Reply on Twitter 1537875638950023171 Retweet on Twitter 1537875638950023171 Like on Twitter 1537875638950023171 Twitter 1537875638950023171

Next week! Join our partner @PreciselyData for #Trust22 to learn about trending topics in #dataintegrity and see what's new in their portfolio - June 21-22 - register here: https://irns.de/3y2eQxo

Reply on Twitter 1537866700472864769 Retweet on Twitter 1537866700472864769 Like on Twitter 1537866700472864769 Twitter 1537866700472864769

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
  • Ascent Solutions
  • Capabilities
  • 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

Regional offices in Boston, New York City, Philadelphia, Austin, and Cincinnati

>>Managed Services Support

  • linkedin
  • twitter
  • youtube
  • mail
© 1999-2021 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