Building a Measures dimension from the fact table
In this recipe, we will build a Measures dimension from a column in the ASOsamp fact table. The ASOsamp fact table has measures as columns instead of rows. For this reason, the Measures dimension in the ASOsamp star schema is not in its own table, and we have to build its structure in Essbase Studio. We will have to define formulas and other Essbase Properties, but this is done after we build the Cube Schema and Essbase Model.
Getting ready
To get started with Essbase Studio, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio, then click on Start Server to make sure your Essbase Studio Server is running. When the Start Server command prompt gives you the console command, log in to Essbase Studio using your server, username, and password.
How to do it...
Right-click on the ASOsamp folder in your Metadata Navigator. Select New and then Folder, and type in
HIERARCHIESin the properties menu.Right-click...
