Viewing Block Storage Option (BSO) Data Storage Values Assigned to Member Properties

To understand what BSO data storage values are assigned to members, use the HPM_DIM_MEMBER_PROP_V view to debug when the deploy to Oracle Essbase fails for the BSO Calculation cube.

The view consists of the following columns:

APPLICATION_NAME

DIMENSION_NAME

MEMBER_NAME

BSO_DATA_STORAGE

DIMENSION_STORAGE_TYPE

When queried, the view returns a row for each dimension member in each deployed Oracle Hyperion Profitability and Cost Management application.