Element Details: XOLAP+Member+Property

Available in: Logi Info Source code name: XolapMemberPropertyIntroduced in: v10.0.117

A member property is an additional data field that can appear alongside a dimension level for dimensions on the left axis. It does not have to be related to the dimension of the level to which it belongs. For example, a member property for City Population could be defined on the City level of the Customers dimension, between levels for State and Address.

The City Population will then be available for display whenever the City level of the Customers dimension is visible on the left axis.

Set the "Pick Member Properties" attribute of an OlapGrid to true to enable the user to show and hide member properties, or add a XolapQueryMemberProperty element to a XolapQueryAxisDimension element of an OlapGrid or OlapTable.


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
The name of a data field/column returned from the DataLayer.
Allows a string to be formatted in various ways, especially for numeric and date values. Specifies formatting characteristics for the data. This attribute has been borrowed from the Microsoft Visual Basic Format function. For more information: http://msdn.microsoft.com/en-us/library/59bz1f0h(VS.71).aspx For dates, the non-specific formats, such as "General Date", "Short Time", etc., are converted according to the browser's international setttings. Also, for very large reports, the non-specific formats perform better. There are also some special formats. "<" and ">" change strings to lower and upper case. "Expanded Spaces" preserves space characters that would otherwise be collapsed by the web browser. "HTML" preserves HTML tags so that they are not encoded - they are embedded rather than shown. "Preserve Line Feeds" preserves line feed and cariage return characters so that the following characters appear on a new line. "mp" formats numbers with the "metric prefix". To format 1,234,567 as "$1.23M", use Format "$#.00mp". Supported metric prefixes are from 1000^6 to 1000^-6 For more information: http://en.wikipedia.org/wiki/Metric_prefix "mpsx" formats the value with x number of significant figures in addition to the metric prefix. So a value of 123456, with format set to mps3 will return 123k. "qq" returns the number of the quarter when the value being formatted represents a date. To return the year and quarter together like "2010 Q1", set the format to "yyyy Qqq". "fyy" and "fyyyy" return the fiscal year. "fqq" returns the fiscal quarter. The fiscal year start date may be configured in the settings' Globalization element. "ww" returns the number of the week. The first day of the week may be configured in the settings' Globalization element.
The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
Sets the caption or title for the member property that will be displayed. The default is the last part of the MemberPropertyName.
The MemberPropertyName must be a member property of the of the parent element's dimension. Begin the value with the dimension name followed by the property name. For example: [Product].[List Price]


Click element to drill down for more information.



Click element to drill down for more information.

 Back to top