Automatic Scoping of Data Entities
    2.
    发明申请
    Automatic Scoping of Data Entities 有权
    数据实体的自动范围

    公开(公告)号:US20130086459A1

    公开(公告)日:2013-04-04

    申请号:US13252412

    申请日:2011-10-04

    IPC分类号: G06F17/21

    摘要: A system for creating a report in a spreadsheet includes a data source module programmed to identify sources of data items associated with the spreadsheet, an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet, and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.

    摘要翻译: 用于在电子表格中创建报告的系统包括被编程为识别与电子表格相关联的数据项的来源的数据源模块,被编程为识别哪个数据项与在电子表格中生成的报告相关联的活动模块,以及 显示模块被编程为在现场窗格上显示活动选项卡和全部选项卡,活动选项卡显示被确定为与电子表格中生成的报告相关联的数据项,以及显示所有选项卡的所有选项卡 与电子表格相关联的数据项。

    STRUCTURED MODELING OF DATA IN A SPREADSHEET
    5.
    发明申请
    STRUCTURED MODELING OF DATA IN A SPREADSHEET 审中-公开
    数据的结构化建模

    公开(公告)号:US20130124957A1

    公开(公告)日:2013-05-16

    申请号:US13294824

    申请日:2011-11-11

    IPC分类号: G06F17/00

    CPC分类号: G06F17/246 G06F16/903

    摘要: Data displayed on a spreadsheet and data from one or more data sources are used to create a model within the spreadsheet. The data may be obtained from many types of data sources, such as: relational databases, multidimensional sources, cloud services, data feeds, spreadsheet files, text files, data from the Web, and the like. A modeling engine of the spreadsheet application creates the model that structures the data, relates different pieces of data, and provides context for the data. The model that may be stored within the spreadsheet includes the raw data and metadata that describes the data and provides the context for the data. The model may be automatically updated based on performed operations of the spreadsheet. The model may be examined using a query language (e.g. MDX, DAX, SQL, Spreadsheet Functions and Formulas, . . . ) to examine the data and the relationships obtained from the spreadsheet and data sources.

    摘要翻译: 电子表格上显示的数据和来自一个或多个数据源的数据用于在电子表格中创建模型。 数据可以从许多类型的数据源获得,例如:关系数据库,多维来源,云服务,数据馈送,电子表格文件,文本文件,来自Web的数据等。 电子表格应用程序的建模引擎创建了构建数据,关联不同数据的模型,并为数据提供上下文。 可能存储在电子表格中的模型包括描述数据并为数据提供上下文的原始数据和元数据。 可以根据电子表格的执行操作自动更新该模型。 可以使用查询语言(例如MDX,DAX,SQL,电子表格函数和公式,...)检查模型,以检查从电子表格和数据源获得的数据和关系。

    Scorecard Interface Editor
    10.
    发明申请
    Scorecard Interface Editor 有权
    记分卡界面编辑器

    公开(公告)号:US20090106640A1

    公开(公告)日:2009-04-23

    申请号:US11877127

    申请日:2007-10-23

    IPC分类号: G06F17/24

    摘要: A user interface is programmed to create a scorecard. The interface includes a scorecard module including a column area and a row area, and a key performance indicator area including a plurality of key performance indicators. A key performance indicator from the key performance indicator area can be dragged and dropped onto one of the column area and the row area to add indicia associated with the key performance indicator to the scorecard.

    摘要翻译: 编程用户界面创建记分卡。 该接口包括包括列区域和行区域的记分卡模块以及包括多个关键性能指标的关键性能指标区域。 关键性能指标区域的关键性能指标可以拖放到列区域和行区域之一,以将与关键性能指标相关联的标记添加到记分卡。