This content has been marked as final. Show 3 replies
Thanks Nisar for your post.
I am new to OLAP.
DO I need any specific grants to be able to call DBMS_CUBE.BUILD??
Is there any syntax error in command I am executing?
You need to use the schema name (OOWAAPP) in the script, not the name of the analytic workspace (PEN_NB2_STD). So try this.
BEGIN DBMS_CUBE.BUILD('OOWAAPP.ANTAL_PERSONER_CUBE USING (CLEAR, LOAD, SOLVE)','S',false,1,true,true,false); END;