This content has been marked as final. Show 2 replies
Run the following to list the dimension objects in the AW.
The error suggest that TIME is not a dimension in the AW. It is possible that you will find something like "TIME1" instead due to the creation mishap. To locate the name of the physical dimension associated with a logical (AWM) dimension you can do this. (126.96.36.199 or higher.)
set serverout on begin dbms_aw.execute(q'! aw attach USER1.SALESTRACK_USER1 listnames dimension !'); end; /
set serverout on begin dbms_aw.execute(q'! show objorg(dim owner 'USER1' 'TIME') !'); end; /
Thanks, I already did an AWDESCRIBE in the Workbench and found TIME1, just as you say. I deleted the cube and the TIME dimension then rebuilt it, and it works fine now.