[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ssas in excel poor performance but better when executed via SSMS

Posted on 2014-08-10
2
Medium Priority
?
416 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,
0
Comment
Question by:MB-tech
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 40271730
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
 

Author Comment

by:MB-tech
ID: 40307925
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question