This function saves the specified database. The OLAPSave
function is designed specifically to allow you to save a database
that is specified in the parameter for the database name.
This function returns "True" if the database
is successfully saved or else if the database cannot be saved accurately,
it returns "False".
The function has the following syntax:
Syntax: OLAPSave
(server, database, file)
Explained below are the 3 parameters that have to
be provided when building this function.
- Server : Enter the name of the server which
has a database open on it, and is the database to which you want
to save changes to / enter the cell reference which has the name
of this server.
- Database : Enter the name of the database which
exists on the local drives of your computer and is the database
with which you want to establish a connection from Excel and subsequently
save it / alternatively enter the cell reference in the Excel
sheet which has the name of such a database.
- File : Enter the name and the complete path
for the .OLP file that stores the database name mentioned above,
and this is the file that's located on the local hard drives of
your computer / alternatively enter the cell reference in the
Excel sheet which has the name of such a file as its value.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The database name must exist on the computer
from where you are establishing a connection.
- The path for the file name should be correctly
specified and must match exactly with the location where the file
is saved.
- The database name argument is compulsory.
- The argument or server and file name are individually
compulsory. This implies that if you have a server name specified
that has the required database open on it, then you don't need
to enter a value for the file name parameter and similarly if
you have specified a file name, then you don't need to write the
server parameter and for both cases you can fill the parameter
that's empty with empty double quotes ("").
Example
This function may be easier to understand with an
example.
- In Excel, use the menu: Insert -> Function
and select PowerOLAP from the drop down list.
- Choose the OLAPSave function from the list
of functions provided and click "Ok".
- When building the formula enter the cell range
for the server name, where an already opened database resides
and the PowerOLAP database name as well as empty double quotes
for the "file name" parameter.
- Alternatively, put double quotes in the server
name parameter, and enter the values for the database name and
the path for the file name, which is the directory path where
that particular file is saved.
- In the following example, "" is the
parameter for the server name that is left blank here and "Acuity"
is the name of the PowerOLAP database. "C:\Acuity.olp"
is the path where this PowerOLAP database is stored.
=OLAPSave
("", "Acuity", "C:\Acuity.olp") |
The above formula signifies that the database
is "Acuity" (B1), and the path where its stored is "C:\Acuity.olp"
and the OLAPSave function identifies this database from its name and
the path of its storage and if there is an OLAPDatabase function already,
which means that a connection is established to the database, subsequently,
the OLAPSave allows the user to save any changes or additions that
need to be saved after the user has performed data access, data read
and data write operations through the facilities provided by all the
other PowerOLAP functions in Excel. This function returns a value
"True" if the database is successfully saved.
