OLAPNavigateRW

Description:

This function builds a ReadWrite slice over the specified range for the selected cube.

OLAPNavigateRW is a function which allows for writing back values from Excel to the actual PowerOLAP database.

The function has the following syntax:

Syntax: OLAPNavigateRW (server, database, file, cube, k1, k2, ...kN)

Explained below are the parameters that have to be provided when building this function.

• Server : Enter the name of the server where the database you want to access is running or opened.
• Database : Enter the name of the database which has the dimension you want to access.
• File : Enter the name of the PowerOLAP database file and location.
• Cube : Enter the cube name which exists in the database specified above that you want to access.
• Members (k1, k2, ...kN) : Enter the name of the member from which a relationship will be established to determine the point where the values that you have entered in Excel will be written back to.

Remarks

• If the database is not running on the server, leave the parameter for server blank but make sure to enclose it in double quotes ("").
• The file location of the database must be accurate and spelled correctly.
• The database name, the cube name and the member names must be referenced by their exact name and should exist as such within the database.
• The member names should be chosen as such, that they allow the function to determine the exact intersection points for which it should write back the values to. The way that they should be specified in the formula should be in the order that the corresponding Dimensions were arranged in the cube.

Example

This function may be easier to understand with an example.

• For example, in a certain cell we want to change the value for Actual Canada sales in February. First let us perform an OLAPNavigate formula that will return this value.
• Then, after the value is returned on the assigned cell (e.g. B7) let us change the value to another figure.
• Change the OLAPNavigate function to OLAPNavigateRW. Then hit Enter.
• Once you refresh excel (F9), go back to the corresponding slice in your PowerOLAP database then click recalculate (F9).

As a result, the specified data point will now have a new value which is the value you previously entered in the Excel spreadsheet.