Designer

Designer is a modeling application for OLAP databases. It is also used to load data into an OLAP databases. In some scenarios, other tools used.

Designer stores its content in a relational database.

When Designer is used for data loads, the load process is a significant performance factor. During the load process, the data is extracted from a source system, transformed as needed, and loaded into the OLAP database.

The duration of the load process depends on many variables such as the amount of data. The load times can last from several minutes to many hours.

Designer is downloaded and installed from EPM Administration.