<Schema name="Sakila">
  <Cube name="Rentals">
    <Annotations>
      <Annotation name="phase.Table.rental.x">294</Annotation>
      <Annotation name="phase.Table.rental.y">88</Annotation>
    </Annotations>
    <Table name="rental"/>
    <Dimension name="Store" foreignKey="inventory_id" highCardinality="false">
      <Annotations>
        <Annotation name="phase.x">58</Annotation>
        <Annotation name="phase.y">53</Annotation>
      </Annotations>
      <Hierarchy name="" hasAll="true" primaryKey="inventory_id" primaryKeyTable="inventory">
        <Annotations>
          <Annotation name="phase.Table.inventory.x">145</Annotation>
          <Annotation name="phase.Table.inventory.y">70</Annotation>
          <Annotation name="phase.Table.store.x">505</Annotation>
          <Annotation name="phase.Table.store.y">46</Annotation>
        </Annotations>
        <Join leftTable="store" leftKey="store_id" rightTable="inventory" rightKey="store_id">
          <Table name="store" alias="store"/>
          <Table name="inventory" alias="inventory"/>
        </Join>
        <Level name="Store" table="store" column="store_id" uniqueMembers="false">
          <Annotations>
            <Annotation name="phase.x">782</Annotation>
            <Annotation name="phase.y">20</Annotation>
          </Annotations>
        </Level>
      </Hierarchy>
    </Dimension>
    <Measure name="Rentals" aggregator="count" column="rental_id">
      <Annotations>
        <Annotation name="phase.x">523</Annotation>
        <Annotation name="phase.y">111</Annotation>
      </Annotations>
    </Measure>
  </Cube>
</Schema>

select Hierarchize({[Store].[Store].Members}) ON COLUMNS
from [Rentals]

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select `store`.`store_id` as `c0`, count(`rental`.`rental_id`) as `m0` from `store` as `store`, `rental` as `rental` where `rental`.`inventory_id` = `inventory`.`inventory_id` group by `store`.`store_id`]