This function returns the member list for the user/group,
cube and range in the current database. This function is designed
specifically to allow you to view how many members are included in
a range created for fact security in a database. It displays the names
of all the members included in the range, whose index is specified.
This range is specified as a parameter for fact security rule in the
specified cube within a specified database.
The function has the following syntax:
Syntax: OLAPFactSecurityRangeMembers
(database, cube, rangeindex, dimensionindex )
Explained below are the parameters that have to be
provided when building this function.
- Database : Enter the name of the database which
has the cube that you want to access / enter the cell reference
which has the name of this Database.
- Cube : Enter the name of the cube which exists
in this database mentioned above and is the cube whose fact security
rules are the base for returning the results of this formula/instead
enter the cell reference which has the name of such a cube.
- RangeIndex : Enter the index for the range
which is included in the fact security rule in the cube specified
above. This is the range whose members will be displayed as the
result of the function.
- DimensionIndex : Enter the index for the dimension
included in the range specified above. This is the dimension whose
members will be accessed to return the result.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The cube must exist within this database and
it should be referenced by the accurate and exact name.
- The value for the parameters that take an "Index"
must be a positive real integer and should correspond to the argument
that you want to access for the function to return appropriate
values.
- 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 OLAPFactSecurityRangeMembers function
from the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name and the cube name. If you don't want to
manually enter the parameter you can use another function called
OLAPCube in order to get this value and then use that cell as
a reference for a formula.
- In the following example B1 is the cell that
holds the database name, B2 is the name of the cube , 3 is the
index of the "Range" in the fact security for this cube,
2 is the index of the dimension in the cube whose members are
included in the range.
=OLAPFactSecurityRangeMembers($B$1,
$B$2, 3, 2) |
The above formula returns a value = "Actual;
Current Budget; Forecast" which signifies that in the database
"Acuity" (B1), in the cube AP_Trans (B2), the members that
are included from the 3rd Range which belong to the dimension
"Version" (2) are the values that the formula has returned.