Spreadsheet user-interfaced business data visualization and publishing system

• US 20060112123A1
• Filed: 09/08/2005
• Published: 05/25/2006
• Est. Priority Date: 11/24/2004
• Status: Abandoned Application

• Current Assignee: Macnica Incorporated
• Original Assignee: Macnica Incorporated
• Inventors: Clark, Kyle A., Heckenbach, Indra J.
• Application Number:
  US11/222,183
• Publication Number:
  US 20060112123A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A spreadsheet user-interfaced web-based business data publishing system allows users to input and visualize field data and analytical results with interactive charts through a familiar MS-EXCEL user interface. A plug-in module associated with the user'"'"'s browser and EXCEL application enables a background, web-services connection over the Internet to a management sub-system which extracts, transforms, and publishes data. Charts are customized using a WYSIWYG interface, and business dashboards are constructed through a simple drag-n-drop process. An account management system is included with access control to protect information security. The system is used for visualizing data managing reports, providing special tools to use SAP data, access Query Cubes in SAP BW, and standard and custom R/3 reports. Once data has been extracted from SAP, it is transformed, merged with other data sources, and published as a dashboard or in a business portal. Its management and configuration functions are suited for enterprise reporting and sharing business data.

Claims

1. A business system for data reporting and analysis, comprising:

a spreadsheet user interface located at a user site;

a web services API for supporting the spreadsheet user interface over the Internet; and

a business management system coupled to the web services API for collecting, analyzing, and publishing business data, and that allows users to visualize data using interactive charts, dashboards, and portals, and with a management system to extract, transform, and publish data, using intuitive wizards and menus, and including a transformation engine, which provides sophisticated data transforms through a menu interface, without relying on programming or scripting, and having a chart generation module to generate charts, graphs, and map graphics that can be customized using a WYSIWYG interface, and wherein business dashboards can be constructed through a drag-n-drop process, and further comprising an account management system with access control to protect information security.

2. The business system of claim 1, wherein:

the spreadsheet user interface includes a spreadsheet application program and a plug-in module for export and import of data and charts with the web services API.

3. The business system of claim 1, wherein:

the spreadsheet user interface includes an EXCEL spreadsheet application program and a plug-in module for export and import of data and charts with the web services API, such that a user can prepare data, publish data as charts and tables on web pages and dashboards, use data extractors, import data, and synchronize spreadsheet updates and dashboards.

4. The business system of claim 1, wherein the business management system further comprises:

a server-based extraction, transformation, and load (ETL) engine for extracting data from diverse sources including at least one of SAP BW, SAP Reports, SALESFORCE (SForce), SQL, XML, Excel, and plain text file sources, wherein data transforms are provides through a web-based menu interface and do not rely on programming or scripting, which can be expanded using a plug-in interface;

a client-based browser display for users to visualize said data, and to use interactive charts, dashboards, and portals;

intuitive wizards and menus in communication with a data management system for extracting, transforming, and publishing said data;

a POPCHART program to generate charts, graphs, and map graphics from said data;

a what-you-see-is-what-you-get (WYSIWYG) graphical user interface (GUI) for customizing said charts;

a drag-n-drop process for constructing business dashboards with access to said data;

a dashboard configuration system which supports any HTML template without modification;

a dashboard configuration system where web resources are available via WebDAV, where template and media changes are instantly shown in the published dashboard output; and

an account management system providing for user access control to protect information security related to said data.

5. The system of claim 1, further comprising:

an XE subsystem that provides for complex transformations which are defined on local system data, and that has been previously extracted from external data sources, and once source data is available, it is transformed, converted, formatted, or otherwise manipulated to a presentation form.

6. The system of claim 5, wherein:

The XE subsystem prepares data for presentation, and is not an analysis tool, and processes any number of XML definition files, e.g.,

<

xe>

<

transform name=“

x”

type=“

y”

>

<

label>

Sample Transform<

/label>

<

description>

Your average xform<

/description>

<

parameter/>

...<

parameter name=“

date-criteria”

type=“

date-criteria”

>

<

sql/>

<

/transform>

...<

/xe>

7. The system of claim 5, wherein:

The XE subsystem extends said data management system, and provides a model transform, which operates on an entire data model, and series transforms, which are defined for each series in a data model; and

a set of transform labels can be loaded into a system user interface (UI) to make transforms available to the user, and a user interface interprets parameter metadata and generates a configuration user interface, and users can save transform configuration such that compilations of transformative SQL are based on user configuration and SQL template in an XE control file, and thereby subsequent execution of an SQL will produce a transformation.

8. A spreadsheet interfaced business system for data reporting and analysis, comprising:

an EXCEL spreadsheet and user interface located at a user site;

a web services API for supporting the spreadsheet user interface over the Internet;

a business management system coupled to the web services API for collecting, analyzing, and publishing business data, and that allows users to visualize data using interactive charts, dashboards, and portals, and with a management system to extract, transform, and publish data, using intuitive wizards and menus, and including a transformation engine, which provides sophisticated data transforms through a menu interface, without relying on programming or scripting, and having a chart generation module to generate charts, graphs, and map graphics that can be customized using a WYSIWYG interface, and wherein business dashboards can be constructed through a drag-n-drop process, and further comprising an account management system with access control to protect information security; and

an EXCEL plug-in module that includes a publishing wizard to select EXCEL data and publish it through the business management system, an extractor interface to select data objects from the business management system and import them to EXCEL, and a synchronizer to update the business management system when the EXCEL data changes.