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): "SERVICE_DIMENSION"."SERVICE_NAME"<br>
Product (5): "PRODUCT_DIMENSION"."PRODUCT_NAME"<br> Year (6): "MONTH_DIMENSION"."CALENDER_YEAR"<br> Quarter (7): "MONTH_DIMENSION"."CALENDER_QUARTER"<br> Month (Key) (9): "MONTH_DIMENSION"."CALENDER_MONTH_NUMBER_IN_YEAR"<br>
IO (11): "INCOMING_OUTGOING_DIMENSION"."DIRECTION"<br> ForeignNetworkName (12): "FOREIGN_NETWORK_DIMENSION"."FND_NAME"<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000011011110000<br>
Service (4): "SERVICE_DIMENSION"."SERVICE_NAME"<br> Product (5): "PRODUCT_DIMENSION"."PRODUCT_NAME"<br> Year (6): "MONTH_DIMENSION"."CALENDER_YEAR"<br> Quarter (7): "MONTH_DIMENSION"."CALENDER_QUARTER"<br>
Month (Key) (9): "MONTH_DIMENSION"."CALENDER_MONTH_NUMBER_IN_YEAR"<br> TOD (10): "TIME_OF_DAY_DIMENSION"."TOD_NAME"<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000001011011110000<br>
Service (4): "SERVICE_DIMENSION"."SERVICE_NAME"<br> Product (5): "PRODUCT_DIMENSION"."PRODUCT_NAME"<br> Year (6): "MONTH_DIMENSION"."CALENDER_YEAR"<br> Quarter (7): "MONTH_DIMENSION"."CALENDER_QUARTER"<br>
Month (Key) (9): "MONTH_DIMENSION"."CALENDER_MONTH_NUMBER_IN_YEAR"<br> TOD (10): "TIME_OF_DAY_DIMENSION"."TOD_NAME"<br> ForeignNetworkName (12): "FOREIGN_NETWORK_DIMENSION"."FND_NAME"<br>
<br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000111011110000<br> Service (4): "SERVICE_DIMENSION"."SERVICE_NAME"<br>
Product (5): "PRODUCT_DIMENSION"."PRODUCT_NAME"<br> Year (6): "MONTH_DIMENSION"."CALENDER_YEAR"<br> Quarter (7): "MONTH_DIMENSION"."CALENDER_QUARTER"<br> Month (Key) (9): "MONTH_DIMENSION"."CALENDER_MONTH_NUMBER_IN_YEAR"<br>
TOD (10): "TIME_OF_DAY_DIMENSION"."TOD_NAME"<br> IO (11): "INCOMING_OUTGOING_DIMENSION"."DIRECTION"<br><br>DEBUG http-8080-4 mondrian.rolap.FastBatchingCellReader - FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000001111011110000<br>
Service (4): "SERVICE_DIMENSION"."SERVICE_NAME"<br> Product (5): "PRODUCT_DIMENSION"."PRODUCT_NAME"<br> Year (6): "MONTH_DIMENSION"."CALENDER_YEAR"<br> Quarter (7): "MONTH_DIMENSION"."CALENDER_QUARTER"<br>
Month (Key) (9): "MONTH_DIMENSION"."CALENDER_MONTH_NUMBER_IN_YEAR"<br> TOD (10): "TIME_OF_DAY_DIMENSION"."TOD_NAME"<br> IO (11): "INCOMING_OUTGOING_DIMENSION"."DIRECTION"<br>
ForeignNetworkName (12): "FOREIGN_NETWORK_DIMENSION"."FND_NAME"<br><br><br><br><br><br>