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. (18.104.22.168 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; /