-
公开(公告)号：US08832544B2
公开(公告)日：2014-09-09
申请号：US12857067
申请日：2010-08-16
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： 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.
摘要翻译： 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。 然后，用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。
-
公开(公告)号：US20110035653A1
公开(公告)日：2011-02-10
申请号：US12857067
申请日：2010-08-16
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： 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.
摘要翻译： 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。 然后，用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。
-
公开(公告)号：US07779000B2
公开(公告)日：2010-08-17
申请号：US11215634
申请日：2005-08-29
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： 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.
摘要翻译： 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。 然后，用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。
-
公开(公告)号：US07225200B2
公开(公告)日：2007-05-29
申请号：US10824108
申请日：2004-04-14
申请人： David M. Chickering , Bo Thiesson , Carl M. Kadie , David E. Heckerman , Christopher A. Meek , Allan Folting , Eric B. Vigesaa
发明人： David M. Chickering , Bo Thiesson , Carl M. Kadie , David E. Heckerman , Christopher A. Meek , Allan Folting , Eric B. Vigesaa
CPC分类号： G06F17/30592 , G06F2216/03 , Y10S707/99936 , Y10S707/99943
摘要： 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.
摘要翻译： 本发明利用机器学习技术来提供用于为给定目标变量构建数据透视图的自动生成调节变量。 本发明确定和分析给定目标变量的最佳目标变量预测变量，使用它们来促进向用户传达关于目标变量的信息。 它自动离散化用作目标变量预测变量的连续和离散变量以确定其粒度。 在本发明的其他实例中，可以规定复杂性和/或效用参数，以通过分析最佳目标变量预测器与调节变量和/或效用的复杂性来促进数据透视的产生。 本发明还可以调整数据透视图的调节变量（即，目标变量预测器），以提供最佳视图和/或接受来自用户的控制输入以指导/控制数据视角的产生。
-
公开(公告)号：US07480675B2
公开(公告)日：2009-01-20
申请号：US11222660
申请日：2005-09-09
IPC分类号： G06F7/00
CPC分类号： G06F17/246 , Y10S707/99943
摘要： A graphical user interface for creating a data summary table includes a pane including a plurality of fields, and a data summary table. Upon selection of a field to include in the data summary table, the user interface is programmed to analyze the field and automatically place the field in the data summary table.
摘要翻译： 用于创建数据摘要表的图形用户界面包括包括多个字段的窗格和数据摘要表。 在选择要包括在数据摘要表中的字段时，将用户界面编程为分析该字段并将该字段自动放置在数据汇总表中。
-
公开(公告)号：US20130086460A1
公开(公告)日：2013-04-04
申请号：US13252450
申请日：2011-10-04
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F9/44 , G06F17/30 , G06F17/30292 , G06N5/02 , G06Q10/10
摘要： A system for creating a report in a spreadsheet includes: a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: a data source module programmed to identify tables associated with the spreadsheet; a relationship module programmed to analyze the tables and identify relationships between the items; and a display module programmed to display the relationships between the tables.
摘要翻译： 用于在电子表格中创建报告的系统包括：中央处理单元; 以及存储器编码指令，当由所述中央处理单元执行时，使所述中央处理单元创建：编程为识别与所述电子表格相关联的表的数据源模块; 关系模块被编程为分析表格并识别项目之间的关系; 以及被编程为显示表之间的关系的显示模块。
-
公开(公告)号：US08095866B2
公开(公告)日：2012-01-10
申请号：US11223631
申请日：2005-09-09
申请人： Allan Folting , Thibaut Vial , Robert Hawking
发明人： Allan Folting , Thibaut Vial , Robert Hawking
IPC分类号： G06N3/00
CPC分类号： G06F17/245 , G06F3/0482 , G06F3/04842 , G06F9/451 , G06F17/246
摘要： 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.
摘要翻译： 用于创建数据摘要表的图形用户界面包括包括多个字段的数据摘要表，以及被编程为对数据摘要表的字段中的项目应用过滤器的过滤窗格，过滤窗格包括字段选择器控件，其中 字段选择器控制被编程为允许选择数据摘要表中的字段的字段来定义字段的过滤。
-
公开(公告)号：US20090313250A1
公开(公告)日：2009-12-17
申请号：US12140269
申请日：2008-06-17
申请人： Allan Folting , Gabhan Berry , Danny Khen , Anatoly Grabar , Andrew Garbuzov
发明人： Allan Folting , Gabhan Berry , Danny Khen , Anatoly Grabar , Andrew Garbuzov
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.
摘要翻译： 描述了过滤器共享的技术。 装置可以包括用于应用程序的共享过滤器管理器组件。 共享过滤器管理器组件可以用于管理应用程序的共享过滤操作。 共享过滤器管理器组件可以包括共享过滤器接口模块，其可操作以接收用于共享过滤器组件的选择以过滤多个源数据对象，并将共享过滤器组件分配给多个源数据对象。 共享过滤器管理器组件还可以包括通信地耦合到共享过滤器接口模块的共享过滤器控制模块。 共享滤波器控制模块可以用于使用共享滤波器组件来从多个源数据对象中过滤数据。 描述和要求保护其他实施例。
-
公开(公告)号：US07065534B2
公开(公告)日：2006-06-20
申请号：US10874956
申请日：2004-06-23
CPC分类号： G06F17/30592 , G06N7/00 , Y10S707/957 , Y10S707/958 , Y10S707/99943
摘要： 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多维数据集。 它确定数据是否基本上偏离由曲线拟合处理（例如应用于数据管的分段线性函数）所建立的预测值。 本发明也可以采用阈值，以便在确定数据值被认为是异常之前确定所需的偏差程度。 阈值可以由系统和/或用户经由用户界面动态地和/或静态地提供。 另外，本发明从顶级数据的角度向用户提供了检测到的异常的类型和位置的指示。
-
公开(公告)号：US10311080B2
公开(公告)日：2019-06-04
申请号：US13206710
申请日：2011-08-10
IPC分类号： G06F16/20 , G06F16/26 , G06F16/9035 , G06F16/2458 , G06F16/22 , G06F16/9535
摘要： Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.
-
-
-
-
-
-
-
-
-
搜索结果
46 条记录 (耗时 0.025 秒)
