Numeric parameters

You can create numerical parameters that allow the user to affect calculated measures, sets and members dynamically:

To create a numeric parameter, right-click anywhere in the parameter list. A pop-up menu appears allowing you to add a parameter:

By clicking on the “New Parameter …” menu item a wizard to create a numeric parameter appears:

In form that opened you should fill in the following fields:

• Name – fill in the name of the parameter;
• Format – choose the parameter format: numeric or percentage;
• Decimal Places – select the number of decimal places;
• Default Value – specify the default setting;
• Allowable Values –select all values or the value of the selected range with the ability to specify the step

• Description – You can briefly describe the essence of the parameter, if it is necessary.

This parameter can be used in calculated measures, members and sets:

Let us look at the following example. For instance, we need to analyze how the margin for the “Bikes” subcategory changes provided that the prime cost of goods increases by 10%.

In order to do this, create a parameter “Product Cost”:

After that, we need to create a measure for “Plan Gross Profit”, which will calculate predictable margins using parameter “Product Cost”:

Now let us create a report with the “Bikes`” subcategories on rows:

In columns it is December 2017:

Now let us add three measures to our row: “Sales Amount”, “Gross Profit”, “Plan Gross Profit”. As a result, you will get the following report with parameter “Product Cost”:

Let us increase “Product Cost” by 10%:

In this case the sales of Touring Bikes subcategory will go down.