OLAPCurrentUser

Description:

This function returns the name of the current user in the current database. This function is designed specifically to allow you to view the user entity who is at present connected to the specified database. It is the name of the user who has currently opened an instance of the database, or who has currently established a connection to the database. The function takes as only one parameter, i.e.., the name of the database.

The function has the following syntax:

Syntax: OLAPCurrentUser (database)

Explained below is the 1 parameter that has to be provided when building this function.

• Database : Enter the name of a database which has security enabled and which requires a username and password to logon for the cube name that you want to access / 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 should have security enabled or else this function is redundant.
• These 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 OLAPCurrentUser function from the list of functions provided and click "Ok".
• When building the formula enter the cell range for the database name or you can manually enter the database name.
• In the following example B1 is the cell that holds the database name.

=OLAPCurrentUser ($B$1)

 

The above formula returns a value = "Administrator" which signifies that for the database "Acuity" (B1), the user who is currently connected to it or has opened an instance in the modeler, this user is "Administrator".

The user "Administrator" exists in the database as a valid user with a password and the logon to the database is activated only when security for the database is enabled through checking the secure database check mark.