• Query Runner Parameters View

    Published:

    The Query Runner Parameters view is used to create all the parameters that can be used by each query runner step as parameters they can pass to their process.

  • Where Filters View

    Published:

    Venn Set Where Filters allow you to create a hierarchical where filter to apply to your Queryable Item to ensure you get only the results you require as efficiently as possible. These filters can apply against the Venn Set parameters, and against any field for that queryable item your filtering in the query.

  • Venn Set View

    Published:

    The Venn Set view enables you to view and edit basic information about an overall Venn Set. Venn Sets are used to combine multiple queries of the same shape into one merged dataset. Each Venn Set creates an underlying SQL Wrapper [see here] for retrieving the data and interacting with it throughout the LemonEdge platform.

  • Queryable Items View

    Published:

    Venn Set Queryable Items allow you to specify multiple sets of data you want to merge into one cohesive result set. The sets of data you can include in a Venn Set come from 2 main sources; Entities, History, and Queries themselves. The last one allowing you to include other Venn Sets themselves within a venn set.

  • Columns View

    Published:

    The Venn Set Column view allows you to specify precisely which columns you would like returned in your Venn Set for each of the individual Queryable Items to be merged in the Venn Set. This allows you to ensure each Queryable Item has the same data structure, before being merged, in an intuitive and easy to follow way.

  • Report Parameters View

    Published:

    The Report Parameters view is used to create all the parameters that must be passed to the 3rd party report in order to execute it and produce a report output file.

  • SSRS Report View

    Published:

    The SSRS Report view enables you to view and edit all the information required for connecting to, and executing, a SSRS report.

  • Reports View

    Published:

    The Report view enables you to view and edit basic information about any Report, regardless of the custom type of 3rd party reporting services it may connect to. Reports are used to reach 3rd party reporting services and connect to them to call and execute custom reports passing any relevant parameters from the system.