Reporting (57)
Reporting enables you to get any piece of data out of the system in any shape you like. Our tools allow you to work with that data, transform it, or export it to 3rd party systems.
Query Runner Parameters View
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
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
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
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
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.
Venn Sets
Venn Sets allow you to combine multiple queries together into one query, through set operators such as union, intersect and except. Like Datasets, this also automatically creates an underlying SQL Wrapper for the resulting query that can be incorporated and called throughout the LemonEdge platform.
Report Parameters View
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
The SSRS Report view enables you to view and edit all the information required for connecting to, and executing, a SSRS report.