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,
MB-techAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan McCauleyData and Analytics ManagerCommented:
Are you saying that a particular MDX query is slow when executed from Excel but runs more quickly when executed from SSMS? How large is the return dataset that's being displayed? I'd expect SSMS to be a bit faster for a very large dataset because it's not doing any of the fancy display that Excel is doing, but the query should execute exactly the same on the server regardless of what software is issuing it, so I wanted to clarify that.

That said, can we get an example of what's going on - can you provide the poorly-generated MDX as an example we can look at? What in particular is causing the cross-joins that's different from cases where the performance is better? Are you using an extremely large dataset that's particularly sparse?

http://sqlmag.com/data-access/cross-join-performance

Also, some users have run into difficulty on extremely large aggregated filters, and have better luck modifying the syntax slightly:

http://dba.stackexchange.com/questions/50149/mdx-crossjoin-filtering-on-different-hierarchies-from-the-same-dimension-is-very

If you can figure out exactly what about your MDX is causing the slow performance, then you can take the steps towards improving performing when displaying the particular sets of measures and dimensions that result in generating the poorly performing MDX.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MB-techAuthor 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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.