CELL.WRITE

Use CELL.WRITE to write back to base elements.

Note: In a query-based formula report the settings for non-immediate write-back do not work correctly when you use DBSet or Cell.Write in an Infor BI O+ formula.

DBSet: Writes the value directly into the OLAP DB
Cell.Write: When entering the value, the icons are inactive. If you close or save the formula report, the non-immediate write-back dialog appears. Saving the value in the report leads to an error when you close and reopen the report and try to save.

Syntax

=CELL.WRITE(Value, Alias, Cube, Memb 1, Memb 2, ...)

Arguments

This table describes the arguments of the function:


Argument	Description	Example
Value	Value	100000
Alias	Name of the database alias	Foodmart 2008
Cube	Name of the cube	`[Budget]`
Memb 1 Memb 2 Memb 3 Memb 4...	Unique names of the base elements	`[Store].[All Stores].[Canada].[Vancouver].[Store 19];` `[Measures].[Amount];` `[Time].[1997].[Q1].[2];` `[Account].[Assets];[Category].[Forecast];`

Note: Because you can write back only to base elements, you must select an element at the lowest level in all dimensions.

Example

You plan an asset of $100,000 for Store 19 for February 2004.

=CELL.WRITE(100000,"FoodMart 2008","Budget",
	 "[Store].[All Stores].[Canada].[Vancouver].[Store 19]","[Account].[Assets]",
"[Category].[Forecast]","[Measures].[Amount]","[Time],[2004].[Q1].[2]")