公开(公告)号：US20070005583A1

公开(公告)日：2007-01-04

申请号：US11170898

申请日：2005-06-29

申请人： Carolyn Chau ,  Jason Carlson ,  Robert Meyers

发明人： Carolyn Chau ,  Jason Carlson ,  Robert Meyers

IPC分类号： G06F17/30

CPC分类号： G06F16/288

摘要： A method of creating and defining complex functions and/or expressions that may be run against an entity relationship model. An anchor entity serves as a beginning point of the expression and determines what data that will be returned by the user-created expression within the context of a query. When a relationship from any entity is traversed, including the anchor entity, the role name for the target entity is displayed hierarchically beneath the entity it was navigated from. When an entity is selected, the relationships from this entity are shown as possible navigation paths. The user may select one of these paths to navigate and add to the query tree or chose a field from the field list. Entities can be dragged and dropped into a formula area to create the expression. Functions, and mathematical and logical operations can be performed on the entities and fields in creating the expression. The fields and entities can be filtered to refine the results retrieved by the expression.

摘要翻译： 一种创建和定义可能针对实体关系模型运行的复杂函数和/或表达式的方法。 锚实体充当表达式的起始点，并确定在查询的上下文中由用户创建的表达式返回的数据。 当遍历任何实体的关系（包括锚点实体）时，目标实体的角色名称将在其导航的实体之下分层显示。 当选择实体时，来自该实体的关系被显示为可能的导航路径。 用户可以选择这些路径之一来导航并添加到查询树中，或从字段列表中选择一个字段。 可以将实体拖放到公式区域中以创建表达式。 函数和数学和逻辑运算可以在创建表达式的实体和字段上执行。 可以对字段和实体进行过滤，以细化表达式检索的结果。

公开(公告)号：US20070233680A1

公开(公告)日：2007-10-04

申请号：US11396174

申请日：2006-03-31

申请人： Jason Carlson ,  Carolyn Chau ,  Robert Meyers

发明人： Jason Carlson ,  Carolyn Chau ,  Robert Meyers

IPC分类号： G06F17/30

CPC分类号： G06F16/242 ,  G06F16/283

摘要： Mechanisms are provided for auto-generating reports based on metadata. Entities in databases may have some associated metadata, and this metadata may serve as the basis of the reports. Such reports may be generated not only automatically but also dynamically. The generation of reports may also be a function of the role traversal between entities, such that if a role indicates at most one instance of the target entity is related to an instance of the source entity, a single-type report can be created, whereas if the role indicates many instances of the target entity may be related, a different kind or report can be generated, namely, a multi-type report. Lastly, even though reports are auto-generated, such reports can be overridden or customized via user interfaces or application programming interfaces.

摘要翻译： 提供了基于元数据自动生成报告的机制。 数据库中的实体可能具有一些关联的元数据，并且此元数据可以作为报告的基础。 这样的报告不仅可以自动生成，而且可以动态地生成。 报告的生成也可能是实体之间的角色遍历的功能，使得如果角色最多指出一个目标实体的一个实例与源实体的实例相关，则可以创建单一类型的报告，而 如果角色指示目标实体的许多实例可能相关，则可以生成不同类型或报告，即，多类型报告。 最后，即使自动生成报告，也可以通过用户界面或应用程序编程接口来覆盖或定制报告。

公开(公告)号：US20070005562A1

公开(公告)日：2007-01-04

申请号：US11170418

申请日：2005-06-29

申请人： Carolyn Chau ,  Jason Carlson ,  Robert Meyers ,  Brian Welcker ,  Lisa Mueller ,  Aaron Meyers

发明人： Carolyn Chau ,  Jason Carlson ,  Robert Meyers ,  Brian Welcker ,  Lisa Mueller ,  Aaron Meyers

IPC分类号： G06F17/30

CPC分类号： G06F17/30604 ,  Y10S707/99943

摘要： A graphical user interface and method of use thereof that allows users to interact with an entity relationship model. The user interface includes zones that allow users to navigate among the entities, roles and fields to create queries that are run against the model. Clicking on an entity in the shows the available fields for the entity. Users can drag and drop entities and fields onto a design surface to quickly and easily build queries. Rules are applied when either an entity or a field is dropped onto the design surface based upon the item being dropped (either an entity or a field), the position of the drop and also the properties that are associated with the item. Entities may be grouped and filtered to sort and limit the results of the query. After query is run, the results may be displayed in a separate area to the user.

摘要翻译： 图形用户界面及其使用方法，其允许用户与实体关系模型进行交互。 用户界面包括允许用户在实体，角色和字段之间导航以创建针对模型运行的查询的区域。 单击实体中的实体将显示实体的可用字段。 用户可以将实体和字段拖放到设计界面，以便快速轻松地构建查询。 当实体或字段根据删除的项目（实体或字段），放置的位置以及与项目相关联的属性将实体或字段删除到设计表面时，将应用规则。 可以对实体进行分组和过滤，以对查询的结果进行排序和限制。 运行查询后，结果可能会显示在用户的单独区域中。

