Designer
Designer manages the structure of an
OLAP database by storing and manipulating a set of
relational tables stored in a SQL Server database.
Once the database structure is established within Designer, the OLAP dimensions and cubes can be generated from Integration and Designer databases. You can make changes to the structure in Designer without affecting the OLAP database until those changes are committed to OLAP. You can recreate the entire OLAP database or only a subset of its dimensions. Designer can also place data values into the OLAP database.