CUBERead (Cube, Member1, Member2,…)

Description:

This function reads a point from a PowerOLAP cube in a database. You must specify the cube to read from. 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 CUBERead function allows the user to pull in values from any Cube in the same PowerOLAP database that is opened. 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 can be responsible for not pulling in values from the source cube because an exact match is completely necessary.>

Syntax: CUBEREAD (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 the user.
• All arguments are compulsory.

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".



This formula above reads values from the "Future Year Model" cube in the same database into the "Current Year Model Cube".