-
Type:
New Feature
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: V4.0_CSD03
-
Fix Version/s: V4.0_CSD04
-
Component/s: Data Aggregation
-
Labels:None
-
Environment:
Applied
-
Proposal:
-
Resolution:
Working with hierarchies often involves functionality to select sub-hierarchies, to retrieve hierarchy nodes in a specified tree order, and to aggregate bottom-up along the hierarchy paths.
- Related to
-
ODATA-1377 $all not available for rolling up named hierarchies
-
- Closed
-
-
ODATA-1384 Clarify usage of annotation qualifiers as references to hierarchies
-
- Closed
-
-
ODATA-1391 Enable usage of $this and $root in filter transformation
-
- Closed
-
-
ODATA-1390 Clean up annotation term RecursiveHierarchy
-
- Closed
-
-
ODATA-1392 Point out aggregation of amounts in different currencies
-
- Closed
-
Field | Original Value | New Value |
---|---|---|
Proposal | Context, use cases and proposals for new transformations {{add_ancestors}}, {{add_descendants}}, {{traverse}} and {{aggregate_hierarchy}} are described in the document [https://www.oasis-open.org/committees/document.php?document_id=63899&wg_abbrev=odata] | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/committees/document.php?document_id=63899&wg_abbrev=odata] |
Description | Working with recursive hierarchies often involves functionality to select sub-hierarchies, to retrieve hierarchy nodes in a specified tree order, and to aggregate bottom-up along the hierarchy paths. | Working with hierarchies often involves functionality to select sub-hierarchies, to retrieve hierarchy nodes in a specified tree order, and to aggregate bottom-up along the hierarchy paths. |
Summary | Transformations for recursive hierarchy processing | Enhance hierarchy processing |
Proposal | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/committees/document.php?document_id=63899&wg_abbrev=odata] | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Proposal | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65438/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Proposal | Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx]
Examples: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65459/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx |
Proposal |
Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65458/Enhanced%20support%20for%20hierarchy%20use%20cases.docx]
Examples: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65459/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx |
Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65474/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65474/Enhanced%20support%20for%20hierarchy%20use%20cases.docx]
Examples: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65475/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx |
Status | New [ 10000 ] | Open [ 1 ] |
Proposal |
Context, use cases and proposals for new transformations are described in the document [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65474/Enhanced%20support%20for%20hierarchy%20use%20cases.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65474/Enhanced%20support%20for%20hierarchy%20use%20cases.docx]
Examples: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65475/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65935/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Proposal |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65935/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67260/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Proposal |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67260/Enhanced%20support%20for%20hierarchy%20use%20cases.docx] |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67397/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.2.docx] |
Link |
This issue Related to |
Link |
This issue Related to |
Link |
This issue Related to |
Link |
This issue Related to |
Link |
This issue Related to |
Proposal |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67397/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.2.docx] |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67699/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.3.docx] |
Proposal |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67699/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.3.docx] |
Overview and examples: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx]
Context, use cases and proposals for new transformations: [https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67700/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.3.docx|https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67699/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.3.docx] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Environment | Proposed | Applied |
Status | Resolved [ 5 ] | Applied [ 10002 ] |
Status | Applied [ 10002 ] | Closed [ 6 ] |
Created PR for mapping hierarchy transformations to SQLite using recursive common table expressions from standard SQL:1999.