Jeffrey A Bedell, 563142 18Th St N, Arlington, VA 22201

6801910, Oct 5, 2004

Jun 19, 2001

09/883505

Jeffrey A. Bedell - Arlington VA
Scott Cappiello - Arlington VA
L. Douglas Everhart - Arlington VA
William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Fabrice Martin - Washington DC
David B. Sherwood - McLean VA
Steven S. Trundle - Falls Church VA

MicroStrategy, Incorporated - McLean VA

G06F 1730

707 6, 707 2, 707 5, 715514, 715902, 715907

A method and system for guiding drilling into a report are disclosed. Through the use of the invention, a user can drill within a first report dimension or from the first report dimension into a second report dimension. Additionally, a drill map providing a plurality of drilling paths is associated with each report. The system of the invention includes drill transformation tools and drill map management tools for assisting a user in navigating through report instances.

6820073, Nov 16, 2004

Mar 20, 2002

10/101488

Jeffrey A. Bedell - Arlington VA
William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Sadanand Sahasrabudhe - McLean VA
Xinyi Wang - Herndon VA
Jun Yuan - Sterling VA

MicroStrategy Inc. - McLean VA

G06F 1730

707 2, 707 3, 707 4, 707 10, 709203

A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

6859798, Feb 22, 2005

Jun 20, 2001

09/884472

Jeffrey A. Bedell - Arlington VA, US
Benjamin Z. Li - Great Falls VA, US
Luis V. Orozco - Vienna VA, US
Ramkumar Ramachandran - Reston VA, US
Michael J. Saylor - Great Falls VA, US
Stephen S. Trundle - Falls Church VA, US

MicroStrategy, Inc. - McLean VA

G06F015/18

706 45, 707 10

An intelligence server for a reporting system is disclosed. The reporting system may include a report initiation module, such as a user engine or calling application, for generating a request for a report. The intelligence server includes a server layer for receiving the generated request and for coordinating a flow of a processing of the received request; an application logic layer which includes business intelligence rules used for generating the report; and an analytical layer, in communication with the user engine and the server layer, for receiving the request to be processed from the server layer, transmitting the processed request to one or more data storage devices, and for extracting data from the data storage devices responsive to the transmitted request. The extracted data is then processed by the applications in the application logic layer to generate the report and the processing is independent of a user interface.

6996568, Feb 7, 2006

Apr 11, 2002

10/120144

Jeffrey A. Bedell - Arlington VA, US
William Hurwood - Washington DC, US
Benjamin Z. Li - Great Falls VA, US
Fabrice Martin - Washington DC, US
Sadanand Sahasrabudhe - McLean VA, US
Jun Yuan - Sterling VA, US

MicroStrategy Incorporated - McLean VA

G06F 17/30

707100, 707 3, 707102, 715500

A system and method for defining and using logical extensions to a set of data stored in a relational database. A metadata definition for various extensions is stored to explain how to extend data as it is stored into a logical representation suitable for reporting and calculating purposes. An analytical engine translates report requests into SQL queries to access the physically stored data using the metadata extension definitions if necessary to generate appropriate results. Here, data is stored in at least one table that is physically keyed by a set of attributes with the attribute determining the granularity or level of data contained within the tables. A report request causes the engine to calculate and/or display the data at a lower level of granularity than exists, thereby invoking the metadata definitions. The extension definitions may describe how to extend data from the physical to the logical including joins and allocation rules.

6996569, Feb 7, 2006

Apr 11, 2002

10/120192

Jeffrey A. Bedell - Arlington VA, US
Xun Feng - Sterling VA, US
William Hurwood - Washington DC, US
Ashutosh K. Jhaveri - San Francisco CA, US
Benjamin Z. Li - Great Falls VA, US
Xinyi Wang - Herndon VA, US
Jun Yuan - Sterling VA, US

MicroStrategy Incorporated - McLean VA

G06F 17/30

707100, 707102, 707103 R

A system and method for creating a custom grouping of data in a database. A custom group object is created, a plurality of custom group elements are defined, each of the custom group elements being a subset of the custom group object and being defined by a different filter, each one of the different filters representing a logical expression of qualifications based on the data or a derived calculation of the data. Each of the different filters is resolved against the data or a subset of the data, and the plurality of custom group elements are grouped into a consolidated result set which in not naturally existing in the data structure.

7003512, Feb 21, 2006

Aug 6, 2004

10/912174

Jeffrey A. Bedell - Arlington VA, US
William Hurwood - Washington DC, US
Benjamin Z. Li - Great Falls VA, US
Sadanand Sahasrabudhe - McLean VA, US
Xinyi Wang - Herndon VA, US
Jun Yuan - Sterling VA, US

MicroStrategy, Inc. - McLean VA

G06F 17/30

707 3, 707 2, 707 4, 707 5, 707 10, 709201, 709203

A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

7010518, Mar 7, 2006

Jun 20, 2001

09/884476

Jeffrey A. Bedell - Arlington VA, US
William Hurwood - Washington DC, US
Benjamin Z. Li - Great Falls VA, US
Fabrice Martin - Washington DC, US
Sadanand Sahasrabudhe - McLean VA, US
Jun Yuan - Sterling VA, US

MicroStrategy, Inc. - McLean VA

G06F 17/30

707 3, 707 10, 707103 R, 709218, 709219, 715513

The invention provides a configuration tool to allow a user to build a custom-selected data object hierarchy, for business intelligence or other purposes. Under conventional data storage technologies, the physical layout of the disk drive or other media has dictated what logical views and searches a user could run on the underlying data. For instance, levels could not be readily skipped or many-to-many data object relationships were difficult to maintain. In the invention, a user may select and connect a set of data objects into a hierarchy of their choosing, to permit desired reports and other manipulations on the data to be performed. The hierarchy may be edited, and entry points may be defined. Different levels of security may be applied to the different levels of the hierarchy. Multiple hierarchies or representations may be built for one database or other data source.

7356758, Apr 8, 2008

Jun 19, 2001

09/883501

Jeffrey A. Bedell - Arlington VA, US
Eduardo Carranza - Fairfax VA, US
L. Douglas Everhart - Arlington VA, US
William Hurwood - Washington DC, US
Benjamin Z. Li - Great Falls VA, US
Ramkumar Ramachandran - Reston VA, US
David B. Sherwood - McLean VA, US
Steven S. Trundle - Falls Church VA, US
Abhimanyu Warikoo - New York NY, US

Microstrategy Incorporated - McLean VA

G06F 15/00
G06F 17/00

715200, 707 4

A report resolution system that includes prompt objects used to define every aspect of a report and specifically an object-prompt object. To resolve a report with prompt objects, a report instance is created and passed to a resolution server that collects the prompt objects contained therein to create a resolution object that includes the prompt questions from the prompt objects. A report server raises an event to prompt the user to respond to the questions in the resolution object.