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.
We need to add some measures to the Pricing cube measures dimension. So from our Dimension page, double click on Pricing Measures.
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.
js
Retail Price
Cost Price