Writing back values

In a multidimensional database, data is stored in base cells. The values of consolidated or aggregated elements. Total Sales and All Products, for example, are aggregations of the values of the base cells. You can use these formulas to execute write back to aggregated cells:

CELL.WRITE
DBSET
CELL.ALLOCATE

Note: To write back values to aggregated data cells, use you must enable client-side splashing.

See Enabling client-side spreading.

For data modeling or budgeting purposes, you can allocate values to the base elements of consolidated elements in a variety of ways. These include Weighted distribution and Equal distribution.

Weighted distribution is used automatically if the base elements have values that are not equal to zero. Equal distribution is used if the base elements have zero values.

If you write back on a value which is calculated by Microsoft Excel, the write back methods available in the Write Back dialog are restricted to Weighted Distribution, Equal Distribution, and To each leaf. If you write back on a value which is calculated by CELL.GET, the full range of write back methods is available.

Note: However, writing back to cells which contain summed values is not possible if all these criteria are met :

The cell containing the sum also contains references to a CELLGET formula.
Automatic calculation is enabled
See Options
Either Microsoft Excel 2007 or earlier is used, or Excel 2010 without asynchronous formulas enabled.

Alea Ad-hoc reports, Ad-hoc reports and formula reports support the same write back methods and commands.

However, there are differences in writing back in different types of report.

In Alea-ad hoc reports, and in formula reports created from them, the Infor BI Splasher must be enabled. Infor BI Splasher implements write back commands that you enter directly into cells.

See Splasher options.

In Ad-hoc reports, and in formula reports created from them, you can use the Write Back dialog or you can enter write back commands directly into cells.

Alea Ad-hoc and Ad-hoc reports use different dialogs for reallocation.

See Reallocation.

Also, in Ad-hoc and formula reports, you can write back with these formulas:

CELL.GET
CELL.WRITE
CELL.ALLOCATE

Data elements

Microsoft Analysis Services supports data elements. A data element is a copy of a parent element but without the status of a parent. So, you can write back to a data element without affecting the child elements.

Example

You have a hierarchy of staff in which the manager is the parent element. If you are planning the salary of the manager, you can write back a value to the Manager data element instead of to the Manager element. In this way, the salaries of the other staff do not affect, and are not affected by, that of the manager