Data Explorer · ActiveUI

The Data Explorer widget displays the list of ActivePivot cubes connected to your ActiveUI application.

Data Explorer

You can drag fields from Data Explorer directly into the Wizard:

Drag and drop data

When multiple cubes are connected to ActiveUI, you will be asked to select a cube when you create a widget. You can query only one cube per widget. The other cubes are then displayed as inactive.

It is possible to enable "distributed cube" in ActivePivot to allow measures from two or more cubes to act as a single cube. This can be useful for performance reasons, in order to perform calculations across multiple cubes or in order to display data from different cube in the same pivot table.

Search elements

The data explorer supports three types of search (all case insensitive), that will resolve in that specific order:

Regular Expression search: when starting with a /, the remaining part will be considered a JS Regular Expression. Example: /^l[a-z]+de$ would match any elements whose caption starts with an l, ends with de and contains alphabetical characters in between.
Glob pattern search: when containing a * or a ?, the search will be considered a glob pattern. Example: a*z would match any elements whose caption contains an a, a z and any characters in between.
Regular search: otherwise, the search will be considered as a chunk of text to match against. Example: abc would match any elements whose caption contains abc.

Add cube server

It is possible to connect multiple ActivePivot servers to ActiveUI. The Data Explorer offers a way to connect additional ActivePivot servers, as explained below:

If you know the URL of an ActivePivot server to be added, click the more icon, ..., in the top right corner of the Data Explorer and select "Add server".

Manually added servers apply to current user only. If you wish to change the global setting and have the new cube available for everyone, talk to your development team.

Data Explorer Adding Server