Report Template Selection System for BI Cost Optimization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Business Intelligence customers face difficulties in determining the optimal subset of report templates to purchase or implement due to complexity in pricing and implementation costs, especially when considering inter-report template dependencies and synergies, making it challenging to select the right set of reports that meet their specific needs.

Innovation Solution

A computer-readable medium with executable instructions processes metadata associated with a set of report templates to select a subset that maximizes a reporting objective, using iterative or global selection processes, and optimized search methods to identify the optimal subset of report templates based on customer-specific parameters and selection rules.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If customers consider all report templates from a vendor, then they have more options to meet diverse business needs, but the complexity of pricing and implementation costs makes it difficult to determine the optimal subset to purchase or implement

Engineering Contradiction:
Improvereport template optionsVSAvoidselection complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system introduces an intermediary selection mechanism that automatically filters and ranks report templates based on customer-specific criteria. The intermediary component processes customer parameters, report metadata, and pricing information to generate optimized subsets, eliminating the need for customers to manually navigate complex pricing structures and inter-report dependencies.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system changes the parameters for report template evaluation by incorporating multiple dimensions including pricing, implementation costs, inter-report dependencies, and customer-specific criteria. The optimization process dynamically adjusts these parameters to identify the optimal subset that maximizes value while constraining costs, transforming a complex manual selection problem into an automated parameter optimization task.

Inventive Principle:
Principle #35Parameter changes

2Adaptability or versatility

If customers purchase more report templates to cover all business needs, then they have comprehensive coverage, but the total cost and implementation complexity increase

Engineering Contradiction:
Improvebusiness needs coverageVSAvoidtotal cost
Core Design Contradiction:
Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

Instead of requiring customers to purchase all available report templates (excessive action), the system identifies and recommends only the optimal subset (partial action) that sufficiently covers their specific business needs. The optimization process deliberately selects a limited number of high-value reports rather than maximizing the quantity of templates purchased, thereby reducing total cost while maintaining adequate coverage.

Inventive Principle:
Principle #16Partial or excessive action

Solution Approach 2:

The system creates a virtual copy of the complete report template catalog with associated metadata, pricing, and dependency information. This virtual replica allows the optimization algorithm to simulate various subset combinations and evaluate their value-to-cost ratios without requiring customers to actually purchase or implement multiple templates, enabling cost-effective selection through computational exploration.

Inventive Principle:
Principle #26Copying

3Measurement precision

If customers manually evaluate each report template individually, then they can assess specific features, but they fail to consider inter-report template dependencies and synergies

Engineering Contradiction:
Improveindividual report assessmentVSAvoidinter-report dependency information
Core Design Contradiction:
Measurement precisionVSLoss of information

Solution Approach 1:

The system merges the evaluation of individual report templates with the analysis of inter-report dependencies and synergies into a unified optimization process. Rather than assessing reports in isolation, the system combines individual report metadata, pricing information, dependency relationships, and customer criteria into an integrated evaluation framework that simultaneously considers all factors to identify the optimal subset.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The optimization system performs multiple functions simultaneously: it evaluates individual report features, analyzes inter-report dependencies, calculates synergistic values, assesses pricing and implementation costs, and ranks templates against customer criteria. This multi-functional approach eliminates the need for separate evaluation steps and ensures that inter-report relationships are fully considered in the final selection.

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

Data Source

PatentUS7475062B2Apparatus and method for selecting a subset of report templates based on specified criteria
Publication Date: 2009.01.06 SAP IRELAND LTD
  • US7475062B2 patent drawing
  • US7475062B2 patent drawing
  • US7475062B2 patent drawing

AI summary

A computer readable medium with executable instructions, includes instructions to process metadata associated with a set of report templates. A subset of report templates is selected from the set of report templates using the metadata. The subset of report templates maximizes a reporting objective subject to a selection rule as specified by the metadata. The subset of report templates is returned.