In this recipe, we will use the
Essbase Properties dialog to set up the default Alias table, set the dense and sparse setting for our dimensions, select all external source properties for the
MEASURES dimension, and specify the attribute types for the
PRODUCT dimensions. We will also use the
Transformation tab to add a suffix to the
STATE metadata member in the
SUPPLIER, so that it does not overlap with the
STATE metadata member.
To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio and log in to Essbase Studio using your server, username, and password.