Results of the unnamed <AWMNode> nested under the MyLevels <AWMNode> in aw.xml: This figure shows the navigation tree in Analytic Workspace Manager with the TOTAL item selected. The property inspector displays the report.
The report shows the query, select * from user_cube_dim_levels where dimension_name = ? and level_name = ?, and the result of the query, which is a table with three columns. The headings of the columns are DIMENSION_NAME, LEVEL_NAME, and DESCRIPTION. The values of the single row are CHANNEL, TOTAL, and TOTAL.