Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 60)

● Linked object cells

● Integration Server Drill-Through cells

● Read-only cells

● Read/write cells

● Parent member cells

● Child member cells

● Shared member cells

● Cells containing formulas

● Dynamic calculation member cells

● Attribute cells

● Dimension cells

The only way you can apply a background color to data is to define a style for dimensions. If

dimension styles are defined and the Use Styles setting is turned on, a background color is always

defined for members of a dimension.

The text styles that you can apply to members, dimensions, and data cells are hierarchical and

determine which characteristics are applied. Member styles are at the top of the hierarchy. Thus,

member styles are always applied if styles are turned on. Notice that in Figure 48 on page 59, the

Qtr1 label in cell B6 is in bold italic navy font, and has a yellow background. The navy font comes

from the style defined for parent members, and the yellow background comes from the style

defined for Year.

If you want to see a child member style, make sure that the parent member style is turned off.

If you want to see a shared member style, make sure that both parent and child member styles

are turned off.

Removing Styles

Styles can be very helpful tools for keeping track of data in Spreadsheet Add-in. Applying styles,

however, involves additional processing time during a retrieval request. This additional

processing has a slight impact on the speed of Essbase retrievals.

If you do not want to apply styles to the worksheet view, you can clear them. You can also turn

off styles so that they are not displayed when you refresh the view (by selecting Essbase > Retrieve,

for example). So that the worksheet matches the illustrations presented in the following tasks,

do not remove styles if you are going through the tutorial.

If styles are applied to the worksheet and you execute the FlashBack command, these styles are

temporarily removed from the current view. The styles are reapplied whenever you initiate a

retrieval.

This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information

only.

To remove all styles from a worksheet:

Basic Tutorial

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 60