Show TOC

Restrictions on Specific Features Locate this document in the navigation structure

When the Do not Load Members at Connection option is selected for a data source, the following features are not supported or are restricted:
  • Books. If a book template has not been generated with the EPM plug-in 10.0, the book templates are not supported. For more information about books, see Book Publication.
  • If the provider used for the connection does not support custom members, it does not support blank members either.
  • The Freeze Data Refresh option is available but not applied. See Freeze Data Refresh.
  • The Display Warning when Process Takes Time option is available but not applied. See User Options.
  • The user options Keep Rows and Columns of Unrecognized Members and Warn if Rows and Columns of Unrecognized Members will be Kept are available but not applied.
  • Sorting, Filtering and Ranking tabs of the Report Editor:
    • In the Sorting, Filtering and Ranking tabs of the Report Editor, the Show Only Members Displayed in the Report option does not exist.
    • In the Sorting tab: the Sort Inside Level option is not available.
    • In the Filtering tab: the Filter on all Columns/Rows option is not available; the is/is not null drop-down menu is not available; the Retain Members button is not available.
    • In the Ranking tab: the First Column and Last Column options are not available.

    For more information on data sorting, filtering and ranking, see Data Sorting, Ranking and Filtering.

  • Excluding members:
    • When excluding members, you cannot have the same combination of members twice in an axis.
    • When there are at least three dimensions in an axis, you can either exclude one member or the whole combination of members.

    For more information about excluding members, see Excluding Members.

  • Do not use the following EPM functions as they are not supported when connected to a large volume data source: EPMMemberProperty, EPMDimensionPropertyValues, EPMRetrieveData, EPMSelectMember, EPMMemberOffset, EPMMemberDesc, EPMScaleData, EPMSaveData, EPMSaveComment, EPMCommentPartialContext, EPMCommentFullContext, EPMWorkStatus, EPMBook and EPMExecuteAPI (when you reference members). For more information about functions, see EPM Functions.
    Note However, when using a large-volume BAPI provider BW NW connection, you can use the functions EPMMemberProperty and EPMMemberOffset, provided that, when creating the connection, you have selected hierarchies for which members and properties are loaded at connection time.
  • You can use the following two functions only if you specify the member ID in the member parameter: EPMAxisOverride, EPMDimensionsOverride.
    Tip To find out the member ID, display the member in a report and select the member. In the formula bar, the ID is displayed right after =EPMOlapMemberO("
  • You should not manually modify the following formulas:
    • =EPMOlapMemberO(
    • =EPMOlapMember(
    • =EPMOlapMultiMemberO(
    • =EPMOlapMultiMember(
  • In the Member Selector:
    • the Member Property and Dimension Property relationships do not exist.
    • the number of children for a node is displayed, not the number of ascendants.
    • other restrictions exist, depending on the data source.

    For more information, see Member Entry Using the Member Selector (on Large Volume Data Sources and Specific Connections).

  • Using the Member Recognition feature, when entering a member name along with a prefix (such as ID=member), you must enter the complete member name, not just a part of it. For more information, see Member Entry Directly in a Sheet.