Microstrategy, Inc.

William Hurwood

Benjamin Z Li

Jeffrey A Bedell

Abhimanyu Warikoo

Jun Yuan

Sadanand Sahasrabudhe

Fabrice Martin

Ramkumar Ramachandran

Scott Cappiello

L Douglas Everhart

Steven S Trundle

Xinyi Wang

Eduardo Carranza

David B Sherwood

Stephen Scott Trundle

Michael Jerry Saylor

Luis V Orozco

Glenn J Boysko

Michael Codini

Ashutosh K Jhaveri

Kyle N Yost

Ananya Ojha

Xun Feng

Wenfeng Li

Ningning Liu

Chris Richardson

Rodolfo Avalos

Arturo Gay

Alejandro Freixas

Barry R Lovalvo

Gaurav Rewari

Raul Gonzalez

Methods, systems, and apparatus, including computer programs encoded on computer-storage media, for generating structured query language using machine learning. In some implementations, a system provides an interface configured to receive input comprising data processing criteria expressed in natural language text. The system receives natural language input through the interface, where the natural language input specifies one or more criteria for retrieving or generating data from a data set. The system obtains a structured query language (SQL) statement generated by an artificial intelligence or machine learning (AI/ML) model based on the natural language input, and the system provides the SQL statement through the interface.

Generating structured query language using machine learning

A technique for exporting results from a reporting system report in a format type including a datamart, PDF file, flat file, Excel&#x2122; file, HTML file, and XML file or in another relational database management system (RDBMS) format. In one embodiment, the technique is realized through a method and a system for automatically exporting results from a business intelligence, OLAP, or other reporting system. One embodiment of the present invention involves a method of enabling a user to designate a report desired for execution as an export-report. When the report is processed, the report is exported into a datamart or other format and made available for access by the user through one or more different types of user devices. The user may then further manipulate or export the results from the datamart to a file type as desired.

System and method for exporting report results from a reporting system

A system and method for facilitating the performance of administrator tasks in performing changes to enterprise level data that is associated with various users. The method includes the steps of generating a login dialog box to accept login information from an administrator; establishing a connection to at least one project source name; providing an outline to the administrator, the outline facilitating the creation and submission of command based instruction by providing syntax for a purpose, the outline being maintained in a predetermined folder; and providing a history feature to save a set instructions that were executed successfully.

Systems and methods for performing operations in a reporting system

The present invention presents security and user account integration with remote authentication servers, (e.g., repositories not owned by the server). Integration may occur with Lightweight Directory Access Protocol (LDAP), an operating system (e.g., Microsoft Windows&#x2122; NT&#x2122;) authentication, custom account repositories and others. For example, the server may synchronize associated user lists with a remote repository. In another example, the server may also make external calls to remote authentication servers to validate a user's username and password. Other information may be validated.

Method and system for security and user account integration by reporting systems with remote repositories

Systems and methods are provided for filtering data in a database using an execution plan. The execution plan has a first processing pass against the database that calculates a filter set using a filter criteria, and a second processing pass against the filter set that calculates a report result.

Systems and methods for set filtering of data

An reporting system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A collection of answers is built up in a resolution object. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A resolution object may be created and saved before the execution of a report. The saved resolution object can then be used to answer prompts at the time of the report execution. The resolution object may be created by third parties and transmitted as an XML resolution object, whereupon receipt by the reporting system, the XML resolution object is translated into a reporting system format.

Report system and method using prompt object abstraction

A reporting system that incorporates a context sensitive prompt object in a report definition to enable questions to be answered automatically by the reporting system (e.g., decision support system, business intelligence and OLAP) at report execution time. The context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports. The answer is defined at least in part by a contextual feature of the report execution.

Report system and method using context-sensitive prompt objects

An report system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system (e.g., decision support system, business intelligence and OLAP) report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report.

Report system and method using prompt objects

A reporting system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A collection of answers is built up in a resolution object. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A resolution object may be created and saved before the execution of a report. The saved resolution object can then be used to answer prompts at the time of the report execution. The resolution object may be created by third parties and transmitted as an XML resolution object, whereupon receipt by the reporting system, the XML resolution object is translated into a reporting system format.

A system and method for manipulating objects between related projects. Dependencies between object are checked as objects are moved between projects. The dependency review enables all dependent object to be copied simultaneously. The system and method facilitates the management of multiple stages of a project by permitting as object and all of its modified dependents to be easily copied from one stage to another.

System and method for managing objects between projects

A system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set. A method and medium having processor readable code therein are also described.

System and method for efficient date retrieval and processing

Security filters that manage user access to data based on user identification and other data when a user attempts to access information via a query or other mechanisms. Security filters may be implemented to prevent users from viewing or otherwise accessing certain data in a database or other source of information in a reporting or other system. The level of access authorized by a security filter may be based on a user's role, capabilities, or other criteria. For example, a regional manager may have a security filter that allows a user to view data from the user's particular region regardless of the report the user runs. A security filter may include a filter expression, a top level and a bottom level where each component may be further define a user's ability to access certain data.

Method and system for implementing security filters for reporting systems

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.

System and method for run-time report resolution of reports that include prompt objects

A system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system, decision support system, business intelligence and OLAP report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A prompt object may also contain another prompt object nested within it, in which the answer to an inner prompt object is used by the system to validate the answer to an outer prompt object.

Report system and method using prompt in prompt objects

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.

Growing community of inventors

Washington, DC, United States of America

William Hurwood