Celeriq Reference UI

The reference UI allows you to test queries for validity. It also allows you to view data returned to ensure that your application is pulling data that you think is appropriate. Using this web interface, you can test filters, sorting, rollups, and Piloted Search.

The novel functionality of the Celeriq engine is apparent from the start; the dimension data in the left margin. You can click on any of the dimension headers in the left margin to expose all values for that dimension. In the Autos sample, the Metro dimension might contain values Atlanta, Seattle, Los Angeles, etc. These values can be used as drill downs. When you select one, the data will be filtered down to only the records that match the selected dimension value.

Test your dGraph implementations with the Reference UI. Ensure all aspects of your data model function as designed.

When the page refreshes only a subset of the records will be present, but also the dimension will disappear from the left margin. Since only records that match exactly one value for the selected dimension is displayed, there is no reason to display the dimension anymore. Only dimensions with two or more available values are displayed.

Users will never follow a path to an empty set by drilling down using dimension data. This is due to the deterministic functionality of the engine. It is not possible for a path that renders a null set. Of course, it is possible to setup a filter that gives a null set (zero records), since this is free form text and you can use any value.