Patent application number | Description | Published |
20080201309 | RENDERING DATABASE QUERIES WITH BLANK SPACE - A computer-implemented method includes selecting a first member of a first dimension of a database to be included at a first location in a report. The first member includes first data to be retrieved from the database. A blank space to be added at a second location relative to the first member is also selected. A database query is generated that includes a first instruction to retrieve first data included in the first member. The first instruction is located at a first position in the query and the first data will appear in the report at the first location. The database query also includes a second instruction to retrieve a null set of data. The second instruction is located at a second position in the query and the null set of data will appear in the report at the second location | 08-21-2008 |
20080208874 | Handling multi-dimensional data including writeback data - Embodiments are provided to use metadata to provide readable and/or writeable regions of a multi-dimensional space. In an embodiment, metadata can be used to define readable and/or writeable regions of a multi-dimensional data store. The various embodiments also use relational and/or multi-dimensional representations to resolve and validate readable and/or writeable regions of a multi-dimensional space. Metadata can also be used to in conjunction with writeback operations. | 08-28-2008 |
20080208880 | Extended cell information in multidimensional data models - Sharable extended cell information is used by multidimensional data models to enable cell annotations and line item details. Annotations are notes stored with a cell in a multidimensional dataset. Line item details permit levels of numeric detail below the lowest dimensional granularity. When receiving a multidimensional dataset in response to a query, a client application receives indicator information at the cell level, indicating to the client application that extended cell information is retrievable. | 08-28-2008 |
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 |
20090113283 | METHOD FOR CAPTURING DESIGN-TIME AND RUN-TIME FORMULAS ASSOCIATED WITH A CELL - An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result. | 04-30-2009 |
20090300048 | SELECTING MEMBER SETS FOR GENERATING ASYMMETRIC QUERIES - Tools and techniques are described for selecting member sets for generating asymmetric queries. User interfaces provided by this description may include representations of different dimensions that include respective members. These dimensions define hierarchical data structures against which queries are run to generate requested reports. The user interfaces may include representations of members associated with different dimensions, with members from different dimensions arranged in selected orders. The user interfaces may also provide selection tools that activate symmetrical or asymmetrical rendering modes for constructing the query. In the symmetrical rendering mode, the query cross-joins all of the members selected from one dimension with all of the members selected from the other dimension. In the asymmetrical rendering mode, the query cross-joins the first-ordered member from one dimension with the first-ordered member from another dimension, cross-joins the second member from one dimension with the second member from another dimension, and so on. | 12-03-2009 |
20100125471 | FINANCIAL JOURNALS IN FINANCIAL MODELS OF PERFORMANCE SERVERS - Architecture that employs a journal assignment that can be created on demand when journal is created, and operates outside the business cycle. The assignment is routed to reviewers and approvers based on predefined company policy that users define. The assignment encloses a changelist of data changes created by the journal. The changelist is used for rendition and calculation for reviewers and approvers (in addition to the journal contributor) to view/verify and modify the data as if the data is already written into the model. At the time that other users access this model, the data is not present. At the end of the successful workflow chain the changelist is written into the model. If failed, the changelist will be used as that basis for correction or the user can discard the changelist. | 05-20-2010 |
20100125549 | MAINTAINING CLIENT DATA INTEGRITY IN A DISTRIBUTED ENVIRONMENT USING ASYNCHRONOUS DATA SUBMISSION - Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage. | 05-20-2010 |
20100293449 | METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT - Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member. | 11-18-2010 |
20120254104 | MAINTAINING CLIENT DATA INTEGRITY IN A DISTRIBUTED ENVIRONMENT USING ASYNCHRONOUS DATA SUBMISSION - Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage. | 10-04-2012 |
20130103770 | DISTRIBUTED SEMI-SYNCHRONIZED EVENT DRIVEN PLAYBACK OF MULTIMEDIA - A system is provided for enabling attendees of an online broadcast within a collaborative environment to interact with multimedia content during the online broadcast. By rendering the content itself instead of images derived from the content that cannot be interacted with, attendees are enabled to either drive their own multimedia experience, including play, seek, pause/stop, or follow the presenter and consume the multimedia based on the presenter's action (play, pause, stop, seek). The multimedia content may be rendered on each attendee's individual client device through local caching, which contributes to playback quality such that each individual attendee may be able to interact with and control the playback experience of the multimedia content independently. | 04-25-2013 |
20130290823 | METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT - Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member. | 10-31-2013 |
20130303190 | REQUESTING A LOCATION OF A USER - A user sends a location request to a user of a group that requests the user's current location. For example, one family member may send a location request to another family member that is part of their family group for their current location. The user receiving the request may accept the location request or reject the location request. When the location request is reject, the requesting user is not provided with the current location information of the user. When the location request is accepted, the requesting user is provided with the current location information of the user. In addition to providing the location information to the requesting user, the location may also be shared with other members of the group. For example, a message may be sent to each of the family members that are part of the group that informs them that a member has updated their location. | 11-14-2013 |