Xiaohong Yang - Sammamish WA, US Luming Wang - Bellevue WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/30
US Classification:
707705, 707600, 707737
Abstract:
Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.
Maintaining Client Data Integrity In A Distributed Environment Using Asynchronous Data Submission
Jin Wang - Kirkland WA, US Luming Wang - Bellevue WA, US Malik Hussain - Woodinville WA, US Zaiwei Du - Bellevue WA, US Zhenyu Tang - Sammamish WA, US Patrick J. Baumgartner - Kirkland WA, US Mark Xiaohong Yang - Sammamish WA, US Peter Eberhardy - Seattle WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/30
US Classification:
707610, 707695
Abstract:
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.
Techniques To Manage Information For Dynamic Reports Using Time Periods For A Business Model
Patrick Baumgartner - Kirkland WA, US Alisson Sol - Cambridge, GB Peter Eberhardy - Seattle WA, US Luming Wang - Bellevue WA, US Mark Yang - Sammamish WA, US Amer Shahnawaz - Redmond WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06Q 40/00
US Classification:
705 8, 705 7, 705 10, 705 35, 705 36, 705 37
Abstract:
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.
Method For Capturing Design-Time And Run-Time Formulas Associated With A Cell
Alisson A. S. Sol - Cambridge, GB Luming Wang - Bellevue WA, US Xiaohong Mark Yang - Sammamish WA, US Patrick J. Baumgartner - Pullman WA, US Peter Eberhardy - Seattle WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/00 G06F 17/20 G06F 17/21
US Classification:
715212, 715215, 715222
Abstract:
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.
Luming Wang - Bellevue WA, US Xiaohong Yang - Sammamish WA, US Hailei Zhang - Sammamish WA, US Sonal Jain - Bothell WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 7/00 G06F 17/30
US Classification:
707705, 707709, 707710
Abstract:
An object oriented search mechanism extracts structural metadata and data based on type of document contents and data sources connected to the documents. Relationships between textual and non-textual elements within documents as well as metadata associated with the elements and data sources are utilized to generate a unified object model with the addition of semantic information derived from metadata and taxonomy, which are used to enhance search indexing, ranking of search results, and dynamic adjustment of result rendering user interface with fine tuned relevancy. Additional data from data sources connected to the documents may also be used to unlock hidden data such as data that has been filtered out in an original document.
Maintaining Client Data Integrity In A Distributed Environment Using Asynchronous Data Submission
Jin Wang - Kirkland WA, US Luming Wang - Bellevue WA, US Malik Hussain - Woodinville WA, US Zaiwei Du - Bellevue WA, US Zhenyu Tang - Sammamish WA, US Patrick J. Baumgartner - Kirkland WA, US Mark Xiaohong Yang - Sammamish WA, US Peter Eberhardy - Seattle WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/30
US Classification:
707610, 707695
Abstract:
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.
Indexing And Searching Employing Virtual Documents
Luming Wang - Bellevue WA, US Xiaohong Yang - Sammamish WA, US Anton Amirov - Redmond WA, US Pablo Barvo - Bothell WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/30
US Classification:
707709
Abstract:
Relationships between linked and/or embedded documents as well as documents sharing data source(s) are captured and rendered through virtual documents. Virtual documents are created representing linked/embedded documents and data sources associated with a relevant document. Relationships between real and virtual documents are preserved and rendered along with search results providing a user a comprehensive picture of search results.
Jason L. Malcolm - Kent WA, US Patrick J. Baumgartner - Kirkland WA, US Luming Wang - Bellevue WA, US Xiaohong Yang - Sammamish WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 3/048
US Classification:
715764
Abstract:
A user interface displays a group of related documents such that bulk operations may be performed on them without requiring the user to individually access each document to perform an action. Properties, such as a status, contributor information, submission date and submission deadline and the like are also displayed with the documents. From this information, a user may decide to open a specific document and/or version of the document for review while bulk approving the other displayed documents. A user may perform an action on all or part of the displayed documents and their versions from the user interface. In this way, the efficiency of the workflow may be increased since the user doesn't have to individually access each document to perform the action.