asked on

ssas in excel poor performance but better when executed via SSMS

HI,
i am trying to create a report in excel using SSAS cube as a source. when i use more than 4 dimension attributes the performance is very poor . Also i am placing attributes from one dimension side by side.
when i create a trace using sql profiler i see that MDX generated is having cross joins . how can i get rid of these cross joins or is there any alternative for this. please help.

Thanks,

ASKER CERTIFIED SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MB-tech

ASKER

Hi,
Thanks for your reply. Not all MDX queries generated by Excel are slow only some of them are. Number of rows generated by this particular MDX are 122244. Is there any way that we cam modify in Excel.The MDX is below.Thanks for your response again.

SELECT NON EMPTY CrossJoin(CrossJoin(CrossJoin(Hierarchize({DrilldownLevel({[Dim Address Book].[ADDRESS KEY].[All]},,,INCLUDE_CALC_MEMBERS)}), Hierarchize({DrilldownLevel({[Dim Address Book].[Destination Name].[All]},,,INCLUDE_CALC_MEMBERS)})), Hierarchize({DrilldownLevel({[Dim FactSales1].[INV_DATE].[All]},,,INCLUDE_CALC_MEMBERS)})), Hierarchize({DrilldownLevel({[Dim FactSales1].[Route Number].[All]},,,INCLUDE_CALC_MEMBERS)})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS FROM (SELECT ({[Dim FactSales1].[Route Number].&[982], [Dim FactSales1].[Route Number].&[968], [Dim FactSales1].[Route Number].&[934], [Dim FactSales1].[Route Number].&[864], [Dim FactSales1].[Route Number].&[863], [Dim FactSales1].[Route Number].&[861], [Dim FactSales1].[Route Number].&[860], [Dim FactSales1].[Route Number].&[855], [Dim FactSales1].[Route Number].&[853], [Dim FactSales1].[Route Number].&[846], [Dim FactSales1].[Route Number].&[845], [Dim FactSales1].[Route Number].&[844], [Dim FactSales1].[Route Number].&[842], [Dim FactSales1].[Route Number].&[834], [Dim FactSales1].[Route Number].&[832], [Dim FactSales1].[Route Number].&[826], [Dim FactSales1].[Route Number].&[825], [Dim FactSales1].[Route Number].&[823], [Dim FactSales1].[Route Number].&[821], [Dim FactSales1].[Route Number].&[798], [Dim FactSales1].[Route Number].&[776], [Dim FactSales1].[Route Number].&[775], [Dim FactSales1].[Route Number].&[774], [Dim FactSales1].[Route Number].&[773], [Dim FactSales1].[Route Number].&[772], [Dim FactSales1].[Route Number].&[771], [Dim FactSales1].[Route Number].&[770], [Dim FactSales1].[Route Number].&[757], [Dim FactSales1].[Route Number].&[751], [Dim FactSales1].[Route Number].&[750], [Dim FactSales1].[Route Number].&[744], [Dim FactSales1].[Route Number].&[735], [Dim FactSales1].[Route Number].&[732], [Dim FactSales1].[Route Number].&[722], [Dim FactSales1].[Route Number].&[711], [Dim FactSales1].[Route Number].&[710], [Dim FactSales1].[Route Number].&[709], [Dim FactSales1].[Route Number].&[708], [Dim FactSales1].[Route Number].&[707], [Dim FactSales1].[Route Number].&[706], [Dim FactSales1].[Route Number].&[705], [Dim FactSales1].[Route Number].&[704], [Dim FactSales1].[Route Number].&[703], [Dim FactSales1].[Route Number].&[702], [Dim FactSales1].[Route Number].&[701], [Dim FactSales1].[Route Number].&[700], [Dim FactSales1].[Route Number].&[698], [Dim FactSales1].[Route Number].&[697], [Dim FactSales1].[Route Number].&[696], [Dim FactSales1].[Route Number].&[695], [Dim FactSales1].[Route Number].&[694], [Dim FactSales1].[Route Number].&[692], [Dim FactSales1].[Route Number].&[690], [Dim FactSales1].[Route Number].&[689], [Dim FactSales1].[Route Number].&[688], [Dim FactSales1].[Route Number].&[687], [Dim FactSales1].[Route Number].&[684], [Dim FactSales1].[Route Number].&[683], [Dim FactSales1].[Route Number].&[681], [Dim FactSales1].[Route Number].&[680], [Dim FactSales1].[Route Number].&[674], [Dim FactSales1].[Route Number].&[673], [Dim FactSales1].[Route Number].&[672], [Dim FactSales1].[Route Number].&[671], [Dim FactSales1].[Route Number].&[670], [Dim FactSales1].[Route Number].&[669], [Dim FactSales1].[Route Number].&[668], [Dim FactSales1].[Route Number].&[667], [Dim FactSales1].[Route Number].&[666], [Dim FactSales1].[Route Number].&[665], [Dim FactSales1].[Route Number].&[664], [Dim FactSales1].[Route Number].&[661], [Dim FactSales1].[Route Number].&[660], [Dim FactSales1].[Route Number].&[658], [Dim FactSales1].[Route Number].&[656], [Dim FactSales1].[Route Number].&[655], [Dim FactSales1].[Route Number].&[654], [Dim FactSales1].[Route Number].&[653], [Dim FactSales1].[Route Number].&[652], [Dim FactSales1].[Route Number].&[651], [Dim FactSales1].[Route Number].&[650], [Dim FactSales1].[Route Number].&[648], [Dim FactSales1].[Route Number].&[646], [Dim FactSales1].[Route Number].&[645], [Dim FactSales1].[Route Number].&[644], [Dim FactSales1].[Route Number].&[642], [Dim FactSales1].[Route Number].&[640], [Dim FactSales1].[Route Number].&[639], [Dim FactSales1].[Route Number].&[635], [Dim FactSales1].[Route Number].&[634], [Dim FactSales1].[Route Number].&[633], [Dim FactSales1].[Route Number].&[632], [Dim FactSales1].[Route Number].&[631], [Dim FactSales1].[Route Number].&[630], [Dim FactSales1].[Route Number].&[629], [Dim FactSales1].[Route Number].&[628], [Dim FactSales1].[Route Number].&[627], [Dim FactSales1].[Route Number].&[626], [Dim FactSales1].[Route Number].&[625], [Dim FactSales1].[Route Number].&[624], [Dim FactSales1].[Route Number].&[623], [Dim FactSales1].[Route Number].&[622], [Dim FactSales1].[Route Number].&[621], [Dim FactSales1].[Route Number].&[620], [Dim FactSales1].[Route Number].&[619], [Dim FactSales1].[Route Number].&[618], [Dim FactSales1].[Route Number].&[617], [Dim FactSales1].[Route Number].&[616], [Dim FactSales1].[Route Number].&[615], [Dim FactSales1].[Route Number].&[614], [Dim FactSales1].[Route Number].&[613], [Dim FactSales1].[Route Number].&[612], [Dim FactSales1].[Route Number].&[611], [Dim FactSales1].[Route Number].&[610], [Dim FactSales1].[Route Number].&[609], [Dim FactSales1].[Route Number].&[608], [Dim FactSales1].[Route Number].&[607], [Dim FactSales1].[Route Number].&[606], [Dim FactSales1].[Route Number].&[605], [Dim FactSales1].[Route Number].&[604], [Dim FactSales1].[Route Number].&[603], [Dim FactSales1].[Route Number].&[602], [Dim FactSales1].[Route Number].&[601], [Dim FactSales1].[Route Number].&[600], [Dim FactSales1].[Route Number].&[598], [Dim FactSales1].[Route Number].&[597], [Dim FactSales1].[Route Number].&[596], [Dim FactSales1].[Route Number].&[593], [Dim FactSales1].[Route Number].&[592], [Dim FactSales1].[Route Number].&[591], [Dim FactSales1].[Route Number].&[590], [Dim FactSales1].[Route Number].&[588], [Dim FactSales1].[Route Number].&[587], [Dim FactSales1].[Route Number].&[586], [Dim FactSales1].[Route Number].&[585], [Dim FactSales1].[Route Number].&[584], [Dim FactSales1].[Route Number].&[583], [Dim FactSales1].[Route Number].&[582], [Dim FactSales1].[Route Number].&[581], [Dim FactSales1].[Route Number].&[580], [Dim FactSales1].[Route Number].&[579], [Dim FactSales1].[Route Number].&[578], [Dim FactSales1].[Route Number].&[576], [Dim FactSales1].[Route Number].&[574], [Dim FactSales1].[Route Number].&[572], [Dim FactSales1].[Route Number].&[571], [Dim FactSales1].[Route Number].&[570], [Dim FactSales1].[Route Number].&[569], [Dim FactSales1].[Route Number].&[568], [Dim FactSales1].[Route Number].&[566], [Dim FactSales1].[Route Number].&[565], [Dim FactSales1].[Route Number].&[564], [Dim FactSales1].[Route Number].&[563], [Dim FactSales1].[Route Number].&[562], [Dim FactSales1].[Route Number].&[561], [Dim FactSales1].[Route Number].&[560], [Dim FactSales1].[Route Number].&[559], [Dim FactSales1].[Route Number].&[558], [Dim FactSales1].[Route Number].&[557], [Dim FactSales1].[Route Number].&[556], [Dim FactSales1].[Route Number].&[555], [Dim FactSales1].[Route Number].&[554], [Dim FactSales1].[Route Number].&[553], [Dim FactSales1].[Route Number].&[552], [Dim FactSales1].[Route Number].&[551], [Dim FactSales1].[Route Number].&[550], [Dim FactSales1].[Route Number].&[549], [Dim FactSales1].[Route Number].&[548], [Dim FactSales1].[Route Number].&[547], [Dim FactSales1].[Route Number].&[546], [Dim FactSales1].[Route Number].&[545], [Dim FactSales1].[Route Number].&[544], [Dim FactSales1].[Route Number].&[543], [Dim FactSales1].[Route Number].&[542], [Dim FactSales1].[Route Number].&[541], [Dim FactSales1].[Route Number].&[540], [Dim FactSales1].[Route Number].&[539], [Dim FactSales1].[Route Number].&[538], [Dim FactSales1].[Route Number].&[537], [Dim FactSales1].[Route Number].&[536], [Dim FactSales1].[Route Number].&[535], [Dim FactSales1].[Route Number].&[534], [Dim FactSales1].[Route Number].&[533], [Dim FactSales1].[Route Number].&[532], [Dim FactSales1].[Route Number].&[531], [Dim FactSales1].[Route Number].&[530], [Dim FactSales1].[Route Number].&[529], [Dim FactSales1].[Route Number].&[528], [Dim FactSales1].[Route Number].&[527], [Dim FactSales1].[Route Number].&[526], [Dim FactSales1].[Route Number].&[525], [Dim FactSales1].[Route Number].&[524], [Dim FactSales1].[Route Number].&[523], [Dim FactSales1].[Route Number].&[522], [Dim FactSales1].[Route Number].&[521], [Dim FactSales1].[Route Number].&[520], [Dim FactSales1].[Route Number].&[519], [Dim FactSales1].[Route Number].&[518], [Dim FactSales1].[Route Number].&[517], [Dim FactSales1].[Route Number].&[516], [Dim FactSales1].[Route Number].&[515], [Dim FactSales1].[Route Number].&[514], [Dim FactSales1].[Route Number].&[513], [Dim FactSales1].[Route Number].&[512], [Dim FactSales1].[Route Number].&[511], [Dim FactSales1].[Route Number].&[510], [Dim FactSales1].[Route Number].&[509], [Dim FactSales1].[Route Number].&[508], [Dim FactSales1].[Route Number].&[507], [Dim FactSales1].[Route Number].&[506], [Dim FactSales1].[Route Number].&[505], [Dim FactSales1].[Route Number].&[504], [Dim FactSales1].[Route Number].&[503], [Dim FactSales1].[Route Number].&[502], [Dim FactSales1].[Route Number].&[501], [Dim FactSales1].[Route Number].&[500], [Dim FactSales1].[Route Number].&[498], [Dim FactSales1].[Route Number].&[497], [Dim FactSales1].[Route Number].&[496], [Dim FactSales1].[Route Number].&[495], [Dim FactSales1].[Route Number].&[494], [Dim FactSales1].[Route Number].&[493], [Dim FactSales1].[Route Number].&[492], [Dim FactSales1].[Route Number].&[491], [Dim FactSales1].[Route Number].&[490], [Dim FactSales1].[Route Number].&[489], [Dim FactSales1].[Route Number].&[488], [Dim FactSales1].[Route Number].&[486], [Dim FactSales1].[Route Number].&[485], [Dim FactSales1].[Route Number].&[484], [Dim FactSales1].[Route Number].&[483], [Dim FactSales1].[Route Number].&[482], [Dim FactSales1].[Route Number].&[481], [Dim FactSales1].[Route Number].&[480], [Dim FactSales1].[Route Number].&[479], [Dim FactSales1].[Route Number].&[478], [Dim FactSales1].[Route Number].&[477], [Dim FactSales1].[Route Number].&[476], [Dim FactSales1].[Route Number].&[475], [Dim FactSales1].[Route Number].&[474], [Dim FactSales1].[Route Number].&[473], [Dim FactSales1].[Route Number].&[472], [Dim FactSales1].[Route Number].&[471], [Dim FactSales1].[Route Number].&[470], [Dim FactSales1].[Route Number].&[469], [Dim FactSales1].[Route Number].&[468], [Dim FactSales1].[Route Number].&[466], [Dim FactSales1].[Route Number].&[465], [Dim FactSales1].[Route Number].&[464], [Dim FactSales1].[Route Number].&[463], [Dim FactSales1].[Route Number].&[462], [Dim FactSales1].[Route Number].&[461], [Dim FactSales1].[Route Number].&[460], [Dim FactSales1].[Route Number].&[459], [Dim FactSales1].[Route Number].&[458], [Dim FactSales1].[Route Number].&[457], [Dim FactSales1].[Route Number].&[456], [Dim FactSales1].[Route Number].&[455], [Dim FactSales1].[Route Number].&[454], [Dim FactSales1].[Route Number].&[453], [Dim FactSales1].[Route Number].&[452], [Dim FactSales1].[Route Number].&[451], [Dim FactSales1].[Route Number].&[450], [Dim FactSales1].[Route Number].&[447], [Dim FactSales1].[Route Number].&[446], [Dim FactSales1].[Route Number].&[445], [Dim FactSales1].[Route Number].&[444], [Dim FactSales1].[Route Number].&[443], [Dim FactSales1].[Route Number].&[442], [Dim FactSales1].[Route Number].&[441], [Dim FactSales1].[Route Number].&[440], [Dim FactSales1].[Route Number].&[439], [Dim FactSales1].[Route Number].&[437], [Dim FactSales1].[Route Number].&[436], [Dim FactSales1].[Route Number].&[435], [Dim FactSales1].[Route Number].&[433], [Dim FactSales1].[Route Number].&[432], [Dim FactSales1].[Route Number].&[431], [Dim FactSales1].[Route Number].&[430], [Dim FactSales1].[Route Number].&[429], [Dim FactSales1].[Route Number].&[428], [Dim FactSales1].[Route Number].&[427], [Dim FactSales1].[Route Number].&[426], [Dim FactSales1].[Route Number].&[425], [Dim FactSales1].[Route Number].&[424], [Dim FactSales1].[Route Number].&[423], [Dim FactSales1].[Route Number].&[422], [Dim FactSales1].[Route Number].&[421], [Dim FactSales1].[Route Number].&[420], [Dim FactSales1].[Route Number].&[419], [Dim FactSales1].[Route Number].&[418], [Dim FactSales1].[Route Number].&[417], [Dim FactSales1].[Route Number].&[416], [Dim FactSales1].[Route Number].&[415], [Dim FactSales1].[Route Number].&[414], [Dim FactSales1].[Route Number].&[413], [Dim FactSales1].[Route Number].&[412], [Dim FactSales1].[Route Number].&[411], [Dim FactSales1].[Route Number].&[410], [Dim FactSales1].[Route Number].&[409], [Dim FactSales1].[Route Number].&[408], [Dim FactSales1].[Route Number].&[407], [Dim FactSales1].[Route Number].&[406], [Dim FactSales1].[Route Number].&[405], [Dim FactSales1].[Route Number].&[404], [Dim FactSales1].[Route Number].&[403], [Dim FactSales1].[Route Number].&[402], [Dim FactSales1].[Route Number].&[401], [Dim FactSales1].[Route Number].&[400], [Dim FactSales1].[Route Number].&[398], [Dim FactSales1].[Route Number].&[397], [Dim FactSales1].[Route Number].&[396], [Dim FactSales1].[Route Number].&[393], [Dim FactSales1].[Route Number].&[391], [Dim FactSales1].[Route Number].&[389], [Dim FactSales1].[Route Number].&[388], [Dim FactSales1].[Route Number].&[375], [Dim FactSales1].[Route Number].&[374], [Dim FactSales1].[Route Number].&[373], [Dim FactSales1].[Route Number].&[372], [Dim FactSales1].[Route Number].&[370], [Dim FactSales1].[Route Number].&[369], [Dim FactSales1].[Route Number].&[368], [Dim FactSales1].[Route Number].&[364], [Dim FactSales1].[Route Number].&[363], [Dim FactSales1].[Route Number].&[362], [Dim FactSales1].[Route Number].&[361], [Dim FactSales1].[Route Number].&[360], [Dim FactSales1].[Route Number].&[358], [Dim FactSales1].[Route Number].&[357], [Dim FactSales1].[Route Number].&[356], [Dim FactSales1].[Route Number].&[355], [Dim FactSales1].[Route Number].&[354], [Dim FactSales1].[Route Number].&[353], [Dim FactSales1].[Route Number].&[352], [Dim FactSales1].[Route Number].&[351], [Dim FactSales1].[Route Number].&[350], [Dim FactSales1].[Route Number].&[348], [Dim FactSales1].[Route Number].&[347], [Dim FactSales1].[Route Number].&[345], [Dim FactSales1].[Route Number].&[344], [Dim FactSales1].[Route Number].&[343], [Dim FactSales1].[Route Number].&[342], [Dim FactSales1].[Route Number].&[341], [Dim FactSales1].[Route Number].&[340], [Dim FactSales1].[Route Number].&[339], [Dim FactSales1].[Route Number].&[338], [Dim FactSales1].[Route Number].&[337], [Dim FactSales1].[Route Number].&[335], [Dim FactSales1].[Route Number].&[334], [Dim FactSales1].[Route Number].&[333], [Dim FactSales1].[Route Number].&[332], [Dim FactSales1].[Route Number].&[331], [Dim FactSales1].[Route Number].&[330], [Dim FactSales1].[Route Number].&[329], [Dim FactSales1].[Route Number].&[328], [Dim FactSales1].[Route Number].&[327], [Dim FactSales1].[Route Number].&[326], [Dim FactSales1].[Route Number].&[325], [Dim FactSales1].[Route Number].&[324], [Dim FactSales1].[Route Number].&[323], [Dim FactSales1].[Route Number].&[322], [Dim FactSales1].[Route Number].&[321], [Dim FactSales1].[Route Number].&[320], [Dim FactSales1].[Route Number].&[318], [Dim FactSales1].[Route Number].&[317], [Dim FactSales1].[Route Number].&[316], [Dim FactSales1].[Route Number].&[315], [Dim FactSales1].[Route Number].&[314], [Dim FactSales1].[Route Number].&[313], [Dim FactSales1].[Route Number].&[312], [Dim FactSales1].[Route Number].&[311], [Dim FactSales1].[Route Number].&[310], [Dim FactSales1].[Route Number].&[309], [Dim FactSales1].[Route Number].&[308], [Dim FactSales1].[Route Number].&[307], [Dim FactSales1].[Route Number].&[306], [Dim FactSales1].[Route Number].&[305], [Dim FactSales1].[Route Number].&[304], [Dim FactSales1].[Route Number].&[303], [Dim FactSales1].[Route Number].&[302], [Dim FactSales1].[Route Number].&[301], [Dim FactSales1].[Route Number].&[300], [Dim FactSales1].[Route Number].&[298], [Dim FactSales1].[Route Number].&[297], [Dim FactSales1].[Route Number].&[296], [Dim FactSales1].[Route Number].&[295], [Dim FactSales1].[Route Number].&[294], [Dim FactSales1].[Route Number].&[293], [Dim FactSales1].[Route Number].&[292], [Dim FactSales1].[Route Number].&[291], [Dim FactSales1].[Route Number].&[290], [Dim FactSales1].[Route Number].&[289], [Dim FactSales1].[Route Number].&[288], [Dim FactSales1].[Route Number].&[287], [Dim FactSales1].[Route Number].&[286], [Dim FactSales1].[Route Number].&[285], [Dim FactSales1].[Route Number].&[284], [Dim FactSales1].[Route Number].&[283], [Dim FactSales1].[Route Number].&[282], [Dim FactSales1].[Route Number].&[281], [Dim FactSales1].[Route Number].&[280], [Dim FactSales1].[Route Number].&[279], [Dim FactSales1].[Route Number].&[278], [Dim FactSales1].[Route Number].&[277], [Dim FactSales1].[Route Number].&[276], [Dim FactSales1].[Route Number].&[275], [Dim FactSales1].[Route Number].&[274], [Dim FactSales1].[Route Number].&[272], [Dim FactSales1].[Route Number].&[271], [Dim FactSales1].[Route Number].&[270], [Dim FactSales1].[Route Number].&[269], [Dim FactSales1].[Route Number].&[268], [Dim FactSales1].[Route Number].&[267], [Dim FactSales1].[Route Number].&[266], [Dim FactSales1].[Route Number].&[265], [Dim FactSales1].[Route Number].&[264], [Dim FactSales1].[Route Number].&[263], [Dim FactSales1].[Route Number].&[262], [Dim FactSales1].[Route Number].&[261], [Dim FactSales1].[Route Number].&[260], [Dim FactSales1].[Route Number].&[259], [Dim FactSales1].[Route Number].&[258], [Dim FactSales1].[Route Number].&[257], [Dim FactSales1].[Route Number].&[256], [Dim FactSales1].[Route Number].&[255], [Dim FactSales1].[Route Number].&[254], [Dim FactSales1].[Route Number].&[253], [Dim FactSales1].[Route Number].&[252], [Dim FactSales1].[Route Number].&[251], [Dim FactSales1].[Route Number].&[250], [Dim FactSales1].[Route Number].&[249], [Dim FactSales1].[Route Number].&[248], [Dim FactSales1].[Route Number].&[247], [Dim FactSales1].[Route Number].&[246], [Dim FactSales1].[Route Number].&[245], [Dim FactSales1].[Route Number].&[244], [Dim FactSales1].[Route Number].&[242], [Dim FactSales1].[Route Number].&[241], [Dim FactSales1].[Route Number].&[240], [Dim FactSales1].[Route Number].&[239], [Dim FactSales1].[Route Number].&[238], [Dim FactSales1].[Route Number].&[237], [Dim FactSales1].[Route Number].&[236], [Dim FactSales1].[Route Number].&[235], [Dim FactSales1].[Route Number].&[234], [Dim FactSales1].[Route Number].&[233], [Dim FactSales1].[Route Number].&[232], [Dim FactSales1].[Route Number].&[231], [Dim FactSales1].[Route Number].&[230], [Dim FactSales1].[Route Number].&[229], [Dim FactSales1].[Route Number].&[228], [Dim FactSales1].[Route Number].&[227], [Dim FactSales1].[Route Number].&[226], [Dim FactSales1].[Route Number].&[225], [Dim FactSales1].[Route Number].&[224], [Dim FactSales1].[Route Number].&[223], [Dim FactSales1].[Route Number].&[222], [Dim FactSales1].[Route Number].&[221], [Dim FactSales1].[Route Number].&[220], [Dim FactSales1].[Route Number].&[219], [Dim FactSales1].[Route Number].&[218], [Dim FactSales1].[Route Number].&[217], [Dim FactSales1].[Route Number].&[216], [Dim FactSales1].[Route Number].&[215], [Dim FactSales1].[Route Number].&[214], [Dim FactSales1].[Route Number].&[213], [Dim FactSales1].[Route Number].&[212], [Dim FactSales1].[Route Number].&[211], [Dim FactSales1].[Route Number].&[210], [Dim FactSales1].[Route Number].&[209], [Dim FactSales1].[Route Number].&[208], [Dim FactSales1].[Route Number].&[207], [Dim FactSales1].[Route Number].&[206], [Dim FactSales1].[Route Number].&[205], [Dim FactSales1].[Route Number].&[204], [Dim FactSales1].[Route Number].&[203], [Dim FactSales1].[Route Number].&[202], [Dim FactSales1].[Route Number].&[201], [Dim FactSales1].[Route Number].&[200], [Dim FactSales1].[Route Number].&[198], [Dim FactSales1].[Route Number].&[197], [Dim FactSales1].[Route Number].&[196], [Dim FactSales1].[Route Number].&[195], [Dim FactSales1].[Route Number].&[194], [Dim FactSales1].[Route Number].&[193], [Dim FactSales1].[Route Number].&[192], [Dim FactSales1].[Route Number].&[191], [Dim FactSales1].[Route Number].&[190], [Dim FactSales1].[Route Number].&[189], [Dim FactSales1].[Route Number].&[188], [Dim FactSales1].[Route Number].&[187], [Dim FactSales1].[Route Number].&[186], [Dim FactSales1].[Route Number].&[185], [Dim FactSales1].[Route Number].&[184], [Dim FactSales1].[Route Number].&[183], [Dim FactSales1].[Route Number].&[182], [Dim FactSales1].[Route Number].&[181], [Dim FactSales1].[Route Number].&[180], [Dim FactSales1].[Route Number].&[178], [Dim FactSales1].[Route Number].&[176], [Dim FactSales1].[Route Number].&[172], [Dim FactSales1].[Route Number].&[171], [Dim FactSales1].[Route Number].&[170], [Dim FactSales1].[Route Number].&[169], [Dim FactSales1].[Route Number].&[168], [Dim FactSales1].[Route Number].&[167], [Dim FactSales1].[Route Number].&[165], [Dim FactSales1].[Route Number].&[164], [Dim FactSales1].[Route Number].&[163], [Dim FactSales1].[Route Number].&[162], [Dim FactSales1].[Route Number].&[161], [Dim FactSales1].[Route Number].&[160], [Dim FactSales1].[Route Number].&[159], [Dim FactSales1].[Route Number].&[158], [Dim FactSales1].[Route Number].&[157], [Dim FactSales1].[Route Number].&[156], [Dim FactSales1].[Route Number].&[155], [Dim FactSales1].[Route Number].&[154], [Dim FactSales1].[Route Number].&[153], [Dim FactSales1].[Route Number].&[152], [Dim FactSales1].[Route Number].&[151], [Dim FactSales1].[Route Number].&[150], [Dim FactSales1].[Route Number].&[149], [Dim FactSales1].[Route Number].&[148], [Dim FactSales1].[Route Number].&[147], [Dim FactSales1].[Route Number].&[146], [Dim FactSales1].[Route Number].&[145], [Dim FactSales1].[Route Number].&[144], [Dim FactSales1].[Route Number].&[143], [Dim FactSales1].[Route Number].&[142], [Dim FactSales1].[Route Number].&[141], [Dim FactSales1].[Route Number].&[140], [Dim FactSales1].[Route Number].&[139], [Dim FactSales1].[Route Number].&[138], [Dim FactSales1].[Route Number].&[137], [Dim FactSales1].[Route Number].&[136], [Dim FactSales1].[Route Number].&[135], [Dim FactSales1].[Route Number].&[134], [Dim FactSales1].[Route Number].&[133], [Dim FactSales1].[Route Number].&[132], [Dim FactSales1].[Route Number].&[130], [Dim FactSales1].[Route Number].&[129], [Dim FactSales1].[Route Number].&[128], [Dim FactSales1].[Route Number].&[126], [Dim FactSales1].[Route Number].&[125], [Dim FactSales1].[Route Number].&[124], [Dim FactSales1].[Route Number].&[123], [Dim FactSales1].[Route Number].&[122], [Dim FactSales1].[Route Number].&[121], [Dim FactSales1].[Route Number].&[120], [Dim FactSales1].[Route Number].&[119], [Dim FactSales1].[Route Number].&[118], [Dim FactSales1].[Route Number].&[117], [Dim FactSales1].[Route Number].&[116], [Dim FactSales1].[Route Number].&[115], [Dim FactSales1].[Route Number].&[114], [Dim FactSales1].[Route Number].&[113], [Dim FactSales1].[Route Number].&[112], [Dim FactSales1].[Route Number].&[111], [Dim FactSales1].[Route Number].&[110], [Dim FactSales1].[Route Number].&[109], [Dim FactSales1].[Route Number].&[108], [Dim FactSales1].[Route Number].&[107], [Dim FactSales1].[Route Number].&[106], [Dim FactSales1].[Route Number].&[105], [Dim FactSales1].[Route Number].&[104], [Dim FactSales1].[Route Number].&[103], [Dim FactSales1].[Route Number].&[102], [Dim FactSales1].[Route Number].&[101], [Dim FactSales1].[Route Number].&[100], [Dim FactSales1].[Route Number].&[], [Dim FactSales1].[Route Number].&[127], [Dim FactSales1].[Route Number].&[131], [Dim FactSales1].[Route Number].&[166], [Dim FactSales1].[Route Number].&[173], [Dim FactSales1].[Route Number].&[174], [Dim FactSales1].[Route Number].&[175], [Dim FactSales1].[Route Number].&[177], [Dim FactSales1].[Route Number].&[179], [Dim FactSales1].[Route Number].&[1C0], [Dim FactSales1].[Route Number].&[1C1], [Dim FactSales1].[Route Number].&[1C2], [Dim FactSales1].[Route Number].&[1C3], [Dim FactSales1].[Route Number].&[1C4], [Dim FactSales1].[Route Number].&[1C5], [Dim FactSales1].[Route Number].&[1C6], [Dim FactSales1].[Route Number].&[1C7], [Dim FactSales1].[Route Number].&[273], [Dim FactSales1].[Route Number].&[2C0], [Dim FactSales1].[Route Number].&[2C1], [Dim FactSales1].[Route Number].&[2C2], [Dim FactSales1].[Route Number].&[2C3], [Dim FactSales1].[Route Number].&[2C4], [Dim FactSales1].[Route Number].&[2C5], [Dim FactSales1].[Route Number].&[2C6], [Dim FactSales1].[Route Number].&[319], [Dim FactSales1].[Route Number].&[349], [Dim FactSales1].[Route Number].&[359], [Dim FactSales1].[Route Number].&[365], [Dim FactSales1].[Route Number].&[366], [Dim FactSales1].[Route Number].&[367], [Dim FactSales1].[Route Number].&[371], [Dim FactSales1].[Route Number].&[376], [Dim FactSales1].[Route Number].&[377], [Dim FactSales1].[Route Number].&[378], [Dim FactSales1].[Route Number].&[379], [Dim FactSales1].[Route Number].&[380], [Dim FactSales1].[Route Number].&[381], [Dim FactSales1].[Route Number].&[382], [Dim FactSales1].[Route Number].&[383], [Dim FactSales1].[Route Number].&[384], [Dim FactSales1].[Route Number].&[385], [Dim FactSales1].[Route Number].&[386], [Dim FactSales1].[Route Number].&[387], [Dim FactSales1].[Route Number].&[390], [Dim FactSales1].[Route Number].&[392], [Dim FactSales1].[Route Number].&[394], [Dim FactSales1].[Route Number].&[395], [Dim FactSales1].[Route Number].&[3C0], [Dim FactSales1].[Route Number].&[3C1], [Dim FactSales1].[Route Number].&[3C2], [Dim FactSales1].[Route Number].&[3C3], [Dim FactSales1].[Route Number].&[3C4], [Dim FactSales1].[Route Number].&[3C5], [Dim FactSales1].[Route Number].&[3C6], [Dim FactSales1].[Route Number].&[434], [Dim FactSales1].[Route Number].&[438], [Dim FactSales1].[Route Number].&[448], [Dim FactSales1].[Route Number].&[449], [Dim FactSales1].[Route Number].&[467], [Dim FactSales1].[Route Number].&[487], [Dim FactSales1].[Route Number].&[4C0], [Dim FactSales1].[Route Number].&[4C1], [Dim FactSales1].[Route Number].&[4C2], [Dim FactSales1].[Route Number].&[4C3], [Dim FactSales1].[Route Number].&[4C4], [Dim FactSales1].[Route Number].&[4C5], [Dim FactSales1].[Route Number].&[4C6], [Dim FactSales1].[Route Number].&[573], [Dim FactSales1].[Route Number].&[575], [Dim FactSales1].[Route Number].&[589], [Dim FactSales1].[Route Number].&[594], [Dim FactSales1].[Route Number].&[595], [Dim FactSales1].[Route Number].&[5C0], [Dim FactSales1].[Route Number].&[5C1], [Dim FactSales1].[Route Number].&[5C2], [Dim FactSales1].[Route Number].&[5C3], [Dim FactSales1].[Route Number].&[5C4], [Dim FactSales1].[Route Number].&[5C5], [Dim FactSales1].[Route Number].&[5C6], [Dim FactSales1].[Route Number].&[657], [Dim FactSales1].[Route Number].&[659], [Dim FactSales1].[Route Number].&[662], [Dim FactSales1].[Route Number].&[663], [Dim FactSales1].[Route Number].&[675], [Dim FactSales1].[Route Number].&[682], [Dim FactSales1].[Route Number].&[685], [Dim FactSales1].[Route Number].&[686], [Dim FactSales1].[Route Number].&[691], [Dim FactSales1].[Route Number].&[693], [Dim FactSales1].[Route Number].&[6C0], [Dim FactSales1].[Route Number].&[6C1], [Dim FactSales1].[Route Number].&[6C2], [Dim FactSales1].[Route Number].&[712], [Dim FactSales1].[Route Number].&[713], [Dim FactSales1].[Route Number].&[714], [Dim FactSales1].[Route Number].&[715], [Dim FactSales1].[Route Number].&[716], [Dim FactSales1].[Route Number].&[717], [Dim FactSales1].[Route Number].&[718], [Dim FactSales1].[Route Number].&[719], [Dim FactSales1].[Route Number].&[720], [Dim FactSales1].[Route Number].&[721], [Dim FactSales1].[Route Number].&[723], [Dim FactSales1].[Route Number].&[724], [Dim FactSales1].[Route Number].&[725], [Dim FactSales1].[Route Number].&[726], [Dim FactSales1].[Route Number].&[727], [Dim FactSales1].[Route Number].&[728], [Dim FactSales1].[Route Number].&[729], [Dim FactSales1].[Route Number].&[730], [Dim FactSales1].[Route Number].&[731], [Dim FactSales1].[Route Number].&[733], [Dim FactSales1].[Route Number].&[734], [Dim FactSales1].[Route Number].&[736], [Dim FactSales1].[Route Number].&[737], [Dim FactSales1].[Route Number].&[738], [Dim FactSales1].[Route Number].&[739], [Dim FactSales1].[Route Number].&[742], [Dim FactSales1].[Route Number].&[743], [Dim FactSales1].[Route Number].&[745], [Dim FactSales1].[Route Number].&[746], [Dim FactSales1].[Route Number].&[747], [Dim FactSales1].[Route Number].&[748], [Dim FactSales1].[Route Number].&[752], [Dim FactSales1].[Route Number].&[753], [Dim FactSales1].[Route Number].&[754], [Dim FactSales1].[Route Number].&[755], [Dim FactSales1].[Route Number].&[756], [Dim FactSales1].[Route Number].&[758], [Dim FactSales1].[Route Number].&[759], [Dim FactSales1].[Route Number].&[760], [Dim FactSales1].[Route Number].&[761], [Dim FactSales1].[Route Number].&[762], [Dim FactSales1].[Route Number].&[763], [Dim FactSales1].[Route Number].&[764], [Dim FactSales1].[Route Number].&[765], [Dim FactSales1].[Route Number].&[766], [Dim FactSales1].[Route Number].&[767], [Dim FactSales1].[Route Number].&[780], [Dim FactSales1].[Route Number].&[786], [Dim FactSales1].[Route Number].&[789], [Dim FactSales1].[Route Number].&[790], [Dim FactSales1].[Route Number].&[794], [Dim FactSales1].[Route Number].&[795], [Dim FactSales1].[Route Number].&[796], [Dim FactSales1].[Route Number].&[7C0], [Dim FactSales1].[Route Number].&[7C1], [Dim FactSales1].[Route Number].&[800], [Dim FactSales1].[Route Number].&[801], [Dim FactSales1].[Route Number].&[802], [Dim FactSales1].[Route Number].&[803], [Dim FactSales1].[Route Number].&[804], [Dim FactSales1].[Route Number].&[805], [Dim FactSales1].[Route Number].&[806], [Dim FactSales1].[Route Number].&[807], [Dim FactSales1].[Route Number].&[808], [Dim FactSales1].[Route Number].&[809], [Dim FactSales1].[Route Number].&[810], [Dim FactSales1].[Route Number].&[811], [Dim FactSales1].[Route Number].&[812], [Dim FactSales1].[Route Number].&[813], [Dim FactSales1].[Route Number].&[814], [Dim FactSales1].[Route Number].&[815], [Dim FactSales1].[Route Number].&[816], [Dim FactSales1].[Route Number].&[817], [Dim FactSales1].[Route Number].&[818], [Dim FactSales1].[Route Number].&[819], [Dim FactSales1].[Route Number].&[820], [Dim FactSales1].[Route Number].&[822], [Dim FactSales1].[Route Number].&[824], [Dim FactSales1].[Route Number].&[827], [Dim FactSales1].[Route Number].&[828], [Dim FactSales1].[Route Number].&[829], [Dim FactSales1].[Route Number].&[830], [Dim FactSales1].[Route Number].&[831], [Dim FactSales1].[Route Number].&[833], [Dim FactSales1].[Route Number].&[835], [Dim FactSales1].[Route Number].&[840], [Dim FactSales1].[Route Number].&[841], [Dim FactSales1].[Route Number].&[843], [Dim FactSales1].[Route Number].&[847], [Dim FactSales1].[Route Number].&[851], [Dim FactSales1].[Route Number].&[852], [Dim FactSales1].[Route Number].&[854], [Dim FactSales1].[Route Number].&[856], [Dim FactSales1].[Route Number].&[862], [Dim FactSales1].[Route Number].&[865], [Dim FactSales1].[Route Number].&[880], [Dim FactSales1].[Route Number].&[889], [Dim FactSales1].[Route Number].&[891], [Dim FactSales1].[Route Number].&[897], [Dim FactSales1].[Route Number].&[898], [Dim FactSales1].[Route Number].&[900], [Dim FactSales1].[Route Number].&[901], [Dim FactSales1].[Route Number].&[917], [Dim FactSales1].[Route Number].&[921], [Dim FactSales1].[Route Number].&[922], [Dim FactSales1].[Route Number].&[923], [Dim FactSales1].[Route Number].&[931], [Dim FactSales1].[Route Number].&[932], [Dim FactSales1].[Route Number].&[936], [Dim FactSales1].[Route Number].&[941], [Dim FactSales1].[Route Number].&[942], [Dim FactSales1].[Route Number].&[946], [Dim FactSales1].[Route Number].&[951], [Dim FactSales1].[Route Number].&[961], [Dim FactSales1].[Route Number].&[981], [Dim FactSales1].[Route Number].&[985], [Dim FactSales1].[Route Number].&[986], [Dim FactSales1].[Route Number].&[988], [Dim FactSales1].[Route Number].&[989], [Dim FactSales1].[Route Number].&[990], [Dim FactSales1].[Route Number].&[991], [Dim FactSales1].[Route Number].&[992], [Dim FactSales1].[Route Number].&[993], [Dim FactSales1].[Route Number].&[994], [Dim FactSales1].[Route Number].&[995], [Dim FactSales1].[Route Number].&[996], [Dim FactSales1].[Route Number].&[997], [Dim FactSales1].[Route Number].&[998], [Dim FactSales1].[Route Number].&[9C0], [Dim FactSales1].[Route Number].&[9C1], [Dim FactSales1].[Route Number].&[9C2], [Dim FactSales1].[Route Number].&[9C4], [Dim FactSales1].[Route Number].&[AK1], [Dim FactSales1].[Route Number].&[DEL], [Dim FactSales1].[Route Number].&[EJ1], [Dim FactSales1].[Route Number].&[EJ2], [Dim FactSales1].[Route Number].&[EJ3], [Dim FactSales1].[Route Number].&[EJ4], [Dim FactSales1].[Route Number].&[EJ5], [Dim FactSales1].[Route Number].&[EJ6], [Dim FactSales1].[Route Number].&[EJ7], [Dim FactSales1].[Route Number].&[EJ8], [Dim FactSales1].[Route Number].&[EJ9], [Dim FactSales1].[Route Number].&[EN1], [Dim FactSales1].[Route Number].&[EN2], [Dim FactSales1].[Route Number].&[EN3], [Dim FactSales1].[Route Number].&[EN4], [Dim FactSales1].[Route Number].&[EN5], [Dim FactSales1].[Route Number].&[EN6], [Dim FactSales1].[Route Number].&[EN7], [Dim FactSales1].[Route Number].&[EN8], [Dim FactSales1].[Route Number].&[EN9], [Dim FactSales1].[Route Number].&[ES1], [Dim FactSales1].[Route Number].&[ES2], [Dim FactSales1].[Route Number].&[ES3], [Dim FactSales1].[Route Number].&[ES4], [Dim FactSales1].[Route Number].&[ES5], [Dim FactSales1].[Route Number].&[ET1], [Dim FactSales1].[Route Number].&[ET2], [Dim FactSales1].[Route Number].&[ET3], [Dim FactSales1].[Route Number].&[ET4], [Dim FactSales1].[Route Number].&[ET5], [Dim FactSales1].[Route Number].&[ET6], [Dim FactSales1].[Route Number].&[ET7], [Dim FactSales1].[Route Number].&[ET8], [Dim FactSales1].[Route Number].&[ET9], [Dim FactSales1].[Route Number].&[EX1], [Dim FactSales1].[Route Number].&[EX2], [Dim FactSales1].[Route Number].&[EX3], [Dim FactSales1].[Route Number].&[EX4], [Dim FactSales1].[Route Number].&[EX5], [Dim FactSales1].[Route Number].&[EX6], [Dim FactSales1].[Route Number].&[EX7], [Dim FactSales1].[Route Number].&[N01], [Dim FactSales1].[Route Number].&[N02], [Dim FactSales1].[Route Number].&[N03], [Dim FactSales1].[Route Number].&[N04], [Dim FactSales1].[Route Number].&[N05], [Dim FactSales1].[Route Number].&[N06], [Dim FactSales1].[Route Number].&[N07], [Dim FactSales1].[Route Number].&[N08], [Dim FactSales1].[Route Number].&[N09], [Dim FactSales1].[Route Number].&[N10], [Dim FactSales1].[Route Number].&[N11], [Dim FactSales1].[Route Number].&[N12], [Dim FactSales1].[Route Number].&[N13], [Dim FactSales1].[Route Number].&[N14], [Dim FactSales1].[Route Number].&[N15], [Dim FactSales1].[Route Number].&[N16], [Dim FactSales1].[Route Number].&[N17], [Dim FactSales1].[Route Number].&[N18], [Dim FactSales1].[Route Number].&[N19], [Dim FactSales1].[Route Number].&[N20], [Dim FactSales1].[Route Number].&[N21], [Dim FactSales1].[Route Number].&[N22], [Dim FactSales1].[Route Number].&[N25], [Dim FactSales1].[Route Number].&[N26], [Dim FactSales1].[Route Number].&[N27], [Dim FactSales1].[Route Number].&[N28], [Dim FactSales1].[Route Number].&[N29], [Dim FactSales1].[Route Number].&[N30], [Dim FactSales1].[Route Number].&[N31], [Dim FactSales1].[Route Number].&[N32], [Dim FactSales1].[Route Number].&[N35], [Dim FactSales1].[Route Number].&[N36], [Dim FactSales1].[Route Number].&[N37], [Dim FactSales1].[Route Number].&[N38], [Dim FactSales1].[Route Number].&[N39], [Dim FactSales1].[Route Number].&[N40], [Dim FactSales1].[Route Number].&[N41], [Dim FactSales1].[Route Number].&[N45], [Dim FactSales1].[Route Number].&[N46], [Dim FactSales1].[Route Number].&[N47], [Dim FactSales1].[Route Number].&[N48], [Dim FactSales1].[Route Number].&[N49], [Dim FactSales1].[Route Number].&[N50], [Dim FactSales1].[Route Number].&[N51], [Dim FactSales1].[Route Number].&[N52], [Dim FactSales1].[Route Number].&[N53], [Dim FactSales1].[Route Number].&[N55], [Dim FactSales1].[Route Number].&[N56], [Dim FactSales1].[Route Number].&[N57], [Dim FactSales1].[Route Number].&[N58], [Dim FactSales1].[Route Number].&[N59], [Dim FactSales1].[Route Number].&[N60], [Dim FactSales1].[Route Number].&[N61], [Dim FactSales1].[Route Number].&[N62], [Dim FactSales1].[Route Number].&[N63], [Dim FactSales1].[Route Number].&[N65], [Dim FactSales1].[Route Number].&[N66], [Dim FactSales1].[Route Number].&[N69], [Dim FactSales1].[Route Number].&[N70], [Dim FactSales1].[Route Number].&[N71], [Dim FactSales1].[Route Number].&[N73], [Dim FactSales1].[Route Number].&[N74], [Dim FactSales1].[Route Number].&[N78], [Dim FactSales1].[Route Number].&[N79], [Dim FactSales1].[Route Number].&[N80], [Dim FactSales1].[Route Number].&[N81], [Dim FactSales1].[Route Number].&[N82], [Dim FactSales1].[Route Number].&[N83], [Dim FactSales1].[Route Number].&[N84], [Dim FactSales1].[Route Number].&[N85], [Dim FactSales1].[Route Number].&[N86], [Dim FactSales1].[Route Number].&[N87], [Dim FactSales1].[Route Number].&[N88], [Dim FactSales1].[Route Number].&[N89], [Dim FactSales1].[Route Number].&[N90], [Dim FactSales1].[Route Number].&[N91], [Dim FactSales1].[Route Number].&[N92], [Dim FactSales1].[Route Number].&[N93], [Dim FactSales1].[Route Number].&[N94], [Dim FactSales1].[Route Number].&[N95], [Dim FactSales1].[Route Number].&[N96], [Dim FactSales1].[Route Number].&[N97], [Dim FactSales1].[Route Number].&[N98], [Dim FactSales1].[Route Number].&[N99], [Dim FactSales1].[Route Number].&[S01], [Dim FactSales1].[Route Number].&[S02], [Dim FactSales1].[Route Number].&[S03], [Dim FactSales1].[Route Number].&[S04], [Dim FactSales1].[Route Number].&[S05], [Dim FactSales1].[Route Number].&[S06], [Dim FactSales1].[Route Number].&[S07], [Dim FactSales1].[Route Number].&[S08], [Dim FactSales1].[Route Number].&[S09], [Dim FactSales1].[Route Number].&[S10], [Dim FactSales1].[Route Number].&[S11], [Dim FactSales1].[Route Number].&[S12], [Dim FactSales1].[Route Number].&[S13], [Dim FactSales1].[Route Number].&[S14], [Dim FactSales1].[Route Number].&[S15], [Dim FactSales1].[Route Number].&[S16], [Dim FactSales1].[Route Number].&[S18], [Dim FactSales1].[Route Number].&[TR1], [Dim FactSales1].[Route Number].&[X99], [Dim FactSales1].[Route Number].&[ZZZ], [Dim FactSales1].[Route Number].[All].UNKNOWNMEMBER}) ON COLUMNS FROM (SELECT ({[Dim Time].[Hierarchy].[YEARQTR].&[2013-Q3],[Dim Time].[Hierarchy].[YEARQTR].&[2013-Q4],[Dim Time].[Hierarchy].[YEARQTR].&[2014-Q1],[Dim Time].[Hierarchy].[YEARQTR].&[2014-Q2]}) ON COLUMNS FROM [DWHS SALES])) WHERE ([Dim Company].[Hierarchy].[Company].&[AUS],[Dim FactSales2].[Order Type].&[SO - SALES ORDER],[Measures].[Cartons Quantity Shipped]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS