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
            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
            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
            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
            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
            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
            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 :  

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: