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

            Activity

            Hide
            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
            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
            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
            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
            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
            gerald.krause1 Gerald Krause added a comment -

            depends on ODATA-1390

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

            depends on ODATA-1391

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

            depends on ODATA-1392

            Show
            gerald.krause1 Gerald Krause added a comment - depends on ODATA-1392
            Hide
            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
            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
            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
            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: