search

pentaho / mondrian

Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.
http://mondrian.pentaho.com/
Other
1.14k stars 724 forks source link

Shared Dimension cannot be used more than once in the same cube #301

Open wqsahmed opened 10 years ago

wqsahmed commented 10 years ago

In Mondrian 4.0, while trying to create and use more than one dimensions in a which have the same shared dimension as source, Mondrian throws an exception. For example, if there is a shared "Time" dimension and two dimensions Order date and Due date are created as:

Then the following exception is thrown : mondrian.olap.MondrianException: Mondrian Error:Internal error: Could not find path to time [....] Caused by: mondrian.rolap.RolapSchema$PhysSchemaException: Could not find a path from time as time_1 to any of [time]

berkinthomas commented 9 years ago

you have to create two separate dimension for due date and order date.