Assign a Parameter

After defining a parameter, assign it to the object where it should be used to filter runtime data or apply a stored value.

  1. Click Application and then the appropriate object.

  2. Edit the object to assign the parameter. Click Object Lookup to find the parameter, and enclose the parameter name in pipes and exclamation points. For example, |!ParamDate!|. See Syntax.

  3. Click Save.

See these sample use cases:

Assign to a Report Subheader

Perform these task to assign an Input Value parameter to prompt users to enter their name in a report header:

  1. Click Application > Presentation > Cube Views.

  2. Click Cube View Group, the appropriate cube view, Designer, and then Report Header.

  3. In Subtitle enter Report run by:.

  4. Click Object Lookup, and then Parameters (with pipes).

  5. Select the parameter to assign, and then click Copy to Clipboard.
    ""

  6. Paste the parameter after Report run by:, as shown:
    ""

  7. Click Save and then Open Data Explorer to run the cube view.

  8. Enter your name and click Show Report. The report generates, displaying your name as shown:
    ""

Assign to a Cube View Column Header

In this example, a Delimited List parameter is assigned to a sample GolfStream cube view so users can indicate if reports are not started, under review, or completed for each entity.

  1. Click Application > Presentation > Cube Views.

  2. Click the appropriate cube view.

  3. Click Rows and Columns to see that column members display time based on workflow and a non-financial account called Report Status. The row members identify all base entities for Clubs.
    ""

  4. Click a row header, and then Data.

  5. In Cell Type, select Combo Box.

  6. In List Parameter, enter ParamReportStatus and save the cube view.

    When users run the cube view, they can specify a report status for each entity, as shown:
    ""