CN100568237C - 多维企业软件***中的报表模板生成方法和*** - Google Patents
多维企业软件***中的报表模板生成方法和*** Download PDFInfo
- Publication number
- CN100568237C CN100568237C CNB2005800474558A CN200580047455A CN100568237C CN 100568237 C CN100568237 C CN 100568237C CN B2005800474558 A CNB2005800474558 A CN B2005800474558A CN 200580047455 A CN200580047455 A CN 200580047455A CN 100568237 C CN100568237 C CN 100568237C
- Authority
- CN
- China
- Prior art keywords
- report form
- form template
- data
- template
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
列 | 描述 |
对象名称 | 包含用于存储模板对象(如立方体和维度)的表格的名称。 |
显示名称 | 包含用户12在企业应用程序中所看到的、模 |
板对象(如立方体和维度)的显示名称。 | |
对象id | 包含模板对象的全球唯一标识符(GUID)。 |
对象类型id | 包含对象类型标识符,其标识这一行所描述的是哪一类型的表格。 |
数据存储类型id | 包含数据存储对象类型标识符,其表示这一行所描述的是什么类型的数据库对象,例如数据库TABLE或数据库VIEW。 |
对象版本 | 指定用来创建对象的企业软件的版本。 |
最后保存的 | 包含对象最后被发布时的时戳。这列是可选的。 |
库id | 包含用来创建该对象的企业软件库的标识符。这列是可选的。 |
列 | 描述 |
对象名称 | 包含模板对象的表格的名称。对象名称是与在应用对象表格的对象名称列中发现的相同的名称。 |
列名称 | 包含用于发布对象的表格中所包含的列的名称。 |
显示名称 | 包含用户在企业应用程序中所看到的显示名称,以与包含在用于发布规划对象的表格中的列相关。这实质是列的可读名称,以代替在数据库***中使用的名称,其中数据库***可能具有对某些字符的限制。 |
列id | 这是与包含在用于发布规划对象的表格中的列相关的GUID。 |
对象类型id | 包含包含该列的表格的对象类型id。 |
列类型id | 包含用于该列的独立的数据类型标识符。该标识符例如可以是TEXT_VALUE或FLOAT_VALUE。 |
列顺序 | 包含在用于发布规划对象的表格中该列的顺序。这被用来对列的显示进行排序。 |
逻辑数据类型 | 包含用于该列的RDBMS独立类型标识符。 |
维度guid | 包含格式化的列的维度的GUID。 |
项目id | 具有数据类型和格式的列的GUID。 |
格式类型 | 列的数据类型。如数字,数据或百分比。 |
负标记符号 | 用于代表负值的符号。 |
小数位的数量 | 要显示的小数位(或精度)的数量。 |
缩放比例因数 | 数字值的缩放比例因数。 |
零值字符 | 用于表示等于0的值的字符。 |
Claims (24)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/999,807 US7505888B2 (en) | 2004-11-30 | 2004-11-30 | Reporting model generation within a multidimensional enterprise software system |
US10/999,807 | 2004-11-30 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101111839A CN101111839A (zh) | 2008-01-23 |
CN100568237C true CN100568237C (zh) | 2009-12-09 |
Family
ID=36568338
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2005800474558A Expired - Fee Related CN100568237C (zh) | 2004-11-30 | 2005-11-16 | 多维企业软件***中的报表模板生成方法和*** |
Country Status (6)
Country | Link |
---|---|
US (2) | US7505888B2 (zh) |
EP (1) | EP1817699A4 (zh) |
CN (1) | CN100568237C (zh) |
AU (1) | AU2005315254B2 (zh) |
CA (1) | CA2588757A1 (zh) |
WO (1) | WO2006064382A2 (zh) |
Families Citing this family (77)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7610300B2 (en) * | 2004-11-30 | 2009-10-27 | International Business Machines Corporation | Automated relational schema generation within a multidimensional enterprise software system |
US7593955B2 (en) * | 2004-11-30 | 2009-09-22 | International Business Machines Corporation | Generation of aggregatable dimension information within a multidimensional enterprise software system |
US7505888B2 (en) * | 2004-11-30 | 2009-03-17 | International Business Machines Corporation | Reporting model generation within a multidimensional enterprise software system |
US8479093B2 (en) * | 2007-03-01 | 2013-07-02 | Microsoft Corporation | Metamodel-based automatic report generation |
US20080222189A1 (en) * | 2007-03-06 | 2008-09-11 | Microsoft Corporation | Associating multidimensional data models |
US20090287737A1 (en) * | 2007-10-31 | 2009-11-19 | Wayne Hammerly | Architecture for enabling rapid database and application development |
US8200618B2 (en) * | 2007-11-02 | 2012-06-12 | International Business Machines Corporation | System and method for analyzing data in a report |
US8838652B2 (en) * | 2008-03-18 | 2014-09-16 | Novell, Inc. | Techniques for application data scrubbing, reporting, and analysis |
US8874502B2 (en) * | 2008-08-29 | 2014-10-28 | Red Hat, Inc. | Real time datamining |
US10102262B2 (en) | 2008-08-29 | 2018-10-16 | Red Hat, Inc. | Creating reports using dimension trees |
EP2335147A4 (en) * | 2008-10-07 | 2012-06-13 | Zap Holdings Ltd | SYNCHRONIZATION OF RELATIONAL DATABASES WITH OLAP DICES |
US8892501B2 (en) * | 2009-05-08 | 2014-11-18 | Sap Se | Capturing OLAP analysis thread as refreshable business intelligence data |
US8521755B2 (en) * | 2009-08-31 | 2013-08-27 | Accenture Global Services Limited | Flexible cube data warehousing |
CN102279848B (zh) * | 2010-06-09 | 2015-04-01 | 中国电信股份有限公司 | 生成报表模板的方法与装置 |
US20120102453A1 (en) * | 2010-10-21 | 2012-04-26 | Microsoft Corporation | Multi-dimensional objects |
CA2718701A1 (en) | 2010-10-29 | 2011-01-10 | Ibm Canada Limited - Ibm Canada Limitee | Using organizational awareness in locating business intelligence |
JP5490253B2 (ja) * | 2010-11-02 | 2014-05-14 | インターナショナル・ビジネス・マシーンズ・コーポレーション | 数値集約計算における文字列集約方法 |
US9123003B2 (en) * | 2011-06-15 | 2015-09-01 | Hewlett-Packard Development Company, L.P. | Topologies corresponding to models for hierarchy of nodes |
US8799207B1 (en) | 2011-10-08 | 2014-08-05 | Bay Dynamics | Unified data source management |
US8909680B1 (en) | 2011-10-08 | 2014-12-09 | Bay Dynamics | Intelligent caching of multidimensional cube data |
US9390082B1 (en) | 2011-10-08 | 2016-07-12 | Bay Dynamics, Inc. | Generating multiple views of a multidimensional cube |
US8965836B1 (en) | 2011-10-08 | 2015-02-24 | Bay Dynamics | Management of multidimensional data storage cubes using content packs |
US9183269B1 (en) | 2011-10-08 | 2015-11-10 | Bay Dynamics, Inc. | Federated multidimensional data storage cubes |
US9171055B1 (en) | 2011-10-08 | 2015-10-27 | Bay Dynamics, Inc. | Content packs for multidimensional data storage cubes |
US10353922B1 (en) | 2011-10-08 | 2019-07-16 | Bay Dynamics, Inc. | Rendering multidimensional cube data |
US9330091B1 (en) | 2011-10-08 | 2016-05-03 | Bay Dynamics, Inc. | System for managing data storages |
US9081830B1 (en) | 2011-10-08 | 2015-07-14 | Bay Dynamics | Updating a view of a multidimensional cube |
CN102842065A (zh) * | 2012-07-23 | 2012-12-26 | 国电南京自动化股份有限公司 | 一种基于指标建模的指标数据填报方法 |
GB201216645D0 (en) * | 2012-09-18 | 2012-10-31 | Univ Nottingham | Surface plasmon microscopy |
US9507825B2 (en) | 2012-09-28 | 2016-11-29 | Oracle International Corporation | Techniques for partition pruning based on aggregated zone map information |
US8996544B2 (en) | 2012-09-28 | 2015-03-31 | Oracle International Corporation | Pruning disk blocks of a clustered table in a relational database management system |
US9430550B2 (en) | 2012-09-28 | 2016-08-30 | Oracle International Corporation | Clustering a table in a relational database management system |
US9240061B2 (en) * | 2012-10-02 | 2016-01-19 | International Business Machines Corporation | Pattern representation images for business intelligence dashboard objects |
US20140136295A1 (en) | 2012-11-13 | 2014-05-15 | Apptio, Inc. | Dynamic recommendations taken over time for reservations of information technology resources |
US10235649B1 (en) * | 2014-03-14 | 2019-03-19 | Walmart Apollo, Llc | Customer analytics data model |
US10642837B2 (en) | 2013-03-15 | 2020-05-05 | Oracle International Corporation | Relocating derived cache during data rebalance to maintain application performance |
US10997556B2 (en) | 2013-04-08 | 2021-05-04 | Oracle International Corporation | Summarizing tabular data across multiple projects using user-defined attributes |
CN104102670A (zh) * | 2013-04-12 | 2014-10-15 | Sap股份公司 | 绩效指标分析框架 |
US10417591B2 (en) | 2013-07-03 | 2019-09-17 | Apptio, Inc. | Recursive processing of object allocation rules |
CN103390033A (zh) * | 2013-07-09 | 2013-11-13 | 天津南大通用数据技术股份有限公司 | 商务智能数据模板及其生成、混合及离线使用方法 |
US10325232B2 (en) | 2013-09-20 | 2019-06-18 | Apptio, Inc. | Allocating heritage information in data models |
CN103793464A (zh) * | 2013-12-19 | 2014-05-14 | 国家电网公司 | 一种基于中立格式的报表导出方法 |
US11244364B2 (en) | 2014-02-13 | 2022-02-08 | Apptio, Inc. | Unified modeling of technology towers |
US10733555B1 (en) | 2014-03-14 | 2020-08-04 | Walmart Apollo, Llc | Workflow coordinator |
US10565538B1 (en) | 2014-03-14 | 2020-02-18 | Walmart Apollo, Llc | Customer attribute exemption |
US10346769B1 (en) | 2014-03-14 | 2019-07-09 | Walmart Apollo, Llc | System and method for dynamic attribute table |
US10235687B1 (en) | 2014-03-14 | 2019-03-19 | Walmart Apollo, Llc | Shortest distance to store |
US10204150B2 (en) * | 2014-03-21 | 2019-02-12 | Sap Se | Simplified hierarchy definition for multidimensional data analysis |
CN105320690B (zh) * | 2014-07-30 | 2018-09-25 | 北京中海纪元数字技术发展股份有限公司 | 一种基于元数据的统计表单快速生成方法及*** |
US11288290B2 (en) * | 2014-12-18 | 2022-03-29 | Ab Initio Technology Llc | Building reports |
US11151493B2 (en) | 2015-06-30 | 2021-10-19 | Apptio, Inc. | Infrastructure benchmarking based on dynamic cost modeling |
US10437793B2 (en) | 2015-07-24 | 2019-10-08 | Oracle International Corporation | BI cloud services data modeling denormalized table introspection algorithm |
US10268979B2 (en) | 2015-09-28 | 2019-04-23 | Apptio, Inc. | Intermediate resource allocation tracking in data models |
US10387815B2 (en) | 2015-09-29 | 2019-08-20 | Apptio, Inc. | Continuously variable resolution of resource allocation |
US10733155B2 (en) | 2015-10-23 | 2020-08-04 | Oracle International Corporation | System and method for extracting a star schema from tabular data for use in a multidimensional database environment |
JP6846356B2 (ja) * | 2015-10-23 | 2021-03-24 | オラクル・インターナショナル・コーポレイション | 表形式データから、多次元データベース環境に使用されるキューブスキーマを自動的に推論するためのシステムおよび方法 |
US10726367B2 (en) | 2015-12-28 | 2020-07-28 | Apptio, Inc. | Resource allocation forecasting |
US9948655B1 (en) * | 2016-04-15 | 2018-04-17 | AtScale, Inc. | Data access authorization for dynamically generated database structures |
US10474974B2 (en) | 2016-09-08 | 2019-11-12 | Apptio, Inc. | Reciprocal models for resource allocation |
US10936978B2 (en) | 2016-09-20 | 2021-03-02 | Apptio, Inc. | Models for visualizing resource allocation |
CN106446184B (zh) * | 2016-09-29 | 2019-03-26 | ***股份有限公司 | 业务***数据处理方法及装置 |
US10482407B2 (en) | 2016-11-14 | 2019-11-19 | Apptio, Inc. | Identifying resource allocation discrepancies |
US10157356B2 (en) | 2016-12-14 | 2018-12-18 | Apptio, Inc. | Activity based resource allocation modeling |
CA2999581A1 (en) * | 2017-03-28 | 2018-09-28 | Walmart Apollo, Llc | Systems and methods for computer assisted database change documentation |
US11086876B2 (en) | 2017-09-29 | 2021-08-10 | Oracle International Corporation | Storing derived summaries on persistent memory of a storage device |
CN107944811B (zh) * | 2017-10-19 | 2019-06-21 | 陈伟麟 | 一种加油机计量检定和校准原始记录处理方法及*** |
US10324951B1 (en) | 2017-12-29 | 2019-06-18 | Apptio, Inc. | Tracking and viewing model changes based on time |
US10268980B1 (en) * | 2017-12-29 | 2019-04-23 | Apptio, Inc. | Report generation based on user responsibility |
US11775552B2 (en) | 2017-12-29 | 2023-10-03 | Apptio, Inc. | Binding annotations to data objects |
CN108229976A (zh) * | 2018-01-10 | 2018-06-29 | 北京掌阔移动传媒科技有限公司 | 一种数据可视化反作弊***数据模型维度调整处理方法 |
CN108959230B (zh) * | 2018-07-24 | 2021-11-26 | 郑州云海信息技术有限公司 | 一种生成报表模板的方法和装置 |
US10901987B2 (en) * | 2018-12-14 | 2021-01-26 | Sap Se | Dynamic automatic generation of database views |
CN110096683A (zh) * | 2019-03-15 | 2019-08-06 | 中国平安人寿保险股份有限公司 | 报表生成方法、***、计算机装置及计算机可读存储介质 |
CN112883695B (zh) * | 2019-11-29 | 2024-07-16 | 比亚迪股份有限公司 | 生成报表模板和显示数据报表的方法、装置、设备和介质 |
CN111310434B (zh) * | 2020-02-28 | 2024-01-19 | 北京金堤科技有限公司 | 文本生成方法和装置、电子设备和存储介质 |
CN111859884A (zh) * | 2020-05-29 | 2020-10-30 | 大数金科网络技术有限公司 | 审批数据全历史栈统计方法 |
CN114023415B (zh) * | 2021-11-08 | 2024-07-23 | 深圳航天智慧城市***技术研究院有限公司 | 基于在线可编辑定制化的动态文档模版生成方法及*** |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5721910A (en) * | 1996-06-04 | 1998-02-24 | Exxon Research And Engineering Company | Relational database system containing a multidimensional hierachical model of interrelated subject categories with recognition capabilities |
US5978796A (en) * | 1997-06-30 | 1999-11-02 | International Business Machines Corporation | Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database |
CN1347529A (zh) * | 1999-01-15 | 2002-05-01 | 米泰吉公司 | 数据仓库环境下使信息可视化的方法 |
US6385604B1 (en) * | 1999-08-04 | 2002-05-07 | Hyperroll, Israel Limited | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements |
US6594672B1 (en) * | 2000-06-01 | 2003-07-15 | Hyperion Solutions Corporation | Generating multidimensional output using meta-models and meta-outlines |
CN1492336A (zh) * | 2003-09-04 | 2004-04-28 | 上海格尔软件股份有限公司 | 基于数据仓库的信息安全审计方法 |
CN1492355A (zh) * | 2002-10-25 | 2004-04-28 | 鸿富锦精密工业(深圳)有限公司 | 专利分析报告自动生成***及方法 |
Family Cites Families (53)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5379419A (en) | 1990-12-07 | 1995-01-03 | Digital Equipment Corporation | Methods and apparatus for accesssing non-relational data files using relational queries |
US5734887A (en) | 1995-09-29 | 1998-03-31 | International Business Machines Corporation | Method and apparatus for logical data access to a physical relational database |
US5692181A (en) | 1995-10-12 | 1997-11-25 | Ncr Corporation | System and method for generating reports from a computer database |
US5870746A (en) | 1995-10-12 | 1999-02-09 | Ncr Corporation | System and method for segmenting a database based upon data attributes |
JP3952518B2 (ja) | 1996-03-29 | 2007-08-01 | 株式会社日立製作所 | 多次元データ処理方法 |
US5978788A (en) | 1997-04-14 | 1999-11-02 | International Business Machines Corporation | System and method for generating multi-representations of a data cube |
US6205447B1 (en) | 1997-06-30 | 2001-03-20 | International Business Machines Corporation | Relational database management of multi-dimensional data |
US6134541A (en) | 1997-10-31 | 2000-10-17 | International Business Machines Corporation | Searching multidimensional indexes using associated clustering and dimension reduction information |
US5918232A (en) | 1997-11-26 | 1999-06-29 | Whitelight Systems, Inc. | Multidimensional domain modeling method and system |
JP2000048547A (ja) * | 1998-07-29 | 2000-02-18 | Sony Corp | 記録媒体の記録再生システム |
CA2344638A1 (en) | 1998-09-30 | 2000-04-06 | I2 Technologies, Inc. | Multi-dimensional data management system |
US6282544B1 (en) | 1999-05-24 | 2001-08-28 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
US6477536B1 (en) | 1999-06-22 | 2002-11-05 | Microsoft Corporation | Virtual cubes |
US6707454B1 (en) | 1999-07-01 | 2004-03-16 | Lucent Technologies Inc. | Systems and methods for visualizing multi-dimensional data in spreadsheets and other data structures |
CA2281331A1 (en) | 1999-09-03 | 2001-03-03 | Cognos Incorporated | Database management system |
US6510420B1 (en) | 1999-09-30 | 2003-01-21 | International Business Machines Corporation | Framework for dynamic hierarchical grouping and calculation based on multidimensional member characteristics |
US7328206B2 (en) | 1999-10-15 | 2008-02-05 | Microsoft Corporation | Extensions for adding and removing calculated members in a multidimensional database |
GB9924523D0 (en) | 1999-10-15 | 1999-12-15 | Univ Strathclyde | Database processor |
US6484179B1 (en) | 1999-10-25 | 2002-11-19 | Oracle Corporation | Storing multidimensional data in a relational database management system |
US6418427B1 (en) | 1999-12-30 | 2002-07-09 | Decode Genetics Ehf | Online modifications of dimension structures in multidimensional processing |
US20020029207A1 (en) * | 2000-02-28 | 2002-03-07 | Hyperroll, Inc. | Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein |
US6768986B2 (en) * | 2000-04-03 | 2004-07-27 | Business Objects, S.A. | Mapping of an RDBMS schema onto a multidimensional data model |
CA2311884A1 (en) | 2000-06-16 | 2001-12-16 | Cognos Incorporated | Method of managing slowly changing dimensions |
AU2001287044A1 (en) * | 2000-09-05 | 2002-03-22 | Big Think Llc | System and method for personalization implemented on multiple networks and multiple interfaces |
US6801921B2 (en) * | 2000-09-08 | 2004-10-05 | Hitachi, Ltd. | Method and system for managing multiple database storage units |
US6829621B2 (en) | 2000-10-06 | 2004-12-07 | International Business Machines Corporation | Automatic determination of OLAP cube dimensions |
US7287218B1 (en) | 2000-10-25 | 2007-10-23 | Bea Systems, Inc. | Dynamic publication of information from a database |
US7039871B2 (en) | 2000-10-27 | 2006-05-02 | Swiftknowledge, Inc. | Secure data access in a multidimensional data environment |
US6714940B2 (en) | 2001-11-15 | 2004-03-30 | International Business Machines Corporation | Systems, methods, and computer program products to rank and explain dimensions associated with exceptions in multidimensional data |
US7028046B2 (en) * | 2002-03-19 | 2006-04-11 | Hyperion Solutions Corporation | Method of splitting a multi-dimensional cube between a multi-dimensional and a relational database |
US6691102B2 (en) | 2002-03-26 | 2004-02-10 | International Business Machines Corporation | Query processing method of name-value pairs in relational databases |
US7171427B2 (en) | 2002-04-26 | 2007-01-30 | Oracle International Corporation | Methods of navigating a cube that is implemented as a relational object |
US8868544B2 (en) | 2002-04-26 | 2014-10-21 | Oracle International Corporation | Using relational structures to create and support a cube within a relational database system |
US7366730B2 (en) | 2002-04-26 | 2008-04-29 | Oracle International Corporation | Registration of solved cubes within a relational database management system |
US6965903B1 (en) | 2002-05-07 | 2005-11-15 | Oracle International Corporation | Techniques for managing hierarchical data with link attributes in a relational database |
US20040181519A1 (en) | 2002-07-09 | 2004-09-16 | Mohammed Shahbaz Anwar | Method for generating multidimensional summary reports from multidimensional summary reports from multidimensional data |
JP2004094425A (ja) | 2002-08-30 | 2004-03-25 | Hitachi Ltd | データベース構築処理変更方法 |
US6768995B2 (en) | 2002-09-30 | 2004-07-27 | Adaytum, Inc. | Real-time aggregation of data within an enterprise planning environment |
US7072822B2 (en) | 2002-09-30 | 2006-07-04 | Cognos Incorporated | Deploying multiple enterprise planning models across clusters of application servers |
US7467125B2 (en) | 2002-12-12 | 2008-12-16 | International Business Machines Corporation | Methods to manage the display of data entities and relational database structures |
US7716167B2 (en) | 2002-12-18 | 2010-05-11 | International Business Machines Corporation | System and method for automatically building an OLAP model in a relational database |
US7181450B2 (en) | 2002-12-18 | 2007-02-20 | International Business Machines Corporation | Method, system, and program for use of metadata to create multidimensional cubes in a relational database |
US7953694B2 (en) | 2003-01-13 | 2011-05-31 | International Business Machines Corporation | Method, system, and program for specifying multidimensional calculations for a relational OLAP engine |
US20040193633A1 (en) | 2003-03-28 | 2004-09-30 | Cristian Petculescu | Systems, methods, and apparatus for automated dimensional model definitions and builds utilizing simplified analysis heuristics |
US7089266B2 (en) * | 2003-06-02 | 2006-08-08 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
US7756907B2 (en) | 2003-09-16 | 2010-07-13 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for visualizing data |
US7593969B2 (en) | 2003-12-31 | 2009-09-22 | Microsoft Corporation | Linked dimension and measure groups |
US7562086B2 (en) | 2004-07-09 | 2009-07-14 | Microsoft Corporation | Custom grouping for dimension members |
US7844570B2 (en) | 2004-07-09 | 2010-11-30 | Microsoft Corporation | Database generation systems and methods |
US7505888B2 (en) | 2004-11-30 | 2009-03-17 | International Business Machines Corporation | Reporting model generation within a multidimensional enterprise software system |
US7610300B2 (en) | 2004-11-30 | 2009-10-27 | International Business Machines Corporation | Automated relational schema generation within a multidimensional enterprise software system |
US7593955B2 (en) | 2004-11-30 | 2009-09-22 | International Business Machines Corporation | Generation of aggregatable dimension information within a multidimensional enterprise software system |
US7418438B2 (en) | 2004-11-30 | 2008-08-26 | International Business Machines Corporation | Automated default dimension selection within a multidimensional enterprise software system |
-
2004
- 2004-11-30 US US10/999,807 patent/US7505888B2/en not_active Expired - Fee Related
-
2005
- 2005-11-16 AU AU2005315254A patent/AU2005315254B2/en not_active Ceased
- 2005-11-16 WO PCT/IB2005/004137 patent/WO2006064382A2/en active Application Filing
- 2005-11-16 CA CA002588757A patent/CA2588757A1/en not_active Abandoned
- 2005-11-16 CN CNB2005800474558A patent/CN100568237C/zh not_active Expired - Fee Related
- 2005-11-16 EP EP05850813A patent/EP1817699A4/en not_active Withdrawn
-
2009
- 2009-01-08 US US12/350,838 patent/US8131533B2/en not_active Expired - Fee Related
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5721910A (en) * | 1996-06-04 | 1998-02-24 | Exxon Research And Engineering Company | Relational database system containing a multidimensional hierachical model of interrelated subject categories with recognition capabilities |
US5978796A (en) * | 1997-06-30 | 1999-11-02 | International Business Machines Corporation | Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database |
CN1347529A (zh) * | 1999-01-15 | 2002-05-01 | 米泰吉公司 | 数据仓库环境下使信息可视化的方法 |
US6385604B1 (en) * | 1999-08-04 | 2002-05-07 | Hyperroll, Israel Limited | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements |
US6594672B1 (en) * | 2000-06-01 | 2003-07-15 | Hyperion Solutions Corporation | Generating multidimensional output using meta-models and meta-outlines |
CN1492355A (zh) * | 2002-10-25 | 2004-04-28 | 鸿富锦精密工业(深圳)有限公司 | 专利分析报告自动生成***及方法 |
CN1492336A (zh) * | 2003-09-04 | 2004-04-28 | 上海格尔软件股份有限公司 | 基于数据仓库的信息安全审计方法 |
Also Published As
Publication number | Publication date |
---|---|
US20090164508A1 (en) | 2009-06-25 |
EP1817699A4 (en) | 2007-12-05 |
CA2588757A1 (en) | 2006-06-22 |
WO2006064382A3 (en) | 2006-09-21 |
US7505888B2 (en) | 2009-03-17 |
CN101111839A (zh) | 2008-01-23 |
US20060116859A1 (en) | 2006-06-01 |
AU2005315254A1 (en) | 2006-06-22 |
AU2005315254B2 (en) | 2009-11-05 |
US8131533B2 (en) | 2012-03-06 |
EP1817699A2 (en) | 2007-08-15 |
WO2006064382A2 (en) | 2006-06-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN100568237C (zh) | 多维企业软件***中的报表模板生成方法和*** | |
CN101111835B (zh) | 多维企业软件***中的自动默认维度选择方法 | |
CN101111838B (zh) | 多维企业软件***中的自动关系模式生成 | |
CN101167048B (zh) | 多维企业软件***内的可聚集维度信息的生成 | |
CN101084494B (zh) | 用于管理计算机环境中的工作流的方法和设备 | |
US20100131457A1 (en) | Flattening multi-dimensional data sets into de-normalized form | |
Hancock et al. | Practical Business Intelligence with SQL Server 2005 | |
CN110633267A (zh) | 一种可支持多业务行使报表功能的方法及*** | |
Albano | Decision support databases essentials | |
El Beggar et al. | Towards an MDA-oriented UML profiles for data warehouses design and development | |
Rifaie et al. | Data modelling for effective data warehouse architecture and design | |
Leonard | Design and implementation of an enterprise data warehouse | |
Shikhli et al. | Data Acquisition Model for Analyzing Schedule Delays Using KDD: Knowledge Discovery and Datamining | |
Hoppe | Sales and inventory planning with SAP APO | |
Prakash et al. | Requirements Engineering for Data Warehousing | |
Cardoso et al. | A decision support system for IST academic information | |
Saadouli et al. | Supply chain optimization: bibliometric analysis, research structure and future outlook | |
Gath | Principle of Data warehousing | |
Tran | Building a Database for a Startup: BoltAbout | |
Langer et al. | Data Analytics and Data Warehouses | |
Li | Data warehouse design: an investigation of star schema | |
Radut et al. | Designing a Data Warehouse. Case Study: SC “AMBIENT” SA | |
Ismail | Framework and database for organizing external information for strategic management in the construction industry: application to the Egyptian market | |
Langer et al. | Data Warehousing | |
Pletch et al. | The account data model |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20081219 Address after: American New York Applicant after: International Business Machines Corp. Address before: Amsterdam, The Netherlands Applicant before: IBM International Group Effective date of registration: 20081219 Address after: Amsterdam, The Netherlands Applicant after: IBM International Group Address before: Alberta Canada Applicant before: Coorg Los Unlimited Co. Effective date of registration: 20081219 Address after: Alberta Canada Applicant after: Coorg Los Unlimited Co. Address before: American Minnesota Applicant before: Cognos Inc. |
|
ASS | Succession or assignment of patent right |
Owner name: IBM INTERNATIONAL GROUP CO.,LTD. Free format text: FORMER OWNER: CARL LOEWS CO.,LTD. Effective date: 20081219 Owner name: INTERNATIONAL BUSINESS MACHINE CORP. Free format text: FORMER OWNER: IBM INTERNATIONAL GROUP CO.,LTD. Effective date: 20081219 |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20091209 Termination date: 20181116 |
|
CF01 | Termination of patent right due to non-payment of annual fee |