Show TOC

EPMReportOptionsLocate this document in the navigation structure

This function overrides the options for one or more reports. The override applies to a report only if the Inherit Sheet Options option is not selected in the Options tab of the Report Editor.

Parameter Description
reportID ID of one or several reports. Mandatory.
options Specify the options that will override the existing ones. Mandatory.

In the options parameter, you can specify one or more options. Use the ; character to separate the options.

Note All the report options are not described in this section. Follow the links for descriptions of the options.
Following is the list of values correponding to the report options:
  • CalculateParentsInHierarchies. To activate this option, enter: " CalculateParentsInHierarchies=true". To deactivate it, enter: " CalculateParentsInHierarchies=false"

    For more information, see Calculate Parents in Hierarchies.

  • KeepFormulaOnData. To activate this option, enter: "KeepFormulaOnData=true". To deactivate it, enter: "KeepFormulaOnData=false".

    For more information, see Keep Formula on Data and Show Source Data in Comments.

  • ShowSourceDataInComments. To activate this option, enter: "ShowSourceDataInComments=true". To deactivate it, enter: "ShowSourceDataInComments=false"

    For more information, see Keep Formula on Data and Show Source Data in Comments.

  • KeepEmptyRows. To activate this option, enter: "KeepEmptyRows=true ". To deactivate it, enter: "KeepEmptyRows=false". To automatically remove any row in the report that has no data or that contains zero values after every operation that refreshes the cube or model, enter: "KeepEmptyRows =RemoveEmptyandZero"

    For more information, see No Data and Zero Values.

  • KeepEmptyColumns. To activate this option, enter: "KeepEmptyColumns=true". To deactivate it, enter: "KeepEmptyColumns=false". To automatically remove any column in the report that has no data or that contains zero values after every operation that refreshes the cube or model, enter: "KeepEmptyColumns =RemoveEmptyandZero"

    For more information, see No Data and Zero Values.

  • RepeatRowHeaders. To activate this option, enter: "RepeatRowHeaders=true". To deactivate it, enter: "RepeatRowHeaders=false"

    For more information, see Repeat Row Headers and Repeat Column Headers.

  • RepeatColumnHeaders. To activate this option, enter: "RepeatColumnHeaders=true". To deactivate it, enter: "RepeatColumnHeaders=false"
    For more information, see Repeat Row Headers and Repeat Column Headers.
  • FreezeDataRefresh. To activate this option, enter: "FreezeDataRefresh=true". To deactivate it, enter: "FreezeDataRefresh=false"

    For more information, see Freeze Data Refresh.

  • SetDefaultValueInEmptyCell and EmptyCellDefaultValue. To activate the option, enter: "SetDefaultValueInEmptyCell=true". To deactivate it, enter: "SetDefaultValueInEmptyCell=false"

    Then, to define a default value, enter: "EmptyCellDefaultValue=[string]"

    For example, you want that "no data" appears in any cell that contains no value. Enter what follows in the options parameter: "SetDefaultValueInEmptyCell=true";"EmptyCellDefaultValue=no data"

    For more information, see Empty Cell Default Value.

  • RowHeaderIndentation. Three values are possible.
    • No indentation. Enter: "RowHeaderIndentation=0"
    • Indent the children. Enter: "RowHeaderIndentation=1"
    • Indent the parents. Enter: "RowHeaderIndentation=2"

    For more information, see Row Header Indentation.

  • TotalAtLeft. To activate this option, enter: "TotalAtLeft=true". To deactivate it, enter: "TotalAtLeft=false"

    For more information, see Totals Placement.

  • TotalAtTop. To activate this option, enter: "TotalAtTop=true". To deactivate it, enter: "TotalAtTop=false"

    For more information, see Totals Placement.

  • ApplyDynamicFormatting and FormattingSheet. To activate the option, enter: " ApplyDynamicFormatting=true".

    Then, to specify the sheet to apply, enter: "FormattingSheet=[name of the sheet]"

    For example, enter what follows in the options parameter: " ApplyDynamicFormatting=true";"FormattingSheet=templateCompany"

    For more information, see Apply Dynamic Formatting.

Example

Example with several options

To indent the child members in the row axis and to apply the dynamic formatting sheet called "global" to the default report, enter the following:

EPMReportOptions=("000","RowHeaderIndentation=1";" ApplyDynamicFormatting=true";"FormattingSheet=global")