This function returns the indexed member for the cube,
range and dimension in the current database.
This function is designed specifically to allow you
to view the members in a specific fact security range.
This function is designed specifically to allow you
to view the names of the members that are included in a specified
fact security rule. The desired member name/ names can be accessed
by specifying the database and the cube where the rule is written,
the index of the rule written, the index of the dimension in that
rule and finally the index of the member in that dimension. This implies
that in a cube there can be one or more fact security rules written
and within those rules there can be one or more dimensions that are
referenced and within those dimensions there can be one or more members
for which the rule is defined. Therefore it is essential to specify
the index for all these criteria in order to reach the exact point
to access the desired member name that is the result returned by the
formula.
The function has the following syntax:
Syntax: OLAPFactSecurityMember
(database, cube, rangeindex, dimensionindex, memberindex)
Explained below are the parameters that have to be
provided when building this function.
- Database : Enter the name of the database which
has the dimension and 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 High-Levels
you wish to take a count of / instead enter the cell reference
which has the name of such a dimension.
- RangeIndex : Enter the index of the RANGE that
is included in the fact security rule that you are accessing.
- DimensionIndex : Enter the index of the dimension
included in the fact security rule.
- MemberIndex : Enter the index of the member
in the dimension, referenced above, which name the function has
to return.
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.
- 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 OLAPFactSecurityMemberfunction 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. Also enter the index for the range,
the dimension index and the index for the member that you want
to view.
- In the following example B1 is the cell that
holds the database name, B2 is the name of the cube, 1 is the
index for the rule, 3 is the index for the dimension in that rule,
and 1 is the index for the member in that dimension.
OLAPFactSecurityMember
($B$1, $B$2,1,3,1) |
The above formula returns a value = "Opening_Balance"
which signifies that in the database "Acuity" (B1), and
within that in the cube "AP_Trans" (B2), there is a fact
security rule existing at the index 1 and within that rule more than
1 dimensions are accessed and the dimension this example is accessing
at index 3 is "Time (Periods)" from where this example is
accessing the 1st member referenced in the security rule,
which in this case is "Opening_Balance".