Patent application number | Description | Published |
20080221958 | Techniques to manage information for dynamic reports using time periods for a business model - Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed. | 09-11-2008 |
20080255974 | Techniques to manage financial performance data exchange with standard taxonomies - Techniques to manage financial performance data are described. An apparatus may include an online analytical processing database with a multidimensional data model, and a business information exchange module communicatively coupled to the online analytical processing database. The business information exchange module may import a taxonomy to the multidimensional data model, create a business model using the multidimensional data model, and export financial data from the business model to an extensible business reporting language instance document. Other embodiments are described and claimed. | 10-16-2008 |
20080256122 | Time intelligence for application programs - Techniques to implement time intelligence for application program are described. An apparatus may include a calendar application module. The calendar application module may be arranged to define and generate a calendar for an application program, the calendar application module to define time members for a time dimension of a multidimensional data model, assign a monotonically increasing unique identifier to each time member, and generate the calendar with time members from the time dimension using the unique identifiers. Other embodiments are described and claimed. | 10-16-2008 |
20090006301 | MULTI-PLATFORM BUSINESS CALCULATION RULE LANGUAGE AND EXECUTION ENVIRONMENT - Computer-readable storage media, computer-implemented methods, and systems are disclosed for a multi-platform calculation rule language and its environment. A calculation rule, presented in an expression language and specifying one or more functions, is received. The expression language, for a plurality of different platforms, allows each of a plurality of functions to be expressed using a common syntax. A selected platform is identified on which the calculation rule is to be executed. The calculation rule is resolved to the attributes of the data model in the selected platform to apply the calculation rule to the data model. The calculation rule is executed by performing the one or more functions specified in the calculation rule, and the results from executing the calculation rule are reported. | 01-01-2009 |
20090006370 | ADVANCED TECHNIQUES FOR SQL GENERATION OF PERFORMANCEPOINT BUSINESS RULES - Computer-implemented methods and computer-readable storage media are disclosed to facilitate the application of business rules. A rule is received, the rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result. At least one database query is generated seeking the specified data to be retrieved from the multidimensional database. An intermediary table is created to accommodate the specified data retrieved from the multidimensional database. The specified data is stored in the intermediary table and the specified data is manipulated when the data is retrieved or after the specified data is stored in the intermediary table. | 01-01-2009 |
20090210422 | Secure Database Access - Secure database access may be provided. First, a first schema associated with a database having a second schema may be defined. Next, a user type may be defined. The user type may comprise a user type that does not require a log-in. The defined user type may then be associated with the defined first schema. Next, at least one permission may be granted to the user type to the database on a database level. The at least one permission may comprise a create procedure permission, a create table permission, or a create function permission. Then permission to the second schema may be denied to the user type. Next, a procedure may be received comprising a procedure that poses a high security risk to the database. The received procedure may then be executed as the defined user type. The received procedure may be executed using a wrapper procedure. | 08-20-2009 |
20090287704 | CELL-BASED SECURITY REPRESENTATION FOR DATA ACCESS - 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. | 11-19-2009 |
20090292730 | SPREADSHEET FORMULA TRANSLATION OF SERVER CALCULATION RULES - Architecture includes for translating server calculations into client application formulas. The architecture determines dependencies, performs formulae translation, and processes data retrieval queries using the translated formulae. In one implementation, the architecture translates performance management server calculations into spreadsheet application formulas so that the impact of changes can be reflected immediately. Moreover, this technique does not require updating and querying of the performance management server. An algorithm is provided that allows translation of the backend formula (e.g., MDX—multidimensional expressions) directly into the spreadsheet application such that the impact on calculated values by an input change can be reflected instantaneously in the sheet. | 11-26-2009 |