Sigma Computing, Inc.

Joseph M Hain

Jason D Frantz

Robert C Woollen

Kenneth Truong

James L Gale

Nipurn Doshi

Julie L Lemieux

Deepanshu Utkarsh

Benjamin D Wiklund

Alexis Johnson

Tracking errors in data set lineage including receiving, from a user, a change to a model data set, wherein the model data set is a reusable modeling layer comprising at least a portion of a data source retrieved from a data warehouse; accessing a list of dependent worksheets utilizing the model data set as a data source wherein each dependent worksheet is configured to perform analysis on the portion of the first data source within the model data set without changing the model data set; generating an error report for the dependent worksheets utilizing the model data set; and providing, to the user, the error report for the dependent worksheets utilizing the model data set.

Tracking errors in data set lineage

Automatic rewriting of subtotal calculations including presenting, by a table manager, a spreadsheet structure on a GUI of a client computing system, wherein the spreadsheet structure presents a data set from a cloud-based data warehouse; receiving, at a first column of the spreadsheet structure by the table manager, a formula that includes a reference to a second column of the spreadsheet structure, wherein the formula is received from the client computing system; detecting, by the table manager, that the second column includes a subtotal calculation of a third column of the spreadsheet structure; and rewriting, by the table manager, the formula by replacing the reference to the second column with the subtotal calculation of the third column.

Automatic rewriting of subtotal calculations

Adding a column into a worksheet, including: receiving, via a spreadsheet interface comprising a first worksheet, a request to add a new column to the first worksheet, wherein the request includes a key that identifies a reference column in the first worksheet, a specification of a second worksheet that comprises a corresponding reference column related by the key, and a specification of a data column in the second worksheet, wherein each entry of the data column is associated with an entry of the corresponding reference column in the second worksheet, and entries to be included in the requested new column will be based on the entries of the data column; generating, based on the request, a database query; and receiving, from a database and in response to the database query, a query result comprising the new column to be added to the first worksheet.

Adding a column into a worksheet

Growing community of inventors

BENICIA, CA, United States of America

Joseph M Hain