new **wss 1/25/23
How do I manually adjust the range of a cube column?
GoWSI does not recommend directly editing the cube column ranges but there are situations where it may be more convenient to do a quick adjustment to an already published cubes, or to control a simple non-updating cube without having to go through variables (eg: a full year budget cube that only gets rolled forward once a year).
Understanding the relationship between cube ranges and columns, though, can be useful for figuring out why the results in cube periods may appear to be out of period or out of year.
Cube column ranges may also need to be edited in situations where the underlying source data contains multiple versions. For example, if the Payroll Budget table contains data for both a published set of SALBUDGET data and FORECAST data for a single fiscal year then all payroll budget columns will need to have the additional set of filtering applied.
It is important to understand how the cube columns connect to the underlying tables and fields.
On the A: Cube Manager tab you’ll find the C: Cube Layout sub-tab.
The Fieldname column contains the linking value between the columns in the cube and the B: Tables and Fields tab.
On the top grid of the B: Tables and Fields tab you can see a listing of all data sources for the cube. The Notes column typically contains the destination Fieldname if relevant. If you click on a line you can see the detailed information on the bottom A: Source Fields tab.
The Target Fieldname column shows the exact column that will be filled out by the table source. GoWSI recommends not altering any data in this tab without assistance.
Now that we’ve confirmed that the table is supplying data to the column we’re inspecting we can evaluate the ranges on the column in the B: Ranges tab.
If the table is having its range limited from a parameter it will have a special Range Type (see Technical Documentation for this listing) or the Variable Begin/Variable End columns will be filled in.
If you need to create a new range filter for the data source use the ‘+’ at the bottom to create a new line. You’ll want to fill out the FieldName the range is on, and the Range Type if applicable.
To edit an existing line, or to edit a newly created line, select the line and go into the bottom Options -> Modify Range.
The Range Builder window will pop up. See the Technical Documentation for the information on the various filters.
From this popup you can modify the range as needed, Test Using Database Data if you want to test the results (most useful for the Evaluate Expression option), and then hit OK to save or Cancel to back out.
Your changes will take effect the next time the cube is rebuilt.