Show TOC

SetContextOptionsForSeveralDimensionsLocate this document in the navigation structure

This API enables you to change the following context options for several dimensions: lock a dimension, hide a dimension in the EPM Context bar.
Parameter Description
File as Object
  • Name of the Microsoft Excel workbook to which you want to apply the lock or hide
  • or name of the Microsoft Excel worksheet to which you want to apply the lock or hide
  • or name of the Microsoft Powerpoint presentation
Mandatory
connectionString As String

Connection. Mandatory.

For details about the syntax you must use, see ConnectionString Parameter - Syntax.

DimensionMember1... to 29 Mandatory

Dimension you want to lock and the member that you want to set for the locked dimension.

dimension=member, where you specify the unique name for the dimension and for the member

hideDimension1... to 29 Enter TRUE to hide the specified dimension in the EPM Context bar ; enter FALSE to display the dimension in the EPM Context bar.