Creating input parameters and variables

Input parameters are used for formulas and can have any value a reporting user might enter. In SQL, it is passed using a placeholder. Variables are used for filtering and always applied to an attribute/s.

The following are the steps to create input parameters and variables:

1. Create an analytical view using the CUSTOMER and SALES tables.

   

2. Our analytical view should look like this:

   

3. The cardinality, output columns, and measures should match as follows:

   

4. Go to the Semantic node and click on the + notation.

   

5. Provide the details and mark the attribute on which you want to create the variable.

   

6. Then save and activate the analytical view.

7. We can do the data preview. When you click on Data Preview, a popup appears as shown in the following screenshot:

   

8. We must click on From (and choose a value ) and To (again, choose a value).

9. Click on OK and again on OK. Then, click on the Raw Data tab.

10. You can see the data for the values of the variables that you choose from.

As a self assignment...