29 – Merged Dimensions

A powerful feature of Web Intelligence is to be able to combine multiple data sources and synchronise the data together using the concept of Merged Dimensions (for Excel users this is similar to using VLOOKUP but WebI is simpler to use and more powerful). In this...

28 – Multiple Queries

A document can contain multiple queries (also known as Data Providers). You can define multiple data providers when you create a new document or add more data providers to an existing document. You can then present the information from all of the data providers in a...

25 – Combined Queries

Combined Queries are multiple queries on the same universe but return a single data set, i.e. multiple queries are defined and run but only one set of values is returned. We learn how to create and use queries based on Set Analysis (Union, Intersect and Minus). 25 -...

24 – Sub-Queries

Sub-Queries are another method of restricting data, but they use the results of one query to restrict a second query. Web Intelligence generates SQL that is processed by the database in two steps: Run the sub-query and return a set of results Use the results of the...

23 – Query Contexts

Contexts are used by Web Intelligence to create meaningful SQL statements to ensure integrity of the data is not violated (e.g. avoid incorrect row based multiplications). Broadly speaking, Query Contexts enable universe designers to specify paths that logically...

22 – Query Filters

Focused queries can be created by using Query Conditions and Filters to limit the data returned by the database so the data provider does not contain unnecessary information. Reports should only contain the relevant data to help the user to make informed decisions...

21 – Conditional Formatting

This session demonstrates how rules can be created and used to format displayed values (i.e. highlight results that fail or meet specific values). When you apply a Formatting Rule to a column, row or cell on a report, Web Intelligence evaluates the Formatting Rule and...