BIQ's totals roll up from transactions, but a raw transaction view is only one click away.

BIQ uses your Excel models as a reporting template. Simply tell the system where to place specific blocks of data, and it will create a copy of your model with those blocks inserted. It can also "book" down another dimension, in this example the Time dimension, to create tabbed worksheets for specified time periods.

Research and analysis is often impossible due to multiple and disparate systems. BIQ comes equipped with transforming tools to standardize this process, as well as mapping utilities to create, strengthen and further resolve relationships.

A unique feature of BIQ is that the dataset structure can be modified in real time, with simple point-and-click operations. For example, here are the steps needed to group sub-projects into a master project classification.

1. Open the Dimension Editor and choose the dimension to edit:

2. Add a new element - "Pierce" - and drag the desired children onto
the new element.