Using Attributes in calculation scripts
In this recipe, we will use the @Attribute, @WithAttr, and @AttributeVal functions to limit the scope of our script and allow us to rank sales in the Sample.Basic database. We will use the @Rank function in our calculation to rank the sales of certain products for the New York market. This recipe only applies to the BSO model.
Getting ready
To get started, click on the Start menu and navigate to Program | Oracle EPM System | Essbase | Essbase Administration Services | Start Administration Services Console. In the Log in menu, enter your Administration Server, Username, Password, and click on the Log in button.
How to do it...
Drill down on the Essbase Server in EAS, expand the Applications node, drill down on the Sample application and Basic database, right-click on the Outline, and select Edit from the drop-down.
Drill down on the Measures dimension and the Ratios hierarchy. Right-click member Profit per Ounce, click on Add Sibling from the drop-down...
