This content has been marked as final. Show 6 replies
Consider choosing "Force" which performs a fast refresh if possible, otherwise it does a complete refresh. You can also specify Complete as the refresh method in the Maintenance Wizard dialog the first time you maintain the cube.
You will need to create materialized view logs on all the base tables if you have not done so already, otherwise the cube will never be able to do a Fast (incremental) refresh.
i created materialized view log for all the base tables and that error got resolved. But my requirement is that, when i delete the data in RDBMS, the corresponding data in cube also gets deleted when i give maintain the analytic workspace(with Fast refresh and cube script without clear command). i want the cube to hold the data which i have deleted from RDBMS. Can u pls help me on this???
If you want the cube to hold data even after it has been deleted from the relational table, then you should disable the MV on the cube.
Synchronization with the source table is determined by the default "cube script".
<li>CLEAR, LOAD, SOLVE : This will synchronize your cube with the source table. It is a requirement for MVs.
<li>LOAD, SOLVE: This will allow your cube to contain data even after it has been removed from the source table. It sounds like you want this.
Cube builds can be "incremental" in one of two ways.
(1) You can have an "incremental LOAD" if the source table contains only the changed rows or if you use MV "FAST" or "PCT" refresh. Since you can't use MVs, you would need a source table with only the changed rows.
(2) You will have an "incremental SOLVE" (a.k.a. "incremental aggregation") if there is no "CLEAR VALUES" or "CLEAR AGGREGATES" step and various other conditions hold.
To force a "complete LOAD" with an "incremental SOLVE" you should have all rows in your source table and run the following build script.
You could also run "CLEAR LEAVES, LOAD, SOLVE" to synchronize the cube with the table.
To force an "incremental LOAD" with a "complete SOLVE" you make the source table contains only the changed rows and the run the following:
CLEAR AGGREGATES, LOAD, SOLVE
Finally, if you want both LOAD and SOLVE to be incremental you make the source table contains only the changed rows and the run the following:
LOAD, CLEAR AGGREGATES, SOLVE