Selecting Members From the POV Toolbar in Essbase

Note:

The information in this section applies only to Essbase 11.1.2.1.102 and later connections. If you are using earlier Essbase releases, the POV button functions as described in Hiding the POV Toolbar.

In Essbase, you can choose whether to display all members on the grid and hide the POV toolbar or to display the POV toolbar containing the POV members.

By default, all members are displayed on the grid, and the POV toolbar is hidden. In this mode, you can format POV member cells the same as you do other member and data cells, and select members from the ribbon.

If you choose to display the POV toolbar containing the POV members, you can use the POV toolbar to select members and move them to and from the grid as described in Selecting Members From the POV Toolbar.

To display the POV toolbar, from the Essbase ribbon, select POV. To hide the POV toolbar and display all members on the grid, toggle POV off.

Note:

On worksheets that contain multiple grids, the POV button is disabled. In these worksheets, the POV toolbar is hidden, and all members are displayed the grid.

In Figure 3, All Members Displayed on Grid, the POV button is toggled off, the POV toolbar is hidden, and all members are on the grid.

Figure 4, POV Toolbar Displayed shows the POV toolbar on the grid. Measures and Year are displayed on the grid; POV members Product, Market, and Scenario are displayed on the POV toolbar.

Figure 3. All Members Displayed on Grid

The POV button is toggled off. All POV members Product, Market, and Scenario are displayed in the top row. Measures is a column member; Year is the row member.

Figure 4.  POV Toolbar Displayed

The POV button is toggled on. The POV toolbar is displayed; it contains the POV members Product, Market, and Scenario.