Creating a virtual cube

You create a virtual cube in a model that has been opened in the IBM® Cognos® Dynamic Cubes API. After you create a virtual cube, you then associate source cubes to the virtual cube.

Creating a virtual cube - VirtualCube

The virtual_cube command creates a virtual cube called VirtualCube. The identifier contained in the response is used in subsequent commands to refer to the virtual cube.

Input JSON data
{
  "parent":"<modelId>",
  "mergeOperator":"sum"
  "name":"VirtualCube",
}
Output JSON data
{
  "id":"<cubeIdVirtual>"
}

Adding source cubes

The parent model contains source cubes named Sales and Forecast, with ids of <cubeIdSales> and <cubeIdForecast>, respectively.

The virtual_source command associates the source cubes to the virtual cube. The identifier contained in the response is used in subsequent commands to refer to the source cube.

Input JSON data
{
  "parent":"<cubeIdVirtual>"
  "sourceObject":"<cubeIdSales>",
}
Output JSON data
{
  "id":"<vSourceSales>"
}
Input JSON data
{
  "parent":"<cubeIdVirtual>"
  "sourceObject":"<cubeIdForecast>",
}
Output JSON data
{
  "id":"<vSourceForecast>"
}

If one or more of the source cubes is deployed as a data source in the content store, use the sourceName and sourcePath properties to identify the cube, instead of the sourceObject property.