Report Write-Back Module for Dynamic Data Collection

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current Business Intelligence (BI) solutions lack the capability to dynamically obtain data from users interacting with personalized reports and write back this data to a data source, without proper authorization, limiting the analysis of user interactions and report usage.

Innovation Solution

A computer-readable medium with executable instructions integrates a write-back module in report documents, allowing for the publication of reports with metadata identifying recipients, and updating data sources based on received write-back information, including originator metadata for secure and personalized data updates.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If a report document is published to multiple recipients with personalized data, then the report customization and distribution capability is improved, but the ability to collect and write back user interaction data to the data source is lost

Engineering Contradiction:
Improvereport customization capabilityVSAvoiduser interaction data collection
Core Design Contradiction:
Adaptability or versatilityVSLoss of information

Solution Approach 1:

The patent implements a feedback mechanism where user interactions with personalized reports are automatically captured and written back to the data source. The system monitors user actions (views, exports, drills-downs) and feeds this interaction data back to update the data source, creating a closed-loop system that maintains both report customization and data collection capabilities.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The patent introduces an intermediary component (publishing module with write-back capability) that sits between the report distribution system and the data source. This intermediary captures user interaction data from distributed reports and facilitates the write-back operation to the data source, enabling data collection without compromising report personalization.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Productivity

If user interaction data is collected from report recipients, then the analysis capability is improved, but the system complexity and authorization requirements increase

Engineering Contradiction:
Improvedata analysis capabilityVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent makes the publishing module multi-functional by combining report distribution, user interaction monitoring, data capture, and write-back operations into a single unified component. This universal module handles both the distribution of personalized reports and the collection/write-back of interaction data, reducing overall system complexity despite the enhanced analytical capabilities.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system implements self-service functionality where the publishing module automatically performs data collection and write-back operations without requiring manual intervention. The module autonomously monitors user interactions, captures relevant data, and executes write-back operations to the data source, simplifying the system architecture while maintaining advanced analytical capabilities.

Inventive Principle:
Principle #25Self-service

3Adaptability or versatility

If write-back functionality is added to published reports, then the dynamic data update capability is improved, but the security and authorization control requirements worsen

Engineering Contradiction:
Improvedynamic data update capabilityVSAvoidauthorization control
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The patent implements preliminary authorization control by establishing security rules and authorization mechanisms before the write-back operation occurs. The system pre-configures which users are authorized to trigger write-back operations and defines the scope of data that can be written back, ensuring security and reliability are maintained while enabling dynamic data update capabilities.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS8180795B2Apparatus and method for distribution of a report with dynamic write-back to a data source
Publication Date: 2012.05.15 SAP IRELAND LTD
  • US8180795B2 patent drawing
  • US8180795B2 patent drawing
  • US8180795B2 patent drawing

AI summary

A computer readable medium includes executable instructions to integrate a write-back module in a report document, to publish to a recipient the report document and metadata identifying the recipient, and to update a data source based on received write-back information, including the metadata identifying the recipient.