Database design functions summary

 

Entities

Create, rename and remove Entities.

Add, edit or remove entity members.

View entity’s saturation and size of sparse structures.

 

Relationships

Create and manage hierarchies.

Assign relationships, scan relationships, find and fix orphans.

 

Cubes

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.

 

Rules

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.

 

Security

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.

 

B.E.A.M.

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)

 

Log

Displays the database log file.

 

New DB

Creates a new Board database.

 

Utilities

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