PROPERTY (dim, memb, group)

Description:

This function returns the name of the corresponding property defined for a member of a specified dimension from a specified property group. This function is designed specifically to allow you to view the property associated with a member, defined under a specified Property Group. The function displays the name of property corresponding with the member from the specified dimension that has the specified property group. The function takes as a parameter the name of the dimension, the name of the member and the name of the property group, all of which help the function to determine the property for a specific member.

Syntax: PROPERTY (Dimension, Member, Property-Group)

• Dimension : Enter the name of the dimension which exists in this database mentioned above and is the dimension whose members you wish to access.
• Member : Enter the name of the member which belongs to the dimension specified above and whose property the function has to access.
• Property-Group : Enter the name of the property group that has the properties for the member specified above, and these are the properties that will be accessed by the function to return the result.

Remarks

• The name of the dimension and the name of the member must be a valid name and should exist in the database.
• The name of the property group must be a valid name, residing within the specified dimension and containing property values for the member that is also referenced as a parameter in the function.
• All the arguments are compulsory.

Example

=PROPERTY ("Region", "California", "R-Props")	-returns the property of the member "California" from the dimension Region, from the group "R-Props" (Property: "WestCoast")
=PROPERTY ("Time", "Period_05", "Time-Pr")	-returns the property of the member "Period_05" that's from the dimension "Time" from the group "Time-Pr" (Property: "FirstHalf")

 

Let us take the example of a cube in PowerOLAP which requires data that is the value for the name of a property that is accessed through its property-group and also the dimension and the member name, all of which are to be given as parameters to the function. If in the same dimension in another member or in another dimension in another cube, you want to display this accessed PROPERTY value for the parameters supplied to the function then it is appropriate to use the PROPERTY function to access the property value from a given group. In this case write a formula in the cube in PowerOLAP to access this value for the given parameters with the help of this function and write this value to another member supposed to hold this value as fact data or you can also write this value to a different member of a different dimension in a different cube.



The screen above shows a formula for the PROPERTY function.

The formula writes a value into the "MetaDataValues" dimension, into the "Property" member.

In the formula, the PROPERTY function takes three parameters, which are, the name of the dimension whose members are accessed, the name of the member from within the dimension specified, and the name of the property group from wherein the property value has to be returned as the result of the function. This formula accesses the property for the member based upon the three parameters that are given and then depending upon the value that corresponds to the member specified, the resultant value is returned by the function. The function above accesses the members from the "Version" dimension, and then accesses the member "Forecast" and then for this member it accesses the corresponding property from the property group "VersionProperties". "CurrentForecastFigures" is the property here for "Forecast" and this is the value returned by the function.