Designer
     Designer manages the structure of an
        OLAP database by storing and manipulating a set of
      relational tables stored in a SQL Server database. 
  
    After the database structure has been imported to the Integration database, Designer can generate the OLAP dimensions and cubes.