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 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?