# US 2017/0371847 A1 · Autotagging a template of a reporting workbook

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2017/0371847 A1
- Document ID: US20170371847A1
- Status: Published application
- Kind: A1
- Application number: 15/462,401
- Filed: 2017-03-17
- Published: 2017-12-28
- Earliest claimed: 2016-06-27
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Victor Acorda; Yan Schwartz; Andrew Harris; John Purves
- Web page: https://patentgrep.com/patent/US20170371847A1

## CPC

- G06F 3/0482: Interaction with lists of selectable items, e.g. menus
- G06F 40/117: Tagging; Marking up (details of markup languages G06F40/143); Designating a block; Setting of attributes (style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154)
- G06F 40/143: Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
- G06F 40/154: Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 40/186: Templates
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Autotagging a template of a reporting workbook is provided. The template of the reporting workbook is received. The template is in a first format type. User specified selection of portions of the template are received. The portions are associated with at least two dimensions of the reporting workbook. A user specified type is received for a tag. A modification of the template is created by automatically generating a tag in a predetermined field of each of the portions based on the user specified type. A version of the reporting workbook is generated based on the modification of the template, wherein the version is in a second format type.

## Claims

### Claim 1

A tangible processor-readable storage device including instructions executable by one or more processors for:
receiving a template of a reporting workbook, wherein the template is in a first format type;
receiving user specified selection of portions of the template, wherein the portions are associated with at least two dimensions of the reporting workbook;
receiving a user specified type for a tag;
creating a modification of the template by automatically generating the tag in a predetermined field of each of the portions based on the user specified type; and
generating a version of the reporting workbook based on the modification of the template, wherein the version is in a second format type.

### Claim 2 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the predetermined field includes a comment field.

### Claim 3 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the automatically generating of the tag further comprises:
including the type in the tag.

### Claim 4 (depends on 3)

The tangible processor-readable storage device as recited by claim 3, wherein the type is selected from a group consisting of table begin, table end, concept, context, unit, dimension, typed dimension, and data.

### Claim 5 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the portions of the template include cells.

### Claim 6 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the receiving of the user specified selection of the portions of the template further comprises:
receiving information indicating the portions were specified using one of painting, framing, and specifying dimensions and rows.

### Claim 7 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the receiving of the user specified type for of the tag further comprises:
receiving user input to select a user interface control for an auto tag cell window;
displaying the auto tag cell window in response to receiving the user input selecting the user interface control; and
receiving the type of the tag from the auto tag cell window.

### Claim 8 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the second format type is selected from a group consisting of Extensible Markup Language (XML) and eXtensible Business Reporting Language (XBRL) version of the business reporting workbook.

### Claim 9 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the creating of the modification of the template further comprises:
creating the modification of the template for one sheet of the reporting workbook;
communicating the modification from a client to a server;
receiving modifications for all of sheets of the reporting workbook; and
generating the version at the server based on the received modifications.

### Claim 10 (depends on 1)

The tangible processor-readable storage device as recited by claim 1, wherein the reporting workbook is defined by a closed taxonomy.

### Claim 11

A method of autotagging a template of a reporting workbook, the method comprising:
receiving the template of the reporting workbook, wherein the template is in a first format type;
receiving user specified selection of portions of the template, wherein the portions are associated with at least two dimensions of the reporting workbook;
receiving a user specified type for a tag;
creating a modification of the template by automatically generating the tag in a predetermined field of each of the portions based on the user specified type; and
generating a version of the reporting workbook based on the modification of the template, wherein the version is in a second format type.

### Claim 12 (depends on 11)

The method as recited by claim 11, wherein the predetermined field includes a comment field.

### Claim 13 (depends on 11)

The method as recited by claim 11, wherein the automatically generating of the tag further comprises:
including the type in the tag.

### Claim 14 (depends on 13)

The method as recited by claim 13, wherein the type is selected from a group consisting of table begin, table end, concept, context, unit, dimension, typed dimension, and data.

### Claim 15 (depends on 11)

The method as recited by claim 11, wherein the portions of the template include cells.

### Claim 16 (depends on 11)

The method as recited by claim 11, wherein the receiving of the user specified selection of the portions of the template further comprises:
receiving information indicating the portions were specified using one of painting, framing, and specifying dimensions and rows.

### Claim 17 (depends on 11)

The method as recited by claim 11, wherein the method further comprises:
automatically scanning a spreadsheet of a user interface for a J shape that specifies a dimension;
creating an explicit dimension map for each cell under a vertical head of the J shape, wherein the explicit dimension map represents the dimension;
creating cell definitions for each of the cells, wherein each of the cell definitions include the explicit dimension map; and
including the cell definitions in the modification of the template.

### Claim 18 (depends on 11)

The method as recited by claim 11, wherein the second format type is selected from a group consisting of Extensible Markup Language (XML) and eXtensible Business Reporting Language (XBRL) version of the business reporting workbook.

### Claim 19 (depends on 11)

The method as recited by claim 11, wherein the creating of the modification of the template further comprises:
creating the modification of the template for one sheet of the reporting workbook;
communicating the modification from a client to a server;
receiving modifications for all of sheets of the reporting workbook; and
generating the version at the server based on the received modifications.

### Claim 20

An apparatus comprising:
one or more processors; and
a tangible processor-readable storage device including instructions for:
receiving a template of a reporting workbook, wherein the template is in a first format type;
receiving user specified selection of portions of the template, wherein the portions are associated with at least two dimensions of the reporting workbook;
receiving a user specified type for a tag;
creating a modification of the template by automatically generating the tag in a predetermined field of each of the portions based on the user specified type; and
generating a version of the reporting workbook based on the modification of the template, wherein the version is in a second format type.
