Smarter Business Intelligence Systems
    6.
    发明申请
    Smarter Business Intelligence Systems 失效
    更聪明的商业智能系统

    公开(公告)号:US20120191636A1

    公开(公告)日:2012-07-26

    申请号:US13012554

    申请日:2011-01-24

    IPC分类号: G06N5/02

    CPC分类号: G06F17/27 G06Q10/00

    摘要: An embodiment of the invention provides a method and system for analyzing a plurality of reports. More specifically, a change detection module predicts results of future reports based on past reports and identifies a first report that deviates from its predicted results. A dependency analysis module connected to the change detection module at least one report sharing a dependency with the first report by performing a dependency analysis and/or a usage analysis. The dependency analysis labels the first report and at least one second report as sharing a dependency if the second report deviates from its predicted results. The usage analysis labeling the first report and at least one report analyzed by an analyst as sharing a dependency if the report analyzed by the analyst is analyzed in response to the identification of the first report.

    摘要翻译: 本发明的实施例提供了一种用于分析多个报告的方法和系统。 更具体地,变更检测模块基于过去的报告预测未来报告的结果,并且识别偏离其预测结果的第一报告。 依赖关系分析模块,通过执行依赖性分析和/或使用分析,将与所述第一报告共享依赖性的至少一个报告连接到所述变更检测模块。 如果第二个报告偏离其预测结果,依赖关系分析将第一个报告和至少一个第二个报告标记为共享依赖关系。 如果对分析师分析的报告进行了分析,则分析了第一次报告的标签使用情况分析,以及分析员分析的至少一份报告,以分析依赖关系,以响应第一份报告的识别。

    DISCOVERING A REPORTING MODEL FROM AN EXISTING REPORTING ENVIRONMENT
    7.
    发明申请
    DISCOVERING A REPORTING MODEL FROM AN EXISTING REPORTING ENVIRONMENT 有权
    从现有的报告环境中发现报告模式

    公开(公告)号:US20130265326A1

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

    申请号:US13438903

    申请日:2012-04-04

    IPC分类号: G09G5/377

    CPC分类号: G06Q10/0639

    摘要: Computer software is disclosed for discovering and representing a reporting model of an existing reporting environment. For each report in a plurality of reports, the software searches metadata of the report for descriptive information and dependencies on other reports. The software depicts, in a graphical representation, each report and relationships between the reports.

    摘要翻译: 公开了用于发现和表示现有报告环境的报告模型的计算机软件。 对于多个报告中的每个报告,软件会搜索报告的元数据以获取描述性信息和依赖于其他报告。 该软件以图形表示描述了每个报告和报告之间的关系。

    Smarter Business Intelligence Systems

    公开(公告)号:US20120290345A1

    公开(公告)日:2012-11-15

    申请号:US13555121

    申请日:2012-07-21

    IPC分类号: G06Q10/06

    CPC分类号: G06F17/27 G06Q10/00

    摘要: An embodiment of the invention provides a method and system for analyzing a plurality of reports. More specifically, a change detection module predicts results of future reports based on past reports and identifies a first report that deviates from its predicted results. A dependency analysis module connected to the change detection module at least one report sharing a dependency with the first report by performing a dependency analysis and/or a usage analysis. The dependency analysis labels the first report and at least one second report as sharing a dependency if the second report deviates from its predicted results. The usage analysis labeling the first report and at least one report analyzed by an analyst as sharing a dependency if the report analyzed by the analyst is analyzed in response to the identification of the first report.

    Discovering a reporting model from an existing reporting environment
    9.
    发明授权
    Discovering a reporting model from an existing reporting environment 有权
    从现有的报告环境中发现报告模型

    公开(公告)号:US09582782B2

    公开(公告)日:2017-02-28

    申请号:US13438903

    申请日:2012-04-04

    IPC分类号: G06T1/00 G06Q10/06

    CPC分类号: G06Q10/0639

    摘要: Computer software is disclosed for discovering and representing a reporting model of an existing reporting environment. For each report in a plurality of reports, the software searches metadata of the report for descriptive information and dependencies on other reports. The software depicts, in a graphical representation, each report and relationships between the reports.

    摘要翻译: 公开了用于发现和表示现有报告环境的报告模型的计算机软件。 对于多个报告中的每个报告,软件会搜索报告的元数据以获取描述性信息和依赖于其他报告。 该软件以图形表示描述了每个报告和报告之间的关系。

    Star and snowflake schemas in extract, transform, load processes
    10.
    发明授权
    Star and snowflake schemas in extract, transform, load processes 有权
    星和雪花图案在提取,转换,加载过程中

    公开(公告)号:US09323815B2

    公开(公告)日:2016-04-26

    申请号:US13618282

    申请日:2012-09-14

    IPC分类号: G06F17/30

    摘要: A computer-implemented method, computer program product and a system for supporting star and snowflake data schemas for use with an Extract, Transform, Load (ETL) process, comprising selecting a data source comprising dimensional data, where the dimensional data comprises at least one source table comprising at least one source column, importing a data model for the dimensional data into a data integration system, analyzing the imported data model to select a star or snowflake target data schema comprising target dimensions and target facts, generating a meta-model representation by mapping at least one source table or source column to each target fact and target dimension, automatically converting the meta-model representation into one or more ETL jobs, and executing the ETL jobs to extract the dimensional data from the data source and loading the dimensional data into the selected target data schema in a target data system.

    摘要翻译: 一种计算机实现的方法,计算机程序产品和用于支持用于与提取,变换,加载(ETL)过程一起使用的星形和雪花数据模式的系统,包括选择包括尺寸数据的数据源,其中所述维数据包括至少一个 源表包括至少一个源列,将维数据的数据模型导入数据集成系统,分析导入的数据模型以选择包括目标维度和目标事实的星形或雪花目标数据模式,生成元模型表示 通过将至少一个源表或源列映射到每个目标事实和目标维度,将元模型表示自动转换为一个或多个ETL作业,以及执行ETL作业以从数据源提取尺寸数据并加载维度 数据到目标数据系统中的所选目标数据模式。