Oracle 12c OLAP Option enable "on commit" refresh mode

154 Views Asked by At

I've created a cube using Oracle 12c OLAP option.

I would like to refresh the cube automatically when the data in the underlying tables change.

  1. Is it possible without using materialized views?
  2. With materialized views, couldn't enable refresh mode - 'on commit'. Has this option been removed in 12c? The following image shows "Refresh Mode" as non-editable.

Cube config showing refresh mode as non-editable

Thanks in advance.

0

There are 0 best solutions below