BUSINESS INTELLIGENCE AND REPORT STORYBOARDING

• US 20120117089A1
• Filed: 02/23/2011
• Published: 05/10/2012
• Est. Priority Date: 11/08/2010
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Netz, Amir M., Matrat, Olivier Lionel, D'Hers, Thierry J., Rowlett, Stella Chan, Muti, Riccardo E.
• Application Number:
  US13/033,505
• Publication Number:
  US 20120117089A1
• Time in Patent Office: Days
• US Class Current: 707/752
• CPC Class Codes: G06F 16/338 Presentation of query results
• CPC Class Codes: G06F 16/9038 Presentation of query results
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

Embodiments are directed to organizing reporting data from various sources such as frames into a storyboard view with additional metadata that is specific to the storyboard and to sharing and/or exporting a storyboard sequence of reporting frames. In an embodiment, a computer system accesses various portions of reporting data. The reporting data includes source data, relevant data states and metadata describing properties of the associated report. The computer system organizes the reporting data into multiple reporting frames according to various organizing criteria. Each reporting frame is incorporated into a storyboard interface. The computer system also displays the storyboard interface which includes each of the reporting frames organized according the organizing criteria.

Claims

1. At a computer system including at least one processor and a memory, in a computer networking environment including a plurality of computing systems, a computer-implemented method for organizing reporting data into a storyboard view, the method comprising:

an act of accessing one or more portions of reporting data, wherein the reporting data includes source data, relevant data states and metadata describing properties of the associated report;

an act of organizing the reporting data into a plurality of reporting frames according to one or more organizing criteria, wherein each reporting frame is incorporated into a storyboard interface; and

an act of displaying the storyboard interface, wherein the interface includes each of the reporting frames organized according the one or more organizing criteria.

2. The method of claim 1, wherein the reporting frames include one or more of the following:

a name, a unique identifier, a timestamp, metadata, a report definition, a reference to a report definition and author information.

3. The method of claim 1, wherein the storyboard comprises a sequence of individual reporting frames.

4. The method of claim 1, further comprising sharing the storyboard with a plurality of other computer users.

5. The method of claim 4, wherein the storyboard is shared over at least one of the following:

the internet, an intranet, a file-collaboration application and a file-sharing application.

6. The method of claim 1, wherein the storyboard interface allows users to add different reporting frames that represent at least one of the following:

different reports with their state, the same report in different states, or a combination of different reports with their state and the same report in different states.

7. The method of claim 1, wherein the storyboard interface is interactive, allowing users to dynamically add, delete and edit reporting frames.

8. The method of claim 1, wherein the storyboard interface is configured to show multiple different views of the same or different data from the same or different source reports.

9. The method of claim 1, wherein one or more portions of metadata are shown in different parts of the reporting frame, and wherein the metadata comprises at least one of reporting frame author, reporting frame sequence and reporting frame annotations.

10. The method of claim 1, wherein the storyboard interface shows a static snapshot of each reporting frame that was taken at one of the following times:

at the time the frame was added to the storyboard, or at the time the frame was last edited.

11. The method of claim 1, further comprising exporting the storyboard to a target format.

12. The method of claim 10, wherein frame sequence and corresponding frame information is preserved during exporting.

13. A computer program product for implementing a method for exporting a storyboard sequence of reporting frames, the computer program product comprising one or more computer-readable storage media having stored thereon computer-executable instructions that, when executed by one or more processors of the computing system, cause the computing system to perform the method, the method comprising:

an act of accessing one or more portions of reporting data, wherein the reporting data includes source data, relevant data states and metadata describing properties of the associated report;

an act of organizing the reporting data into a plurality of reporting frames according to one or more organizing criteria, wherein each reporting frame is incorporated into a storyboard; and

an act of exporting the storyboard to a user-specified target format, wherein frame sequence and corresponding frame information is preserved during exporting.

14. The computer program product of claim 13, further comprising displaying the storyboard interface, wherein the interface includes each of the reporting frames organized according to one or more organizing criteria.

15. The computer program product of claim 13, wherein one or more application programming interfaces (API'"'"'s) are provided for storing the storyboard in the various different target formats.

16. The computer program product of claim 13, wherein each component of each reporting frame is separately storable and separately accessible.

17. The computer program product of claim 16, wherein each of the reporting frame components is stored and represented in a relational model.

18. A computer system comprising the following:

one or more processors;

system memory;

one or more computer-readable storage media having stored thereon computer-executable instructions that, when executed by the one or more processors, causes the computing system to perform a method for organizing reporting data into a storyboard view, the method comprising the following;

an act of accessing one or more portions of reporting data, wherein the reporting data includes source data, relevant data states and metadata describing properties of the associated report;

an act of organizing the reporting data into a plurality of reporting frames according to one or more organizing criteria, wherein each reporting frame is incorporated into a storyboard;

an act of exporting the storyboard to a user-specified target format, wherein frame sequence and corresponding frame information is preserved during exporting; and

displaying the storyboard interface, wherein the interface includes each of the reporting frames organized according the one or more organizing criteria.

19. The system of claim 18, wherein the storyboard interface allows users to add reporting frames that represent different reports.

20. The system of claim 18, wherein the storyboard interface is interactive, allowing users to dynamically add, delete and edit reporting frames.