ViewConstruct

ViewConstruct constructs, pre-calculates, and stores a Stargate view in memory on a server. This function is useful for pre-calculating and storing large views so they can be quickly accessed after a data load or update.

This function is valid in processes only.

Syntax

ViewConstruct(CubeName, ViewName);

Argument

Description

CubeName

The cube from which you want to construct the view.

ViewName

The view you want to construct. This view must be an existing public native view on the server.

You cannot use an MDX view. An attempt to use an MDX view results in a View not found error.

Example

Viewconstruct('99sales', '1st Quarter Actuals');  

This example creates the view 1st Quarter Actuals of the 99sales cube.