发明名称 |
SYSTEMS AND METHODS FOR PROVIDING VALUE HIERARCHIES, RAGGED HIERARCHIES AND SKIP-LEVEL HIERARCHIES IN A BUSINESS INTELLIGENCE SERVER |
摘要 |
A business intelligence (BI) server and repository are described which support a set of hierarchical relationships among the data. The BI server receives user input specifying a set of parent-child or other ancestral relationship among a set of data in a data source. The BI server generates a set of SQL queries and executes the queries to pre-populate a set of tables which specify the parent child relationships among the data in the data source. One such table is a parent-child relationship closure table that defines the inter-member relationships among the data members. Once the tables are populated, the BI server uses the closure tables to answer queries that require knowledge of the ancestral relationships among data. |
申请公布号 |
US2011295836(A1) |
申请公布日期 |
2011.12.01 |
申请号 |
US201113038231 |
申请日期 |
2011.03.01 |
申请人 |
BOLSIUS ROGER;VENKATASUBRAMANIAN RAGHURAM;NI LING;DONJERKOVIC DONKO;CHOWDHURY SAUGATA;ORACLE INTERNATIONAL CORPORATION |
发明人 |
BOLSIUS ROGER;VENKATASUBRAMANIAN RAGHURAM;NI LING;DONJERKOVIC DONKO;CHOWDHURY SAUGATA |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|