Abstract: Architecture for cell-based security on a per-user basis. A security model for this capability includes not only dimension level tables, but is extended to include cell level tables. The security model can include existing dimension tables, plus cell security tables that include a cell permissions table, a cell qualifiers table and a table that includes both the cell permissions table, a cell qualifiers. Metadata associated with the security applied to the cells for a given user can be stored locally in a local metadata store for retrieval and application against a data cube that an authenticated and authorized user is querying. In a specific implementation, the cell level security is employed in a performance management server application, where authentication is performed remotely by an authentication service, but the authorization function is performed local to the performance management server application.

Abstract: The present invention provides an architecture for obtaining an analytical view of data. The invention includes a model service component for receiving an indication of a first object model and generating a dimensional model and a second object model from the first object model. The second object model is analytical in that it preserves relationships identified in the dimensional model, but allows the user to obtain information in terms of objects instead of specifying the data in terms of the dimensional model. The architecture also includes a navigational component that allows a user to navigate from the second object model to underlying data represented by the first object model.

Abstract: Architecture for cell-based security on a per-user basis. A security model for this capability includes not only dimension level tables, but is extended to include cell level tables. The security model can include existing dimension tables, plus cell security tables that include a cell permissions table, a cell qualifiers table and a table that includes both the cell permissions table, a cell qualifiers. Metadata associated with the security applied to the cells for a given user can be stored locally in a local metadata store for retrieval and application against a data cube that an authenticated and authorized user is querying. In a specific implementation, the cell level security is employed in a performance management server application, where authentication is performed remotely by an authentication service, but the authorization function is performed local to the performance management server application.

Abstract: The present invention provides an architecture for obtaining an analytical view of data. The invention includes a model service component for receiving an indication of a first object model and generating a dimensional model and a second object model from the first object model. The second object model is analytical in that it preserves relationships identified in the dimensional model, but allows the user to obtain information in terms of objects instead of specifying the data in terms of the dimensional model. The architecture also includes a navigational component that allows a user to navigate from the second object model to underlying data represented by the first object model.

Abstract: The present invention provides an architecture for obtaining an analytical view of data. The invention includes a model service component for receiving an indication of a first object model and generating a dimensional model and a second object model from the first object model. The second object model is analytical in that it preserves relationships identified in the dimensional model, but allows the user to obtain information in terms of objects instead of specifying the data in terms of the dimensional model. The architecture also includes a navigational component that allows a user to navigate from the second object model to underlying data represented by the first object model.

Abstract: A system is provided for enabling a user to extract useful information from a collection of business data. Relationships that connect various data elements are analyzed in order to identify intelligent data navigation paths. The intelligent data navigation paths are utilized as a basis for enabling the user to move between related sets of data.

Abstract: The present invention automatically generates an object model from a dimensional model. The object model can then be queried using object oriented expressions.