DataMaestro Knowledge Base

This option allows you to process data from a single cube to one of the following:

• Another location within the same cube

• A different cube

• A target text file

Selecting the Source

Steps to define your single-cube source data are as follows:

1. Choose the source cube from the Cube selector. Cubes are listed in alphabetical order.

Note: If you want to hide or view Control Cubes in the list, check the View Control Objects checkbox on the upper right corner of the screen.

2. After choosing the source cube, the list of all dimensions of that cube will appear. If you do nothing, all data from the cube will process to itself, which really isn’t the point. To narrow down your data set, select specific elements from your filter dimensions. For example, you might want to filter on a specific Version (Budget), Year (2021) and Region (Europe) to process from.

Click one of the dimension edit boxes to open its Select Element window. From that window you can select the source element by element name or by one of its Aliases. To find the element you are looking for, either use the drill-down element selector or type a series of characters in the Search bar. Note: Element search is case sensitive.

Continue the same steps with all of the dimensions that you want to filter on.

Selecting the Target

If you chose the Single Cube source type, you will have the option of processing data into the same cube, a different cube or a .TXT file of your choosing.

Same Cube Target Type

The source cube and its dimensions will appear on the target side of the screen. For each source dimension you filtered on, you will have the option to choose where to send the data in the target location.

• If you chose a base-level (N) element as the source, then you will only be able to send data to the same element or to another base-level element of your choosing. Click the dimension edit box to choose your element.

• If you chose a consolidated (C) element as the source, then one of the following options will apply:

  • Choose the same consolidated element as the target to process to all base-level descendants of the element. For example, you might want to perform a copy of your Budget data to Q1 Forecast, but only for all cities in the region Europe. This is the default option.

  • Choose a base-level element as your target. Data for the consolidated source element will process to the base-level element you choose.

Repeat the above step for each source dimension you filtered on.

Choose your Insertion Method on the Target side. That determines how values will be processed into the target data cells.

• The default method is Replace Target Value, which means the value currently in the target cell will be replaced with the new source value.

• Alternatively, you can choose Add to Target Value, which will add the source value to the current value in the target cell and place the result in the target cell.

Note: Data will not process into Target elements that are governed by a Rule calculation. This is determined during processing, not in advance. Some elements may be both enterable and governed by a Rule. For example, there might be a “Sales = Price * Units” Rule on the Sales element only for the Budget version but not for Actuals.

Different Cube Target Type

By default, the source cube and its dimensions will appear on the target side of the screen. Click the Cube edit box to select a different cube to process into. The target side of the screen will update to display the dimensions of the target cube.

In terms of the dimensions on either side, you have three different scenarios to consider:

1. Dimension exists in Source cube, but not Target cube

• If you choose no element for that source dimension, DataMaestro will process the grand total (using addition) of all base-level (N) elements of the dimension.

• If you choose a consolidated (C) element for that source dimension, DataMaestro will process the grand total (using addition) of all base-level (N) descendants of the C element.

• If you choose a base-level (N) element for that source dimension, DataMaestro will process the data for that specific base-level element.

2. Dimension exists in Target cube, but not Source cube

You must choose a single base-level (N) element of that target dimension into which DataMaestro will process the data.

3. Dimension exists in both Source and Target cubes

For all dimensions that both cubes have in common, follow the same rules and steps as per the Same Cube instructions above.

Repeat the above choices for all source and target dimensions you want to define.

Choose your Insertion Method on the Target side. That determines how values will be processed into the target data cells.

• The default method is Replace Target Value, which means the value currently in the target cell will be replaced with the new source value.

• Alternatively, you can choose Add to Target Value, which will add the source value to the current value in the target cell and place the result in the target cell.

Note: Data will not process into Target elements that are governed by a Rule calculation. This is determined during processing, not in advance. Some elements may be both enterable and governed by a Rule. For example, there might be a “Sales = Price * Units” Rule on the Sales element only for the Budget version but not for Actuals.

File Target Type

If you want to export your source data to a .TXT file, you don’t have to do anything once you’ve selected File as your Target Type. The filename will be generated automatically by DataMaestro and saved to the Planning Analytics server's default export location.

<< Back to Choosing Source Data

<< Back to Creating and Editing a Task