We help IT Professionals succeed at work.

ssas in excel poor performance but better when executed via SSMS

MB-tech
MB-tech asked
on
723 Views
Last Modified: 2016-02-18
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,
Comment
Watch Question

Senior Data Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.