Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 51)

Figure 37 Result of Pivoting (Navigate Without Data Enabled)

5 In cell G1, click the secondary mouse button on Market and drag Market to product 100 (cell A4).

Essbase executes the pivot without retrieving data. The result is shown in Figure 38.

Figure 38 Result of Pivoting (Navigate Without Data Enabled)

Navigating without data also works with the Keep Only and Remove Only commands.

➤ To navigate without data when using the Keep Only or Remove Only command:

1 Select Qtr1 (cell D2) and Qtr2 (cell E2) and select Essbase > Keep Only.

Essbase retains only the selected members and does not retrieve data, as shown in Figure 39.

Figure 39 Result of Keep Only (Navigate Without Data Enabled)

2 Select products 300 (cell B7), 400 (cell B9), and Diet (cell B11) and select Essbase > Remove Only.

Essbase executes the Remove Only command without actually querying the database for

information, as shown in Figure 40.

Pivoting, Retaining, and Suppressing Data

1 2 ... 46 47 48 49 50 51 52 53 54 55 56 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 51