OLAPPropertyGroup

Description:

This function returns the name of the n^th property group for this dimension in the specified database.

The OLAPPropertyGroup function is designed specifically to allow you to view the name for the property group / groups that are created within a specified dimension within a specified database. This function returns the property group name that is specified by the PowerOLAP user within the Modeler when editing or creating a dimension.

The function has the following syntax:

Syntax: OLAPPropertyGroup (database, dimension, n)

Explained below are the 3 parameters that have to be provided when building this function.

• Database : Enter the name of the database which has the dimension and property group that you want to access / enter the cell reference which has the name of this Database.
• Dimension : Enter the name of the dimension in the above mentioned database which has the Property Group whose name you want to access / enter the cell reference which has the name of such a dimension.
• N : Enter the index number for the property group in the above mentioned dimension of the specified database / enter the cell reference which has this index as a value.

Remarks

• If a connection is not established with a database the result will be a #value.
• The value for parameter "n" must be a positive real integer and should correspond to the value that the function has to return.
• There must be a Property group existing in the database mentioned in "Database" parameter above.
• All arguments are compulsory and neither argument is optional.

Example

This function may be easier to understand with an example.

• In order to build this function with more ease, open the specific database and bring a slice from that database into Excel. In this way you will have connected to PowerOLAP because you now have the OLAPOpen formula automatically on your sheet when you bring a slice of the cube into Excel.
• In Excel, use the menu: Insert -> Function and select PowerOLAP from the drop down list.
• Choose the OLAPPropertyGroup function from the list of functions provided and click "Ok".
• When building the formula enter the cell range for the database name, the dimension name and type in the index for the Property group.
• In the following example B1 is the cell that holds the database name, B3 is the cell that holds the dimension name, and the number 1 is the index of the Property group then name of which will be returned by the formula.

=OLAPPropertyGroup($B$1, $B$3, 1)

 

The above formula returns a value = " PropValue" which is the value for the Property Group at the index 1(n) in the database "Acuity" (B1) in the dimension "AP_Trans_Measures" (B3).