| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Aliases"
(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...") |
|||
| Line 7: | Line 7: | ||
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. | 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.) | (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.) | ||
| + | |||
| + | Aliases apply to an individual connection in the workbook. If you need to see the alias in one part of the report, and the original caption in another then you can create two connections to the same cube. Linking these parts together can be done by driving them from a range using the member's unique name. | ||
Revision as of 13:54, 6 August 2014
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.)
Aliases apply to an individual connection in the workbook. If you need to see the alias in one part of the report, and the original caption in another then you can create two connections to the same cube. Linking these parts together can be done by driving them from a range using the member's unique name.
