Patent ID: 7617211
Filing Date: 2009-11-10
Classification: G06F,Y10S

Abstract:
1. A method for managing access security to a ROLAP system and a MOLAP system that share a subset of common data, the method comprising: defining on a computer comprising a processor and memory a security table for a ROLAP system, the security table comprising a userID column, a data group column defining a security profile, and a profile column; defining on the computer an OLAP cube description table comprising, for one or more cubes in the MOLAP, a minimum user security definition for user access to the one or more cubes in the MOLAP; defining on the computer an OLAP cube profile description table comprising, for the one or more cubes in the MOLAP, one or more access profiles; joining the security table, the OLAP cube description table, and the OLAP cube profile description table to autonomously generate a MOLAP security definition consistent with a ROLAP security definition.