| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Member Properties in Grids"
(Created page with 'Member properties (also known as attributes) are available in the Hierarchy Editor for the hierarchy that contains the properties, on the '''Display''' tab. Both user-define…') |
(update tab caption) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Member properties (also known as attributes) are available in the [[Hierarchy Editor]] for the hierarchy that contains the properties, on the ''' | + | Member properties (also known as attributes) are available in the [[Hierarchy Editor]] for the hierarchy that contains the properties, on the '''Member Properties''' tab. |
Both user-defined and system member properties are available, although system member properties can be hidden if desired. | Both user-defined and system member properties are available, although system member properties can be hidden if desired. | ||
| Line 7: | Line 7: | ||
''We want to see the Birth Date of the Customers visible in the Grid.'' | ''We want to see the Birth Date of the Customers visible in the Grid.'' | ||
| − | + | * Start by inserting a Grid on the Internet Sales Cube. For details see [[Report Designer]]. | |
| − | + | * Drag {{Code|Measures}} to columns, and {{Code|Customer}} to rows. | |
| − | + | * Click on the {{Code|Customer}} hierarchy to show its details in the bottom-right panel | |
| − | + | * Select the '''Display''' tab, and tick the {{Code|Birth Date}} member property: | |
| − | + | ||
| − | + | [[File:MemberPropertiesSelection.png|center|thumb|500px]] | |
| − | + | ||
| + | * Click '''OK''' to insert the Grid | ||
| + | * There are no member properties visible yet: because the member property only applies to members at the {{Code|Customer Key}} level, they will only be shown when we drill down, or if we select those members, so drill down until you can see the member properties | ||
| + | * We can change the display style in the [[Grid Properties#Formatting|Grid Properties]] dialog. | ||
| + | |||
| + | [[Category:Grid Reporting]] | ||
| + | [[Category:OLAP Operations]] | ||
Latest revision as of 08:11, 21 September 2022
Member properties (also known as attributes) are available in the Hierarchy Editor for the hierarchy that contains the properties, on the Member Properties tab.
Both user-defined and system member properties are available, although system member properties can be hidden if desired.
Examples (using the Internet Sales cube)
We want to see the Birth Date of the Customers visible in the Grid.
- Start by inserting a Grid on the Internet Sales Cube. For details see Report Designer.
- Drag Measures to columns, and Customer to rows.
- Click on the Customer hierarchy to show its details in the bottom-right panel
- Select the Display tab, and tick the Birth Date member property:
- Click OK to insert the Grid
- There are no member properties visible yet: because the member property only applies to members at the Customer Key level, they will only be shown when we drill down, or if we select those members, so drill down until you can see the member properties
- We can change the display style in the Grid Properties dialog.
