Rename Rows and Columns

By default, a cube view has standard headers to represent rows and columns. All the header settings control the row and column headers presented when the cube view is run if the default is not used. See General Settings.

If the header name for a row or column must be different than the dimension name or description, use the rename function. The rename function is an expansion of the end of a member filter that enables you to enter what you want displayed. For example, A#CashBalance:Name(Cash Balance) will display Cash Balance as its header.

Another way to use the rename function is to include the XFMemberProperty, which returns member properties. For example:

A#6009.base:Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=AccountType))

1. Use the rename function to pull in the member property: Name(XFMemberProperty

2. Define the dimension type: (DimType=Account,

3. Determine what will be in the member filter: Member=|MFAccount|,

4. Pull in the property: Property=AccountType))