This content has been marked as final. Show 4 replies
But the cube just would not build.Please explain exactly what happens. Do you get an error? Does the cube appear to build but then you see no data? If so, do you still see data for the original cube? Are there "rejected records"? Did you re-build the dimension after adding the hierarchies? Can you see the new hierarchy and drill into it using AWM? (Right click on the hierarchy to view its data.)
Thanks David and sorry for the scant information. I started my cube from scratch and ensured that I had to underlying data issues (with a child bwlonging to more than 1 parent etc) and how I have successfully managed to build the cube and dimensions sucessfully, with 2 hierarchies.
One small question that I'm not sure there is any experience of. I have a PRODUCT dimension and have built 2 hierachies. I have browed them both successfully within AWM. However when I browse the cube in Excel using the SIMBA MDX driver, every time i drag the 2nd hierarchy onto one of the axes, Excel crashes.
Microsoft Excel as well as all of Simba’s MDX Providers support multiple hierarchies from the same dimension being used on one PivotTable. Oracle OLAP does not support using two different hierarchies from the same dimension in one pivot table. What you are looking to do will require setting up two distinct dimensions in your cube view.
However, having said that, Excel should display empty data, not cause Excel to crash. Please contact firstname.lastname@example.org, and let us know what version of the Simba MDX Provider for Oracle OLAP you are using, as well as what version of Oracle OLAP you are using, and we’ll see what’s going on.