Modify an Essbase Outline

In Analyze an Application in Smart View, you analyzed an application in Smart View.

Now you’ll modify a cube outline in the web interface.

Create a New Member

You start by creating a new member.

1. In the web interface, on the Applications page, select the Basic cube in the Sample_Dynamic application.

2. Click the Actions menu, and select Outline.

3. Click Edit.

4. Expand the Scenario dimension by clicking the arrow next to Scenario.

5. Insert a member:

   1. Click Edit to put the outline in edit mode.

   2. Expand the Scenario dimension.

   3. Select the Budget member.

   4. On the outline toolbar, under Actions, select Add a sibling below the selected member.

6. Enter the member name, Forecast, and press Tab.

7. Select the tilde (~) consolidation operator from the list.

   The Forecast member does not aggregate with the other members in its dimension.

8. Leave the data storage type as Store Data because we want users to be able to input forecast data.

9. Click Save.

Seed the Forecast Member with Data

To seed the Forecast member with data, we'll create a calculation script and calculate forecast data.

1. In the web interface, on the Applications page, select Basic cube in the Sample_Dynamic application, click the Actions menu, and select Inspect.

2. In the Basic dialog box, select the Scripts tab, with Calculation Scripts selected, click to add a calculation script.

3. In the Script Name field, enter salesfcst.

4. In the Script Content box, enter a simple formula:

   Forecast(Sales=Sales->Actual*1.03;)

   Forecast for sales is equal to actual sales multiplied by 1.03, which seeds the Forecast member for Sales with a value 3% higher than the actual sales.

5. Click Save and Close.

6. Close the database inspector by clicking Close until all tabs are closed.

Execute the Script

Calculation scripts are executed as jobs.

1. In the Web interface, select the Jobs page.

2. Click New Job, and select Run Calculation.

3. On the Run Calculation dialog box, in the Application field, select Sample_Dynamic application.

   Notice that the Database field automatically populates the Basic cube.

4. On the Scripts menu, select the salesfcst calculation script that you created.

5. Click OK.

6. Click Refresh to see that the job completes.

In Analyze Forecast Data in Smart View, you'll analyze this new forecast data in Excel. But first, let’s take a closer look at managing jobs.