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.
- Is it possible without using materialized views?
- 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.
Thanks in advance.