Show TOC

 Managing Variants Locate this document in the navigation structure

 

A variant is a set of filters and input parameters that you define to view specific subsets of data from the KPI or the report. You define the filters by selecting dimension and value pairs.

For example, you have defined a KPI to monitor car sales. You can create a variant that restricts the results to a certain area in Germany that one sales representative is responsible for. The variant can then be reused for KPIs that use the same parameters.

Create a Variant

On the home screen, choose Manage Variants from the action menu at the bottom left corner. Click Add Variant to create a variant from scratch. Fill-out the following fields on the Add Variant screen.

  • Variant ID:

    Enter the full path to where the variant is stored. You must enter the variant ID in English.

  • Variant Title:

    Enter a meaningful title for the variant that helps you identify the purpose of the variant outside the context of the KPI or the report.

  • Description:

    Describe the purpose of the variant and include any other relevant information.

  • OData Path:

    Enter the path and name for the OData service to the SAP HANA calculation view or the BI query that is the base for your KPI or report.

  • Entity Set:

    Enter the corresponding entity set in the calculation view in SAP HANA. The entity set provides the input parameters for the SAP HANA calculation view. The entity set must match the entity set of the KPI or the report to which you are applying the variant.

  • Tags:

    Enter relevant tags to make it easier to search for the variant.

  • Filter Settings

    Enter the filter pairs that are relevant for the business requirement. Click Add Filters to add additional filter pairs.

    You must include the SAP client as a filter criterion even if the client is not a parameter but an attribute of the SAP HANA calculation view. However, this does not replace the proper authorization setup.

  • Input Parameters:

    Enter values for each of the input parameters expected by the SAP HANA calculation view. Click Add Input Parameters to add additional input parameter pairs.

Duplicate a Variant

  1. On the home screen, choose Manage Variants from the action menu at the bottom left corner to open the Variant Details screen.

  2. Search for an existing variant and select it.

  3. Click Duplicate to open the Duplicated Existing Variant screen.

  4. If required, you can edit any of the following fields:

    • Variant ID

    • Variant Title

    • Description

    • OData Path

    • Entity Set

    • Tags

    • Filter Settings

    • Input Parameters

  5. Click Save and Close to create the duplicate variant.

Edit an Existing Variant

You can edit an existing variant to make it applicable to changing business needs.

  1. On the home screen, choose Manage Variants from the action menu at the bottom left corner to open the Variant Details screen.

  2. Search for an existing variant and select it.

  3. Click Edit to open the Edit Existing Variant screen.

  4. You can edit any of the following fields:

    • Variant ID

    • Variant Title

    • Description

    • OData Path

    • Entity Set

      Caution Caution

      You must ensure that the OData path and entity set for the variant are the same as the OData path and entity set of the KPI or the report to which it is applied.

      End of the caution.

    • Tags

    • Filter Settings

    • Input Parameters

  5. Click Save and Close to apply your changes.

Delete a Variant

You can delete variants as required.

Caution Caution

Before deleting a variant, delete all evaluations to which the variant is associated.

End of the caution.

  1. On the home screen, choose Manage Variants from the action menu at the bottom left corner to open the Variant Details screen.

  2. Search for an existing variant and select it.

  3. Click Delete and confirm your decision.