公开(公告)号：US20060271583A1

公开(公告)日：2006-11-30

申请号：US11138732

申请日：2005-05-25

申请人： Corey Hulen ,  Carolyn Chau

发明人： Corey Hulen ,  Carolyn Chau

IPC分类号： G06F7/00

CPC分类号： G06F17/30592 ,  G06F2216/03

摘要： A dimension member of a report is slid to produce a new view of the report that corresponds to the slid dimension. The dimension member sliding allows navigation of a dimension of the data by members in a pattern that is not hierarchical. The view of the report corresponds to a hierarchy tree that is decomposed into a matrix. The next dimension members are determined using the matrix and the dimensionally slid view of the report is generated.

摘要翻译： 报告的维度成员被滑动以生成与滑动维度相对应的报告的新视图。 尺寸成员滑动允许成员以不是分层的图案导航数据的维度。 报表的视图对应于分解为矩阵的层次结构树。 使用矩阵确定下一维度成员，并生成报告的尺寸滑动视图。

公开(公告)号：US20060161471A1

公开(公告)日：2006-07-20

申请号：US11039714

申请日：2005-01-19

申请人： Corey Hulen ,  Carolyn Chau ,  Vincent Yang

发明人： Corey Hulen ,  Carolyn Chau ,  Vincent Yang

IPC分类号： G06F17/30

CPC分类号： G06Q10/06393 ,  G06F16/283 ,  G06Q10/06

摘要： Method and system for generating summary scores from heterogeneous measures retrieved from multi-dimensional data structures for monitoring organizational performance. Scorecards are created for each group of tree-structured measures branching from Parent nodes to child nodes based on Key Performance Indicators (KPI). Scores for each parent node may be obtained by rolling up scores for child nodes reporting to the parent node. KPI's at the lowest level are mapped on first scale, then mapped to a normalized scale, and score values determined. KPI scores are weight-averaged for roll-up to a parent node determining the score for that node. Multiple parent nodes may be rolled-up to a higher level node in a similar way. Multiple dimensions of the measure such as geographic and temporal may be scored simultaneously.

摘要翻译： 用于从用于监测组织绩效的多维数据结构检索的异质度量中产生汇总分数的方法和系统。 基于关键绩效指标（KPI），从父节点到子节点分支的每组树结构化度量值都会创建记分卡。 每个父节点的分数可以通过向父节点报告的子节点的分数进行卷积来获得。 最低级别的KPI映射到第一级，然后映射到归一化的比例，并确定得分值。 关键绩效指标得分是对于确定该节点得分的父节点进行加权平均。 多个父节点可以以类似的方式卷起到较高级节点。 测量的多个维度（如地理和时间）可以同时进行评分。

公开(公告)号：US20050021403A1

公开(公告)日：2005-01-27

申请号：US10867485

申请日：2004-06-14

申请人： Stuart Ozer ,  Michael Hart ,  Wei Wei Cho ,  Carolyn Chau

发明人： Stuart Ozer ,  Michael Hart ,  Wei Wei Cho ,  Carolyn Chau

IPC分类号： G06Q30/02 ,  G06F17/60

CPC分类号： G06Q30/02 ,  G06Q30/0241 ,  G06Q30/0248 ,  G06Q30/0252 ,  G06Q30/0254 ,  G06Q30/0264 ,  G06Q30/0269 ,  G06Q30/0272 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： A system, including a planning module, a control module and a receiver module, configured to schedule display of one or more advertising impressions of available advertising inventory. The planning module enables scheduling a requested quantity of advertising impressions in accordance with target criteria. Further, the planning module enables selecting an advertising impression goal for advertisement, assigning an advertising type and defining a weight for the advertisements. The control module receives the schedule, the advertising type and the defined weights and generates one or more metadata files that contain target criteria, advertising type and weights for the advertisements. The one or more metadata files, with the advertisements, are delivered to the receiver module that is configured to define a display frequency for the advertisements based upon one or more of the metadata files. The receiver module selectively displays advertisement content associated with the advertisements to achieve the advertising impression goal.

摘要翻译： 一种包括规划模块，控制模块和接收器模块的系统，被配置为调度显示可用广告库存的一个或多个广告印象。 计划模块可以根据目标标准调度所请求的广告展示次数。 此外，规划模块能够选择广告的广告印象目标，分配广告类型并定义广告的权重。 控制模块接收调度表，广告类型和定义的权重，并且生成包含目标标准，广告的广告类型和权重的一个或多个元数据文件。 具有广告的一个或多个元数据文件被传送到接收器模块，其被配置为基于一个或多个元数据文件来定义广告的显示频率。 接收器模块选择性地显示与广告相关联的广告内容以实现广告印象目标。