This function returns True if the current database
is secure. This function is designed specifically to allow you to
check if the specified database has security feature enabled or not.
The function takes as a parameter the name of the database for which
you want to check the existence of security .
The function has the following syntax:
Syntax: OLAPIsSecureDatabase
(database)
Explained below is the parameter that has to be provided
when building this function.
- Database : Enter the name of the database for
which you want to ensure the existence of security / alternatively
enter the cell reference which has the name of this Database.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The database that is specified for the "database"
parameter mentioned above, should be the one for which you want
to check whether the security is enabled or not.
- This argument is compulsory.
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 OLAPIsSecureDatabase
function from the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name within which you want to check for the existence
of security.
- In the following example B1 is the cell that
holds the database name, and this database is the one for which
the function will determine if security is enabled or not.
=OLAPIsSecureDatabase
($B$1) |
The above formula returns a value = "True"
which signifies that the database "Acuity" (B1) has security
enabled.