-
公开(公告)号:US07970783B2
公开(公告)日:2011-06-28
申请号:US11934442
申请日:2007-11-02
CPC分类号: G06F17/30554 , G06F9/454 , G06F17/30522 , Y10S707/99931 , Y10S707/99934
摘要: A system and method of producing a business report from data contained in a computer based business intelligence system, is provided. The method includes defining one or more macro functions, and producing a report layout containing one or more macrotized database language expressions. The macrotized database language expression having at least one of the macro functions. The method includes produce one or more valid database language expressions for a database query by modifying the one or more macrotized database language expressions in dependence upon the return value of the at least one of the macro functions, and applying the one or more valid database language expressions to one or more database to produce the business report.
摘要翻译: 提供了一种从基于计算机的商业智能系统中包含的数据生成业务报告的系统和方法。 该方法包括定义一个或多个宏函数,以及生成包含一个或多个宏块化数据库语言表达式的报告布局。 具有至少一个宏功能的宏化数据库语言表达式。 该方法包括通过根据至少一个宏功能的返回值修改一个或多个宏化数据库语言表达,并且应用一个或多个有效数据库语言来产生用于数据库查询的一个或多个有效数据库语言表达式 表达式到一个或多个数据库来生成业务报告。
-
公开(公告)号:US20080126326A1
公开(公告)日:2008-05-29
申请号:US11934442
申请日:2007-11-02
IPC分类号: G06F17/30
CPC分类号: G06F17/30554 , G06F9/454 , G06F17/30522 , Y10S707/99931 , Y10S707/99934
摘要: A system and method of producing a business report from data contained in a computer based business intelligence system, is provided. The method includes defining one or more macro functions, and producing a report layout containing one or more macrotized database language expressions. The macrotized database language expression having at least one of the macro functions. The method includes produce one or more valid database language expressions for a database query by modifying the one or more macrotized database language expressions in dependence upon the return value of the at least one of the macro functions, and applying the one or more valid database language expressions to one or more database to produce the business report.
摘要翻译: 提供了一种从基于计算机的商业智能系统中包含的数据生成业务报告的系统和方法。 该方法包括定义一个或多个宏函数,以及生成包含一个或多个宏块化数据库语言表达式的报告布局。 具有至少一个宏功能的宏化数据库语言表达式。 该方法包括通过根据至少一个宏功能的返回值修改一个或多个宏化数据库语言表达,并且应用一个或多个有效数据库语言来产生用于数据库查询的一个或多个有效数据库语言表达式 表达式到一个或多个数据库来生成业务报告。
-
公开(公告)号:US20070299821A1
公开(公告)日:2007-12-27
申请号:US11473657
申请日:2006-06-23
IPC分类号: G06F17/30
CPC分类号: G06F16/248
摘要: A report specification for defining a report and a system and method of producing a report output from a report definition are provided. The report specification comprises a data selection specification for defining one or more sets of data that are to be reported against and a layout specification for defining how the data is to be structured and rendered. The layout specification including elements that are typically defined in a query. The system comprises a report engine for decomposing a report definition into a layout definition and a query set component, a query engine for processing a query results definition of the query set to produce query results to be rendered, and a rendering engine for creating the final report by using the query results and the layout definition. The method comprises the steps of decomposing a report definition into a layout definition and a query set component, processing a query results definition of the query set to produce query results to be rendered, and creating the final report by using the query results and the layout definition.
摘要翻译: 提供了一种用于定义报告的报告规范,以及从报告定义生成报告输出的系统和方法。 报告规范包括用于定义要被报告的一组或多组数据的数据选择规范和用于定义数据如何被构造和呈现的布局规范。 布局规范包括通常在查询中定义的元素。 该系统包括用于将报告定义分解为布局定义和查询集组件的报告引擎,用于处理查询集合的查询结果定义以产生要呈现的查询结果的查询引擎,以及用于创建最终的查询结果的呈现引擎 通过使用查询结果和布局定义进行报告。 该方法包括以下步骤:将报告定义分解为布局定义和查询集组件,处理查询集合的查询结果定义以产生要呈现的查询结果,以及通过使用查询结果和布局来创建最终报告 定义。
-
-