Filtering user interface for a data summary table
    2.
    发明授权
    Filtering user interface for a data summary table 有权
    过滤数据摘要表的用户界面

    公开(公告)号:US08095866B2

    公开(公告)日:2012-01-10

    申请号:US11223631

    申请日:2005-09-09

    IPC分类号: G06N3/00

    摘要: A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.

    摘要翻译: 用于创建数据摘要表的图形用户界面包括包括多个字段的数据摘要表,以及被编程为对数据摘要表的字段中的项目应用过滤器的过滤窗格,过滤窗格包括字段选择器控件,其中 字段选择器控制被编程为允许选择数据摘要表中的字段的字段来定义字段的过滤。

    TECHNIQUES FOR FILTER SHARING
    3.
    发明申请
    TECHNIQUES FOR FILTER SHARING 有权
    滤波器共享技术

    公开(公告)号:US20090313250A1

    公开(公告)日:2009-12-17

    申请号:US12140269

    申请日:2008-06-17

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30389

    摘要: Techniques for filter sharing are described. An apparatus may comprise a shared filter manager component for an application program. The shared filter manager component may be operative to manage shared filtering operations for the application program. The shared filter manager component may comprise a shared filter interface module operative to receive a selection for a shared filter component to filter multiple source data objects, and assign the shared filter component to the multiple source data objects. The shared filter manager component may further comprise a shared filter control module communicatively coupled to the shared filter interface module. The shared filter control module may be operative to filter data from the multiple source data objects using the shared filter component. Other embodiments are described and claimed.

    摘要翻译: 描述了过滤器共享的技术。 装置可以包括用于应用程序的共享过滤器管理器组件。 共享过滤器管理器组件可以用于管理应用程序的共享过滤操作。 共享过滤器管理器组件可以包括共享过滤器接口模块,其可操作以接收用于共享过滤器组件的选择以过滤多个源数据对象,并将共享过滤器组件分配给多个源数据对象。 共享过滤器管理器组件还可以包括通信地耦合到共享过滤器接口模块的共享过滤器控制模块。 共享滤波器控制模块可以用于使用共享滤波器组件来从多个源数据对象中过滤数据。 描述和要求保护其他实施例。

    Automatic data perspective generation for a target variable
    4.
    发明授权
    Automatic data perspective generation for a target variable 有权
    为目标变量生成自动数据透视图

    公开(公告)号:US07225200B2

    公开(公告)日:2007-05-29

    申请号:US10824108

    申请日:2004-04-14

    IPC分类号: G06F17/00 G06F7/00

    摘要: The present invention leverages machine learning techniques to provide automatic generation of conditioning variables for constructing a data perspective for a given target variable. The present invention determines and analyzes the best target variable predictors for a given target variable, employing them to facilitate the conveying of information about the target variable to a user. It automatically discretizes continuous and discrete variables utilized as target variable predictors to establish their granularity. In other instances of the present invention, a complexity and/or utility parameter can be specified to facilitate generation of the data perspective via analyzing a best target variable predictor versus the complexity of the conditioning variable(s) and/or utility. The present invention can also adjust the conditioning variables (i.e., target variable predictors) of the data perspective to provide an optimum view and/or accept control inputs from a user to guide/control the generation of the data perspective.

    摘要翻译: 本发明利用机器学习技术来提供用于为给定目标变量构建数据透视图的自动生成调节变量。 本发明确定和分析给定目标变量的最佳目标变量预测变量,使用它们来促进向用户传达关于目标变量的信息。 它自动离散化用作目标变量预测变量的连续和离散变量以确定其粒度。 在本发明的其他实例中,可以规定复杂性和/或效用参数,以通过分析最佳目标变量预测器与调节变量和/或效用的复杂性来促进数据透视的产生。 本发明还可以调整数据透视图的调节变量(即,目标变量预测器),以提供最佳视图和/或接受来自用户的控制输入以指导/控制数据视角的产生。

    Anomaly detection in data perspectives
    5.
    发明授权
    Anomaly detection in data perspectives 失效
    数据透视异常检测

    公开(公告)号:US07065534B2

    公开(公告)日:2006-06-20

    申请号:US10874956

    申请日:2004-06-23

    IPC分类号: G06F7/00 G06F17/00

    摘要: The present invention leverages curve fitting data techniques to provide automatic detection of data anomalies in a “data tube” from a data perspective, allowing, for example, detection of data anomalies such as on-screen, drill down, and drill across data anomalies in, for example, pivot tables and/or OLAP cubes. It determines if data substantially deviates from a predicted value established by a curve fitting process such as, for example, a piece-wise linear function applied to the data tube. A threshold value can also be employed by the present invention to facilitate in determining a degree of deviation necessary before a data value is considered anomalous. The threshold value can be supplied dynamically and/or statically by a system and/or a user via a user interface. Additionally, the present invention provides an indication to a user of the type and location of a detected anomaly from a top level data perspective.

    摘要翻译: 本发明利用曲线拟合数据技术从数据角度提供“数据管”中的数据异常的自动检测,从而允许例如检测诸如屏幕上的数据异常,向下钻取和钻取数据异常的数据异常 例如,枢轴表和/或OLAP多维数据集。 它确定数据是否基本上偏离由曲线拟合处理(例如应用于数据管的分段线性函数)所建立的预测值。 本发明也可以采用阈值,以便在确定数据值被认为是异常之前确定所需的偏差程度。 阈值可以由系统和/或用户经由用户界面动态地和/或静态地提供。 另外,本发明从顶级数据的角度向用户提供了检测到的异常的类型和位置的指示。

    Filtering user interface for a data summary table
    6.
    发明授权
    Filtering user interface for a data summary table 有权
    过滤数据摘要表的用户界面

    公开(公告)号:US09223772B2

    公开(公告)日:2015-12-29

    申请号:US13311736

    申请日:2011-12-06

    IPC分类号: G06F3/00 G06F17/24 G06F9/44

    摘要: A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.

    摘要翻译: 用于创建数据摘要表的图形用户界面包括包括多个字段的数据摘要表,以及被编程为对数据摘要表的字段中的项目应用过滤器的过滤窗格,过滤窗格包括字段选择器控件,其中 字段选择器控制被编程为允许选择数据摘要表中的字段的字段来定义字段的过滤。

    Dynamically filtering aggregate reports based on values resulting from one or more previously applied filters
    7.
    发明授权
    Dynamically filtering aggregate reports based on values resulting from one or more previously applied filters 有权
    根据一个或多个先前应用的过滤器产生的值动态过滤聚合报告

    公开(公告)号:US09195728B2

    公开(公告)日:2015-11-24

    申请号:US12895177

    申请日:2010-09-30

    IPC分类号: G06F17/00 G06F17/30 G06F17/24

    摘要: Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied.

    摘要翻译: 方法,系统和计算机程序产品根据先前应用于聚合报告的一个或多个过滤器产生的值,动态过滤聚合报告。 一种方法是将要以指定的评估顺序应用的过滤器的集合维护到聚合报告,将第一过滤器应用于聚合报告,以及评估聚合报告中的值以产生应用第一个过滤器产生的聚合值。 该方法还包括将下一个过滤器应用于聚合报告,并评估由应用第一个过滤器而产生的聚合报告中的聚合值,从而产生由将下一个过滤器应用于聚合报告而产生的聚合值。 此外,该方法涉及显示聚合报告,其中将先前将任何过滤器应用于聚合报告的值包括评估在应用每个先前的过滤器之后在聚合报告中显示的可视值。

    Associating conditions to summary table data
    9.
    发明授权
    Associating conditions to summary table data 有权
    将条件与汇总表数据相关联

    公开(公告)号:US08832544B2

    公开(公告)日:2014-09-09

    申请号:US12857067

    申请日:2010-08-16

    IPC分类号: G06F17/30 G06F17/00 G06F17/24

    摘要: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

    摘要翻译: 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中,基于摘要表中当前突出显示的单元确定相关的数据组。 然后,用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存,使得条件在重组汇总表之后保持与数据点相关联。