Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Schema name="Sakila">
- <Cube name="Rentals">
- <Table name="rental"/>
- <Dimension name="Store" foreignKey="inventory_id" highCardinality="false">
- <Hierarchy name="" hasAll="true" primaryKey="inventory_id" primaryKeyTable="inventory">
- <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"/>
- </Hierarchy>
- </Dimension>
- <Measure name="Rentals" aggregator="count" column="rental_id"/>
- </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`]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement