Understanding Essbase Model properties for the ASO cube
In this recipe, we will set up the Essbase properties for the ASOsamp Essbase Model. In the Building a Measures dimension from the fact table recipe in this chapter, we saw that Measure dimensions had several properties that we needed to set as this hierarchy was created using the fact table in Essbase Studio. In addition, we need to set dimensions properties for each hierarchy using properties that are exclusive to the ASO model.
Getting ready
To get started with Essbase Studio, click on the Start menu and Programs | Oracle EPM System | Essbase | Essbase Studio | Essbase Studio Console. Use the login menu to enter your server, username, and password, and click on the Log In button.
How to do it...
Right-click on the ASOsamp folder in your Metadata Navigator. Drill down on the CUBE_SCHEMA folder, right-click on ASOsampModel Essbase Model, and select Essbase Properties.
Click on the ASOsampModel root in the General tab and select the ASO...
