This function reads and writes a point from a PowerOLAP cube to another cube in the same database. You must specify the cube to read from and write to. You must specify a member for each dimension in the cube. Important: The members must be in the exact order of the dimensions in the remote cube. The CUBEReadwrite function allows the user to read or write values bidirectionaly, from any Cube to any other cube in the same PowerOLAP database that is opened. The values will appear as detail values in both the cubes.
It only applies to details values. The dimensions and their members in the cube in PowerOLAP must be an imitation of the dimensions and the members of the source cube. They also must be created in the same order of the dimensions in the remote cube. Although the cube in PowerOLAP must contain all the dimensions that exist within the source cube, however those dimensions need not contain all the members in the cube. You may create only those members within which you want to populate values, and display the same. These member names in which you pull in values, must match exactly with the member names in the source database and even a small typing error.
Syntax: CUBEREADWRITE ( Cube, Member1, Member2,…)
- Cube : Specify the name of a cube in the database mentioned above.
- Member1 : Specify the name of the member in the 1st dimension of this cube.
- Member2 : Specify the name of the member in the 2nd dimension of this cube.
- Member-n : Specify the name of the member in the nth dimension of this cube.
Remarks
- The name of the database, the cube and the member names supplied to the function must be a valid and should exist in the database and must be spelled accurately.
- The cube that is referenced above should be allowed access to from the server supplied also as a parameter.
- The Server name should be valid and spelled accurately as well as, it should have the PowerOLAP database opened on it.
- All arguments are compulsory and neither argument is optional.
Example
Let us use "UsingPO" database to illustrate this example. The dimensions and their members in the "Future Year Model" are an imitation of the dimensions and the members of the cube "Current Year Model". We are pulling in data from--. In this example we are reading data into Current Model cube in PowerOLAP from "Using PO database".
.png)
This formula above reads and writes values from the "Future Year Model" cube in the same database into the "Current Year Model Cube". This formula also reads and writes values from the "Current Year Model" into the "Future Year Model Cube". The values written appear as detail values in both cubes. The formula only applies to Detail values.