this are my first steps in AWM, mostly I tried to manage all over OWB. But know, I want to do simple actions over AW and the OLAP-Packages.
I am not lazy, but I don't know where to find simple thinks like truncate a cube (I don't want to load the cube again).
So please, how can I truncate the data ? Or, where can I find samples?
Thanks a lot from sunny Berlin
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);
The CLEAR command should be fast, so there must be something wrong. Did you detach the AW from AWM before running this PL/SQL? What is the last command to run in the CUBE_BUILD_LOG? How many partitions do you have?
Why does the parallel cube load not error out if it cannot attach the AW in MULTI mode?
The OLAP job keeps waiting (instead of erroring out), if another session has the AW attached in RW mode. This creates confusion.