Udostępnij za pośrednictwem

Calculation Tools (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)

  • Artykuł

Use the Calculation Tools pane on the KPIs tab in Cube Designer to explore metadata, functions, and templates available for use in Key Performance Indicators (KPIs).

[!UWAGA]

This pane is displayed only in form view.

Options

  • Metadata
    Displays the metadata for the selected cube.

    Drag a selected element to the KPI Form Editor pane to include the Multidimensional Expressions (MDX) syntax for that element at the selected location in the pane.

  • Functions
    Displays the functions available for expressions and conditions.

    Drag a selected element to the KPI Form Editor pane to include the MDX syntax for that element at the selected location in the pane.

    [!UWAGA]

    In project mode, the Calculation Tools dialog box reads information for this option from an XML file named MDXFunctions.xml, included with SQL Server Data Tools (SSDT). In online mode, information for this option is retrieved from the MDSCHEMA_FUNCTIONS schema rowset for the instance.

  • Templates
    Displays the predefined templates available for KPIs.

    Drag a selected element to the KPI Form Editor pane to include the MDX syntax for that element at the selected location in the pane.

Context Menu

The following options are available in the context menu displayed by right-clicking an element in the Calculation Tools pane:

  • Copy
    Select to copy the selected element in Metadata or Functions to the Clipboard.

    [!UWAGA]

    This option is not displayed if Templates is selected.

    [!UWAGA]

    This option is disabled if the selected member cannot be copied, such as the Sets folder of a dimension displayed in Metadata or the function group folder for a function displayed in Functions.

  • Filter Members
    Select to display the Filter Members dialog box and filter members displayed for the selected element in Metadata. For more information about the Filter Members dialog box, see Filter Members Dialog Box (Analysis Services - Multidimensional Data).

    [!UWAGA]

    This option is displayed only if Metadata is selected.

    [!UWAGA]

    This option is enabled only if a level for an attribute is selected in Metadata.

  • Add Template
    Select to add a new calculated member, named set, or script command based on the selected template to the cube script and display the KPI Form Editor in form view.

    [!UWAGA]

    This option is displayed only if Metadata is selected.

Zobacz także

Odwołanie

Cube Designer (Analysis Services - Multidimensional Data)

KPIs (Cube Designer) (Analysis Services - Multidimensional Data)

Toolbar (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)

Calculation Tools (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)

KPI Organizer (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)

KPI Form Editor (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)

KPI Browser (KPIs Tab, Cube Designer) (Analysis Services - Multidimensional Data)