Hi ,<br><br>  What I observed generally is it takes very longer when i try to do a crossjoin with more than 7 dimensions. I am trying to run the below query it runs for a very longer time <br><br>select {<br>CrossJoin([Service].Members,CrossJoin([Product].Members,CrossJoin([Month].Members,CrossJoin([TOD].Members,CrossJoin([IO].Members,[ForeignNetwork].Members)))))<br>

} on rows,<br>{[Measures].Members}<br>on columns<br>from [ServiceFactsByMonthWC]<br><br>Below is the tail of log file where mondrian is spending lot of time. What is it doing? Is there any way to optimize cross joins? . I am trying to use cross join as an option to prepopulate the Cube with a single MDX query, so that the subsequent executions will be faster, is there any better way to prepopulate the Cube, please let me know if there are any,<br>

<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000001101011110000<br>  Service (4): &quot;SERVICE_DIMENSION&quot;.&quot;SERVICE_NAME&quot;<br>

  Product (5): &quot;PRODUCT_DIMENSION&quot;.&quot;PRODUCT_NAME&quot;<br>  Year (6): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_YEAR&quot;<br>  Quarter (7): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_QUARTER&quot;<br>  Month (Key) (9): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_MONTH_NUMBER_IN_YEAR&quot;<br>

  IO (11): &quot;INCOMING_OUTGOING_DIMENSION&quot;.&quot;DIRECTION&quot;<br>  ForeignNetworkName (12): &quot;FOREIGN_NETWORK_DIMENSION&quot;.&quot;FND_NAME&quot;<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000011011110000<br>

  Service (4): &quot;SERVICE_DIMENSION&quot;.&quot;SERVICE_NAME&quot;<br>  Product (5): &quot;PRODUCT_DIMENSION&quot;.&quot;PRODUCT_NAME&quot;<br>  Year (6): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_YEAR&quot;<br>  Quarter (7): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_QUARTER&quot;<br>

  Month (Key) (9): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_MONTH_NUMBER_IN_YEAR&quot;<br>  TOD (10): &quot;TIME_OF_DAY_DIMENSION&quot;.&quot;TOD_NAME&quot;<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000001011011110000<br>

  Service (4): &quot;SERVICE_DIMENSION&quot;.&quot;SERVICE_NAME&quot;<br>  Product (5): &quot;PRODUCT_DIMENSION&quot;.&quot;PRODUCT_NAME&quot;<br>  Year (6): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_YEAR&quot;<br>  Quarter (7): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_QUARTER&quot;<br>

  Month (Key) (9): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_MONTH_NUMBER_IN_YEAR&quot;<br>  TOD (10): &quot;TIME_OF_DAY_DIMENSION&quot;.&quot;TOD_NAME&quot;<br>  ForeignNetworkName (12): &quot;FOREIGN_NETWORK_DIMENSION&quot;.&quot;FND_NAME&quot;<br>

<br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000111011110000<br>  Service (4): &quot;SERVICE_DIMENSION&quot;.&quot;SERVICE_NAME&quot;<br>

  Product (5): &quot;PRODUCT_DIMENSION&quot;.&quot;PRODUCT_NAME&quot;<br>  Year (6): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_YEAR&quot;<br>  Quarter (7): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_QUARTER&quot;<br>  Month (Key) (9): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_MONTH_NUMBER_IN_YEAR&quot;<br>

  TOD (10): &quot;TIME_OF_DAY_DIMENSION&quot;.&quot;TOD_NAME&quot;<br>  IO (11): &quot;INCOMING_OUTGOING_DIMENSION&quot;.&quot;DIRECTION&quot;<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000001111011110000<br>

  Service (4): &quot;SERVICE_DIMENSION&quot;.&quot;SERVICE_NAME&quot;<br>  Product (5): &quot;PRODUCT_DIMENSION&quot;.&quot;PRODUCT_NAME&quot;<br>  Year (6): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_YEAR&quot;<br>  Quarter (7): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_QUARTER&quot;<br>

  Month (Key) (9): &quot;MONTH_DIMENSION&quot;.&quot;CALENDER_MONTH_NUMBER_IN_YEAR&quot;<br>  TOD (10): &quot;TIME_OF_DAY_DIMENSION&quot;.&quot;TOD_NAME&quot;<br>  IO (11): &quot;INCOMING_OUTGOING_DIMENSION&quot;.&quot;DIRECTION&quot;<br>

  ForeignNetworkName (12): &quot;FOREIGN_NETWORK_DIMENSION&quot;.&quot;FND_NAME&quot;<br><br><br><br><br><br>