I want to create a cube in olap analytic workspace 11g, I have a problem with time dimension. I have followed the instructions from here
http://st-curriculum.oracle.com/obe/db/11g/r1/olap/cube/buildicubes.htm. I tried to create time dimension having type time by hand , but the program just crashed.
and we needed database restart to kill a process, it hanged during compilation, when I tried 'Maintain Cube Cube_Name ' .
Also I have tried to use olaptrain's template TIME.XML, it compiled correctly , but ended showing the info in 'view data Cube_Name' , even when I don't choose the time dimension in Measure Data Viewer.