To determine which Roles and System/Table Privileges have been granted to Roles like %OLAP% consider running this script.
This script was run on a clean 11.1.0.6 Instance

set lines 110 pages 1000 ver off
col role for a22
col pv for a75 hea 'PRIVILEGE OR ROLE'
bre on role on type skip 1

define rolecheck = 'OLAP'

select role, 'ROL' type, granted_role pv
from role_role_privs where role like '%&rolecheck%' union
select role, 'PRV' type, privilege pv
from role_sys_privs where role like '%&rolecheck%' union
select role, 'OBJ' type,
max(decode(privilege,'WRITE','WRITE,'))||max(decode(privilege,'READ','READ'))||
max(decode(privilege,'EXECUTE','EXECUTE'))||max(decode(privilege,'SELECT','SELECT'))||
max(decode(privilege,'DELETE',',DELETE'))||max(decode(privilege,'UPDATE',',UPDATE'))||
max(decode(privilege,'INSERT',',INSERT'))||' ON '||object_type||' "'||a.owner||'.'||table_name||'"' pv
from role_tab_privs a, dba_objects b
where role like '%&rolecheck%' and a.owner=b.owner and a.table_name=b.object_name
group by a.owner,table_name,object_type,role union
select role, '---' type, 'this is an empty role ---' pv from dba_roles
where not role in (select distinct role from role_role_privs) and
not role in (select distinct role from role_sys_privs) and
not role in (select distinct role from role_tab_privs) and role like '%&rolecheck%'
group by role order by role, type, pv;

ROLE.............TYP PRIVILEGE OR ROLE
---------------- --- ---------------------------------------------------------------------------
OLAPI_TRACE_USER OBJ EXECUTE ON PACKAGE "SYS.DBMS_XSOQ"
.....................EXECUTE ON PACKAGE "SYS.DBMS_XSOQ_UTIL"
.....................EXECUTE ON PACKAGE BODY "SYS.DBMS_XSOQ"
.....................EXECUTE ON PACKAGE BODY "SYS.DBMS_XSOQ_UTIL"
.....................SELECT ON SEQUENCE "SYS.OLAPI_HISTORY_SEQ"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_IFACE_OBJECT_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_IFACE_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_MEMORY_HEAP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_MEMORY_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "SYS.OLAPI_SESSION_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.GV_KSMHP"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.GV_OLAPI_IFACE_OBJECT_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.GV_OLAPI_IFACE_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.GV_OLAPI_MEMORY_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.GV_OLAPI_SESSION_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.V_OLAPI_IFACE_OBJECT_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.V_OLAPI_IFACE_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.V_OLAPI_MEMORY_OP_HISTORY"
.....................SELECT,DELETE,UPDATE,INSERT ON VIEW "SYS.V_OLAPI_SESSION_HISTORY"

OLAP_DBA.........OBJ SELECT ON SEQUENCE "OLAPSYS.XML_LOADID_SEQUENCE"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_AW_NEXT_TEMP_CUST_MEAS"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_AW_TEMP_CUST_MEAS_MAP"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_TEMP_VALUES"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.XML_LOAD_LOG"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.XML_LOAD_RECORDS"

.................PRV CREATE ANY CUBE
.....................CREATE ANY CUBE BUILD PROCESS
.....................CREATE ANY CUBE DIMENSION
.....................CREATE ANY MEASURE FOLDER
.....................CREATE ANY TABLE
.....................CREATE ANY VIEW
.....................CREATE JOB
.....................CREATE SEQUENCE
.....................DELETE ANY CUBE DIMENSION
.....................DELETE ANY MEASURE FOLDER
.....................DELETE ANY TABLE
.....................DROP ANY CUBE
.....................DROP ANY CUBE BUILD PROCESS
.....................DROP ANY CUBE DIMENSION
.....................DROP ANY MEASURE FOLDER
.....................DROP ANY TABLE
.....................DROP ANY VIEW
.....................INSERT ANY CUBE DIMENSION
.....................INSERT ANY MEASURE FOLDER
.....................INSERT ANY TABLE
.....................SELECT ANY CUBE
.....................SELECT ANY CUBE DIMENSION
.....................SELECT ANY TABLE
.....................UPDATE ANY CUBE
.....................UPDATE ANY CUBE BUILD PROCESS
.....................UPDATE ANY CUBE DIMENSION
.....................UPDATE ANY TABLE

OLAP_EMPTY_ROLE. --- this is an empty role ---


OLAP_USER........OBJ SELECT ON SEQUENCE "OLAPSYS.XML_LOADID_SEQUENCE"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_AW_NEXT_TEMP_CUST_MEAS"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_AW_TEMP_CUST_MEAS_MAP"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.CWM2$_TEMP_VALUES"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.XML_LOAD_LOG"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "OLAPSYS.XML_LOAD_RECORDS"

.................PRV CREATE CUBE
.....................CREATE CUBE BUILD PROCESS
.....................CREATE CUBE DIMENSION
.....................CREATE JOB
.....................CREATE MEASURE FOLDER
.....................CREATE SEQUENCE
.....................CREATE TABLE
.....................CREATE VIEW

OLAP_XS_ADMIN....OBJ EXECUTE ON FUNCTION "SYS.AWM_CREATEXDSFOLDER"
.....................EXECUTE ON PACKAGE "SYS.DBMS_XDS"
.....................EXECUTE ON PACKAGE "SYS.DBMS_XS_SECCLASS_INT"
.....................EXECUTE ON PACKAGE "XDB.DBMS_XDB"
.....................EXECUTE ON PACKAGE BODY "SYS.DBMS_XDS"
.....................EXECUTE ON PACKAGE BODY "SYS.DBMS_XS_SECCLASS_INT"
.....................EXECUTE ON PACKAGE BODY "XDB.DBMS_XDB"
.....................EXECUTE ON TYPE "SYS.DBMS_XS_PRIVID_LIST"
.....................SELECT ON VIEW "SYS.DBA_ROLES"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "XDB.XDB$ACL"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "XDB.XS$DATA_SECURITY"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "XDB.XS$PRINCIPALS"
.....................SELECT,DELETE,UPDATE,INSERT ON TABLE "XDB.XS$SECURITYCLASS"