XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Aliases
Revision as of 16:32, 5 August 2014 by Colin Overton (talk) (Created page with "As of Version 8 of XLCubed you can create aliases for members. These will override the caption of a member for a connection whenever it is returned. Member aliases can be...")
As of Version 8 of XLCubed you can create aliases for members. These will override the caption of a member for a connection whenever it is returned.
Member aliases can be set up per member or based on a member property.
The easiest way to create a specific alias is to open the XLCubed -> Options -> Workbook Options screen and turn on "Overtyping a Grid creates an Alias". Now you can simply type on a grid to create the aliases you want.
To create a member property alias, go to XLCubed -> Mange...More -> Manage Aliases. From here you can pick a hierarchy level and the property to use as the caption. (N.B. As these properties must now be returned from the cube you may need to turn off member properties in the Grid properties screen.)