• Pivot Design View

    Published:

    The Pivot Design View allows you to drag + drop the design of your pivot, much like in Excel, from the fields in the underlying SQL Wrapper while seeing the pivot update in real time as you slice and dice your data.

  • Pivot View

    Published:

    The Pivot view enables you to view and edit basic information about the overall Pivot. Pivots are used to analyse any data in the LemonEdge platform, and any external data you want to pull into the LemonEdge platform through custom SQL Wrappers.

  • Pivots

    Published:

    Pivots provide the ability to take any set of data from a SQL Wrapper and slice and dice them in a real time environment much like Excel. These pivots can be saved and re-used throughout the application much like SQL Wrappers, allowing you to place the pivots on custom layouts anywhere for a user to see them immediately when relevant.

  • GetPaths

    Published:

    This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…

  • SQLWrapper Results

    Published:

    SQL Wrapper Results is a dynamic grid that displays allows execution of, and displays all results for, any SQL Wrapper in the system including automatically generated ones such as those created from Datasets. 
    This provides a consistent and easy method for viewing and interacting with results of data.

  • GetTransactions

    Published:

    This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…

  • GetPivotedTransactions

    Published:

    This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…

  • GetPivotedAllocatedTransactions

    Published:

    This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…