Multi-table query

With the successful deployment of the Excel Server-based information system within an organization, there are increasing demands for building many sorts of queries against the huge amount of accumulated data in a flexible way, to help acquire deeper insight into the business information brought by these data. The newly added feature of multi-table query is just to help on this.

How to use:

1.       Select the “Query” => “New query” menu items in My Workbench.

2.       Create a new query

The queries created will be listed in My Workbench just as the templates, and they can be used in the same way like the templates as well, yet the speed at which a query is running is usually much higher than that of a template.

3.       Manage and update existing queries

An existing query can be deleted, saved as a new version, or be changed regarding its definition.

4.       Use a query

Queries can be used directly within My Workbench. By clicking the query’s name in the tree-view, the query’s logic will automatically run and the result data presented in the list to the right hand side of the tree-view.