This content has been marked as final. Show 5 replies
OLAP cube loading and clearing questions have been asked many times on this OLAP forum. Search this forum.
Search Terms: BUILD(CLEAR)
Date Range: ALL
After you get the results, then Sort by DATE.
Here are some samples:
Clearing a Partition of a cube
CUBE_DFLT_PARTITION_LEVEL in 11g?
Four Options for Clearing Cube data
DBMS CUBE BUILD
Another Clear Cube example
Reclaiming space in OLAP 18.104.22.168
DBMS_CUBE.BUILD documentation is very helpful also
Good Morning from Berlin :)
Thanks for your answer :) I found this solution, but I though there is a better, faster way. Cause I tried exactly this.
This ion ( parallel 6) runs 13h and don not come to an end. The server, database is running fast with 24 cores, 300 GB RAM and fast disks.
The only way to reset cube data is at the moment (for me) to drop and recreate it with OWB, but that isn't the solution I want to use in the
future ( only in special situations I have to truncate cube data).
I tried to "truncate" data two times with this the last 2 days:
dbms_cube.build('CUB_MEMBER_TRANSACTION_F USING(CLEAR)', add_dimensions=>false, parallelism=>6);