Using dimension build rules to add the parent-child dimension
In this recipe, we will set up a dimension build rule to modify the outline of the Sample Basic database. This recipe will be using the parent-child reference to build our Measures dimension.
Getting ready
To get started, click on your Start menu and navigate to Programs | 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...
Open a new Excel workbook.
Enter the values as shown in the following table, and save them as tab delimited on your
SampleBasicdatabase directory for ease of use with the nameMeasures.txt. The URL for theSampleBasicdatabase is as follows for version 11.1.2.x:..\ Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\app\Sample\Basic.
This table has all the members and properties you need for the
Measuresdimension in a...
