Organizing Reports in Folders: This screen capture of Analytic Workspace Manager shows the navigation tree on the left and the report on the right.

The tree shows the following:

Databases folder (expanded)

• olap112 (global) - OLAP 11g folder (expanded)

  • Schemas folder (collapsed)

  • Reports folder (collapsed)

  • My SQL Reports folder (expanded)

    • - My User Tables report

    • - My User Views report

The report shows the query, SELECT view_name FROM user_views, and the query results, which is a list of views owned by GLOBAL:

CHANNEL_PRIMARY_VIEW
CHANNEL_VIEW
CUSTOMER_MARKET_VIEW
CUSTOMER_SHIPMENTS_VIEW
CUSTOMER_VIEW
PRICE_CUBE_VIEW
PRODUCT_PRIMARY_VIEW
PRODUCT_VIEW
TIME_CALENDAR_VIEW
TIME_FISCAL_VIEW
TIME_VIEW
UNITS_CUBE_VIEW