You can use either the Hidden parameter or the Show parameter to hide extended dimensions so they do not show on the dimension menu in data workbench.
When you enter the appropriate setting for either parameter, the dimension name is not listed in the menu in data workbench, but it is still in the profile and available to be used. Any data workbench user can temporarily unhide hidden dimensions by setting the Unhide All parameter in the Insight.cfg file to true.
For more information about the Unhide All parameter, see the appendix on data workbench configuration parameters in the Data Workbench User Guide.
The following sections describe how to use the Hidden and Show parameters to hide extended dimensions.
The Hidden parameter is an optional parameter that you can use when defining extended dimensions in Transformation Dataset Configuration files.
Open Transformation Dataset Configuration files in which the extended dimension that you want to hide is defined. See Editing Existing Dataset Include Files.
Locate the Hidden parameter for the desired dimension in the configuration window and type true.
Save the file locally, then save it to the appropriate profile on the server. See Editing Existing Dataset Include Files.
The dataset retransforms, after which the extended dimension does not appear on the dimension menu in data workbench. For more information about the Hidden parameter, see Extended Dimensions.
If you change the Hidden parameter’s setting, you must retransform the dataset for the change to take effect.
The Show parameter is not one of the parameters available for defining extended dimensions in Transformation Dataset Configuration files. Instead, the parameter is defined in the .dim files for any derived dimensions that you create. Therefore, to use the Show parameter to hide an extended dimension, you first must create a derived dimension that is based on the extended dimension as described in the following procedure:
Use a text editor such as Notepad to create an empty file called <dimension name>.dim The file name should match the name of the dimension that you want to hide. For example, to hide the Next Page dimension, you would create a Next Page.dim file.
Add the following text to the file:
Save the file to the profile’s Dimensions directory. You can save the file to a subdirectory if desired.
When you use the Show parameter to hide an extended dimension, you do not have to retransform your dataset to make the change take effect. You can choose to hide or show the dimension in your local version of the profile (that is, you can save the .dim file to your User folder), or you can save the .dim file to the server for use by other users of the profile.
You also can use the Show parameter to hide metrics and filters. For information, see the Configuring Interface and Analysis Features chapter in the Data Workbench User Guide.