Database design functions summary



Create, rename and remove Entities.

Add, edit or remove entity members.

View entity’s saturation and size of sparse structures.



Create and manage hierarchies.

Assign relationships, scan relationships, find and fix orphans.



Create, rename and remove InfoCubes and InfoCube versions.

Verify versions alignment and run the versions alignment procedure.


Data Reader

Create data reading protocols to load data from external systems such as transactional system, ERP, CRM or other, into the Board database entities, hierarchies and InfoCubes.



Define calculation rules on entity members, usually for profit and loss or balance sheet entities where an entity member is calculated applying a formula that refers to other members of the same entity.


Time Range

Define and manage time range and time entities.

Define and manage the custom time entities.



Create security profiles that define access privileges (read-only or read/write) and access scope (grant access to an InfoCube or to a subset of the InfoCube).


Process Modelling

Create or edit Database procedures.


SQL Fast Track

It creates a Data Load schema to automatically create entities, relationships and info-cubes and feed them from an existing RDBMS using SQL script.



It opens the Board Predictive Analytics Engine


Search Engine

It launches the Board Crawler to tag Items and Metadata for the Search Tool (Sliding Panel)



Displays the database log file.


New DB

Creates a new Board database.



Access the database utilities area, where you can unload one (or all) database from the RAM and manage the backups.