HTML/DHTML web interface system and method

• US 7,174,349 B1
• Filed: 12/04/2003
• Issued: 02/06/2007
• Est. Priority Date: 06/20/2001
• Status: Expired due to Term

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Everhart, L. Douglas, Ramchandran, Ramkumar, Dector, Luis A., Oliver, Arturo, Brenes, Gunther L., Alavi, Ali
• Primary Examiner(s): Wu; Yicun
• Application Number:
  US10/726,624
• Time in Patent Office: 1,160 Days
• Field of Search: 707/2, 707/10, 707/104.1, 715/511, 715/523
• US Class Current: 1/1
• CPC Class Codes: G06F 16/34 Browsing; Visualisation therefor
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A web interface system and a method for use with a business information system are provided. The web interface system provides an interface to a user and comprises a first set of HTML interface tools located on a business intelligence server, the first set of HTML interface tools including spreadsheet tools, graphing tools, auto-prompt tools, and report generation and management tools. The web interface system additionally includes a second set of HTML interface tools located on a web server, the second set of HTML interface tools including navigation tools and internationalization tools. The web interface system also includes a communication link between the business intelligence server, the web server, and the user, such that the user is able to utilize the first set of HTML interface tools and the second set of HTML interface tools.

Claims

1. A web interface system for use with a business information system, the web interface system providing an interface to a client computer and comprising:

a first set of HTML interface tools located on a business intelligence server, the first set of HTML interface tools including spreadsheet tools, graphing tools, auto-prompt tools, and report management tools;

second set of HTML interface tools located on a web server, the second set of HTML interface tools including navigation tools and internationalization tools; and

means for providing communication between the business intelligence server, the web server, and the client computer, such that the client computer is able to utilize the first set of HTML interface tools and the second set of HTML interface tools.

2. The web interface system of claim 1, wherein the first set of HTML interface tools located on the business intelligence server obtains results through communication with a plurality of storage facilities.

3. The web interface system of claim 2, wherein the plurality of storage devices includes cache files, object data, and a data warehouse.

4. The web interface system of claim 1, wherein the auto-prompting tools comprise means for enabling a client to specify filtering criteria.

5. The web interface system of claim 1, wherein the auto-prompting tools additionally comprise DHTML tools.

6. The web interface system of claim 1, wherein the report management tools comprise means for enabling a client to specify the full report to be viewed.

7. The web interface system of claim 1, wherein the report management tools additionally comprise pull-down menus in HTML.

8. The web interface system of claim 1, wherein the report management tools comprise DHTML pivoting tools for enabling movement of attributes within an executed report.

9. The web interface system of claim 1, wherein the spreadsheet tools comprise pop-up menus for controlling drilling, outlining, sorting, and formatting options.

10. The web interface system of claim 1, further comprising additional HTML spreadsheet functions provided on the web server.

11. The web interface system of claim 1, wherein the graphing tools comprise means for generating a graph inside of the business intelligence server and creating a file for transmitting to the web server computer for conversion to HTML.

12. The web interface system of claim 1, wherein the internationalization tools comprise means for communicating in one of a plurality of languages.

13. The web interface system of claim 1, wherein the navigation tools comprise means for simultaneous display of toolbars, menus, and a grid on the client computer.

14. A method for providing a web interface for a client computer through the use of a web server and a business intelligence server, the method comprising the steps of:

loading a first set of HTML interface tools on the business intelligence server, the first set of HTML interface tools including spreadsheet tools, graphing tools, auto-prompt tools, and report management tools;

loading a second set of HTML interface tools located on the web server, the second set of HTML interface tools including navigation tools and internationalization tools; and

providing communication means between the business intelligence server, the web server, and the client computer, such that the client computer is able to utilize the first set of HTML interface tools and the second set of HTML interface tools.

15. The method of claim 14, further comprising the step of providing a plurality of storage devices for communication with the first set of HTML interface tools on the business intelligence server, wherein the plurality of storage devices includes cache files, object data, and a data warehouse.

16. The method of claim 14, wherein the step of loading the first set of HTML interface tools comprises loading DHTML auto-prompting tools having means for enabling a client to specify filtering criteria.

17. The method of claim 14, wherein the step of loading the first set of HTML interface tools comprises loading means for enabling a client to specify the full report to be viewed and means for providing pull-down menus in HTML.

18. The method claim 14, wherein the step of loading the first set of HTML interface tools comprises loading DHTML pivoting tools for enabling movement of attributes within an executed report.

19. The method of claim 14, wherein the step of loading the first set of HTML interface tools comprises loading pop-up menus for controlling drilling, outlining, sorting, and formatting options.

20. The method of claim 14, further comprising loading additional HTML spreadsheet functions provided on the web server.