Types of Linked Regions

This manual is in pilot operation.

Types of Linked Regions

There are three types of linked regions as outlined in the Linked Regions.

(1) Data Region

This is the area where cell values from the fusion_place ledger are fetched. Conversely, values in the cells of this region can also be written back to the ledger. A single region can be used for both fetching and writing back data. That is, data can be fetched from fusion_place into this area, modified, and then written back to fusion_place.

(2) Member Name Display Region

This is the area where the names of members included in the dimensions of fusion_place are displayed. It is only capable of display, and data cannot be written back to fusion_place. The language for displaying member names can be switched at Switching Languages.

(3) Text Value Display Region

This region displays not just the names of members but also strings composed using labels, names, and member property values. A dialect of the Text Expression is used to instruct how the strings are assembled. This region is also display-only, and data cannot be written back to fusion_place. The language for displaying text can be switched at Switching Languages.

When creating text, the dimension members specified in the key designated columns and rows are referenced. For example, you can display strings that combine labels and names of members specified for each row or column. This can be used when displaying member names alone is not sufficient.

Each linked region can be set as one of the above three types in the Settings of Linked Regions dialog box. Details such as the data source ledger for the data region and text expressions for the text value display region can also be set in the same screen.

In the previous sheet example, the first linked region (E11:E15) is a "Member Name Display Region," and the second linked region (G11:H15) is a "Data Region." There is no text value display region.