We are currently experiencing an issue with JasperServer's OLAP Cube integration. We are using a Mondrian Cube schema and the file we use is accepted but only the first hierarchy within each of our dimensions is actually visible within the Ad Hoc Editor when opening the Cube. Is this as intended or are we missing something within our xml schema file? Also worth noting is that the multiple hierarchies per dimension come through fine using the Excel OLAP connector. We also noticed that the sample Foodmart schema shipped with Jaspersoft uses multiple hierarchies in the "Date" dimension, The second of the hierarchies is also ignored by Jaspersoft. Example xml is below. Any insight into this issue would be very much appreciated. Code:<Dimension description="Product details." name="Product"> <Hierarchy hasAll="true" name="Product Groups" primaryKey="D_PRODUCT_ID"> <Table name="d_product"/> <Level column="D_PRODUCT_GROUP_MAJOR_NAME" name="Product Group Major" type="String"/> <Level column="D_PRODUCT_GROUP_NAME" name="Product Group" type="String"/> </Hierarchy> <Hierarchy hasAll="true" name="Product Name" primaryKey="D_PRODUCT_ID"> <Table name="d_product"/> <Level column="D_PRODUCT_NAME" name="Product Name" type="String"/> </Hierarchy></Dimension>
