OASIS Open Data Protocol (OData) TCIcon indicating the project type

OASIS Open Data Protocol (OData) TC

Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-1218

Enhance hierarchy processing

    Details

    • 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

      Description

      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.

        Attachments

          Issue Links

          Related to

          Bug - A problem which impairs or prevents the functions of the product. ODATA-1377 $all not available for rolling up named hierarchies

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. ODATA-1384 Clarify usage of annotation qualifiers as references to hierarchies

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. ODATA-1391 Enable usage of $this and $root in filter transformation

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. ODATA-1390 Clean up annotation term RecursiveHierarchy

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. ODATA-1392 Point out aggregation of amounts in different currencies

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            gerald.krause1 Gerald Krause created issue -
            gerald.krause1 Gerald Krause made changes -
            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
            mikep Michael Pizzo (Inactive) made changes -
            Status New [ 10000 ] Open [ 1 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment - - edited

            Created PR for mapping hierarchy transformations to SQLite using recursive common table expressions from standard SQL:1999.

            Show
            gerald.krause1 Gerald Krause added a comment - - edited Created PR for mapping hierarchy transformations to SQLite using recursive common table expressions from standard SQL:1999.
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            I copied the document with the text proposal to Onedrive. This version contains the latest changes reflecting our discussion. Here is a read link: https://1drv.ms/w/s!AlFcFKQNWuoXimEA68Q-3rxj1kYP?e=zdzikT

            Show
            gerald.krause1 Gerald Krause added a comment - I copied the document with the text proposal to Onedrive. This version contains the latest changes reflecting our discussion. Here is a read link: https://1drv.ms/w/s!AlFcFKQNWuoXimEA68Q-3rxj1kYP?e=zdzikT
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            Version of the text document reflecting all feedback from the walkthrough completed on Aug 20, 2020 is here: https://1drv.ms/w/s!AlFcFKQNWuoXimvZ8LDIG-AdfOvQ?e=Sg7sxN

            Show
            gerald.krause1 Gerald Krause added a comment - Version of the text document reflecting all feedback from the walkthrough completed on Aug 20, 2020 is here: https://1drv.ms/w/s!AlFcFKQNWuoXimvZ8LDIG-AdfOvQ?e=Sg7sxN
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment - - edited

            depends on ODATA-1377

            Show
            gerald.krause1 Gerald Krause added a comment - - edited depends on ODATA-1377
            gerald.krause1 Gerald Krause made changes -
            Link This issue Related to ODATA-1377 [ ODATA-1377 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment - - edited

            depends on ODATA-1384

            Show
            gerald.krause1 Gerald Krause added a comment - - edited depends on ODATA-1384
            gerald.krause1 Gerald Krause made changes -
            Link This issue Related to ODATA-1384 [ ODATA-1384 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            depends on ODATA-1390

            Show
            gerald.krause1 Gerald Krause added a comment - depends on ODATA-1390
            gerald.krause1 Gerald Krause made changes -
            Link This issue Related to ODATA-1390 [ ODATA-1390 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            depends on ODATA-1391

            Show
            gerald.krause1 Gerald Krause added a comment - depends on ODATA-1391
            gerald.krause1 Gerald Krause made changes -
            Link This issue Related to ODATA-1391 [ ODATA-1391 ]
            gerald.krause1 Gerald Krause made changes -
            Link This issue Related to ODATA-1392 [ ODATA-1392 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            depends on ODATA-1392

            Show
            gerald.krause1 Gerald Krause added a comment - depends on ODATA-1392
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            Created V1.6.3 of the proposal from the walkthrough document and put it into Kavi.

            Show
            gerald.krause1 Gerald Krause added a comment - Created V1.6.3 of the proposal from the walkthrough document and put it into Kavi.
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            Created V1.6.4 with changes triggered by discussion in TC call on Sep-10, 2020

            Show
            gerald.krause1 Gerald Krause added a comment - Created V1.6.4 with changes triggered by discussion in TC call on Sep-10, 2020
            Hide
            Permalink
            mikep Michael Pizzo (Inactive) added a comment -

            Resolved as proposed 2020-9-17

            Show
            mikep Michael Pizzo (Inactive) added a comment - Resolved as proposed 2020-9-17
            mikep Michael Pizzo (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            Hide
            Permalink
            gerald.krause1 Gerald Krause added a comment -

            Supplement: PoCs to validate the mapping of the new hierarchy transformations to SQL, namely Microsoft SQL Server, SQLite and SAP HANA 2:

             

            Show
            gerald.krause1 Gerald Krause added a comment - Supplement: PoCs to validate the mapping of the new hierarchy transformations to SQL, namely Microsoft SQL Server , SQLite and SAP HANA 2 :  
            gerald.krause1 Gerald Krause made changes -
            Environment Proposed Applied
            gerald.krause1 Gerald Krause made changes -
            Resolution https://github.com/oasis-tcs/odata-vocabularies/pull/121
            handl Ralf Handl made changes -
            Status Resolved [ 5 ] Applied [ 10002 ]
            heiko.theissen Heiko Theissen made changes -
            Status Applied [ 10002 ] Closed [ 6 ]

              People

              • Assignee:
                Unassigned
                Reporter:
                gerald.krause1 Gerald Krause
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: