Skip to content

Creating Pricing Cube

Next we will create our Pricing cube. Since, in this tutorial, our prices do not vary by store, we will not need the department dimension.

Including the Scenario dimension allows us to run multiple scenarios of the plan which can simulate different pricing strategies.

Creating Pricing Cube Window

We need to add some measures to the Pricing cube measures dimension. So from our Dimension page, double click on Pricing Measures.

Pricing Measures Dimension

Since we would ideally like to only enter the prices once per product unless they change at some time during the planning period, we will make the prices carry forward from one month to the next. So let's add Retail Price and Cost Price.

Retail Price
Cost Price
Retail Price
Cost Price

Pricing Measures