It is often possible to generate a list of entities from a specific entity. For example, you can access a list of holdings for a specific account or a list of companies in a specific industry. To derive an entity list from a specify entity, you use local options to define the entity type and the entity and you define the access rule in the first cell of the entity dimension. Select the range from B11 to D12 2. After the extract, column C will contain the name of each security held in account XYZ as of year-end 1993 and column D will contain the number of shares held.
Any extraction can include labels for the row, column, and scalar values.
If the first cell in the second row of your request is empty column headers will be displayed in this row after the request has run. If the first row of the second column of your request is empty, row labels will be displayed in this column after the request has run. If both row and column labels are displayed, the scalar label will display as well. This is useful if you want to automatically display the primary key for an entity dimension or if your want to display the actual dates used when relative dates are defined for the time dimension. The results will include row labels in column C and column headers in row 12.