Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2014
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <Schema name="Sakila">
  2. <Cube name="Rentals">
  3. <Table name="rental"/>
  4. <Dimension name="Store" foreignKey="inventory_id" highCardinality="false">
  5. <Hierarchy name="" hasAll="true" primaryKey="inventory_id" primaryKeyTable="inventory">
  6. <Join leftTable="store" leftKey="store_id" rightTable="inventory" rightKey="store_id">
  7. <Table name="store" alias="store"/>
  8. <Table name="inventory" alias="inventory"/>
  9. </Join>
  10. <Level name="Store" table="store" column="store_id" uniqueMembers="false"/>
  11. </Hierarchy>
  12. </Dimension>
  13. <Measure name="Rentals" aggregator="count" column="rental_id"/>
  14. </Cube>
  15. </Schema>
  16.  
  17. select Hierarchize({[Store].[Store].Members}) ON COLUMNS
  18. from [Rentals]
  19.  
  20. 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