161:
including various schema rowset, properties, keywords, etc. Discover method allows users to specify both what needs to be discovered and the possible restrictions or properties. The result of
Discover method is a rowset.
903:
392:
94:
joined
Microsoft and Hyperion as founding member of XMLA Council. With time, more than 25 companies joined with their support for the standard.
898:
90:
endorsing XMLA. The 1.0 version of the standard was released in April 2001, and in
September 2001 the XMLA Council was formed. In April 2002
864:
770:
87:
824:
385:
893:
749:
450:
312:
175:
119:
35:
365:
475:
859:
775:
470:
435:
344:
728:
628:
649:
644:
602:
378:
294:
UseSession - to use existing session. SessionId attribute previously returned for BeginSession should be used.
718:
744:
541:
519:
123:
836:
703:
445:
708:
623:
491:
440:
659:
597:
514:
465:
571:
460:
654:
618:
557:
509:
83:
63:
330:
401:
887:
831:
576:
106:
methods: execute and discover. It was designed in such a way to preserve simplicity.
91:
67:
843:
780:
664:
174:
as the query language. In the XMLA 1.1 version, the only construct in MDXML is an
713:
455:
39:
819:
592:
316:
723:
566:
501:
157:
Discover method was designed to model all the discovery methods possible in
79:
59:
17:
561:
496:
430:
34:) is an industry standard for data access in analytical systems, such as
348:
186:
Below is an example of XMLA Execute request with MDX query in command.
536:
531:
526:
370:
158:
280:
103:
51:
47:
801:
685:
412:
374:
137:
list of command properties such as
Timeout, Catalog name, etc.
134:
127:
43:
42:. XMLA is based on other industry standards such as
852:
812:
763:
737:
696:
637:
611:
585:
550:
484:
423:
203:"urn:schemas-microsoft-com:xml-analysis"
178:statement enclosed in the <Statement> tag.
86:in April 2000. By January 2001 it was joined by
865:Data warehousing products and their producers
386:
78:The XMLA specification was first proposed by
8:
118:Command - command to be executed. It can be
809:
798:
693:
682:
420:
409:
393:
379:
371:
214:SELECTMeasures.MEMBERSONCOLUMNSFROMSales
70:being the XMLA Council founder members.
304:
141:The result of Execute command could be
278:. It is maintained through predefined
288:BeginSession - to begin a new session
7:
291:EndSession - to end existing session
114:Execute method has two parameters:
904:Application programming interfaces
750:MultiDimensional eXpressions (MDX)
25:
331:"XML for Analysis Specification"
313:"XML for Analysis gathers steam"
771:Business intelligence software
650:Extract, load, transform (ELT)
645:Extract, transform, load (ETL)
1:
719:Decision support system (DSS)
899:Online analytical processing
745:Data Mining Extensions (DMX)
36:online analytical processing
506:Ensemble modeling patterns
476:Single version of the truth
920:
860:Comparison of OLAP servers
102:XMLA consists of only two
808:
797:
729:Data warehouse automation
692:
681:
419:
414:Creating a data warehouse
408:
366:XMLA resources and links
188:
143:Multidimensional Dataset
54:. XMLA is maintained by
755:XML for Analysis (XMLA)
228:<DataSourceInfo/>
687:Using a data warehouse
542:Operational data store
264:</soap:Envelope>
704:Business intelligence
351:on September 7, 2008.
274:XMLA has a notion of
252:</PropertyList>
191:<soap:Envelope>
520:Focal point modeling
492:Column-oriented DBMS
441:Dimensional modeling
225:<PropertyList>
894:XML-based standards
825:Information factory
598:Early-arriving fact
515:Data vault modeling
466:Reverse star schema
255:</Properties>
249:</AxisFormat>
82:as a successor for
776:Reporting software
270:Session management
261:</soap:Body>
245:<AxisFormat>
222:<Properties>
216:</Statement>
881:
880:
877:
876:
873:
872:
793:
792:
789:
788:
677:
676:
673:
672:
572:Sixth normal form
212:<Statement>
194:<soap:Body>
16:(Redirected from
911:
810:
799:
694:
683:
461:Snowflake schema
421:
410:
395:
388:
381:
372:
353:
352:
347:. Archived from
341:
335:
334:
327:
321:
320:
319:on May 28, 2008.
315:. Archived from
309:
265:
262:
259:
258:</Execute>
256:
253:
250:
246:
243:
240:Multidimensional
239:
236:
235:</Catalog>
232:
229:
226:
223:
220:
219:</Command>
217:
213:
210:
207:
204:
201:
198:
195:
192:
28:XML for Analysis
21:
919:
918:
914:
913:
912:
910:
909:
908:
884:
883:
882:
869:
848:
804:
785:
759:
733:
688:
669:
633:
629:Slowly changing
619:Dimension table
607:
581:
558:Data dictionary
546:
510:Anchor modeling
480:
415:
404:
402:Data warehouses
399:
362:
357:
356:
343:
342:
338:
333:. 30 June 2006.
329:
328:
324:
311:
310:
306:
301:
272:
267:
266:
263:
260:
257:
254:
251:
248:
244:
242:</Format>
241:
237:
234:
231:<Catalog>
230:
227:
224:
221:
218:
215:
211:
209:<Command>
208:
205:
202:
199:
196:
193:
190:
184:
170:XMLA specifies
168:
155:
112:
100:
84:OLE DB for OLAP
76:
23:
22:
15:
12:
11:
5:
917:
915:
907:
906:
901:
896:
886:
885:
879:
878:
875:
874:
871:
870:
868:
867:
862:
856:
854:
850:
849:
847:
846:
841:
840:
839:
837:Enterprise bus
829:
828:
827:
816:
814:
806:
805:
802:
795:
794:
791:
790:
787:
786:
784:
783:
778:
773:
767:
765:
761:
760:
758:
757:
752:
747:
741:
739:
735:
734:
732:
731:
726:
721:
716:
711:
706:
700:
698:
690:
689:
686:
679:
678:
675:
674:
671:
670:
668:
667:
662:
657:
652:
647:
641:
639:
635:
634:
632:
631:
626:
621:
615:
613:
609:
608:
606:
605:
600:
595:
589:
587:
583:
582:
580:
579:
574:
569:
564:
554:
552:
548:
547:
545:
544:
539:
534:
529:
524:
523:
522:
517:
512:
504:
499:
494:
488:
486:
482:
481:
479:
478:
473:
468:
463:
458:
453:
448:
443:
438:
433:
427:
425:
417:
416:
413:
406:
405:
400:
398:
397:
390:
383:
375:
369:
368:
361:
360:External links
358:
355:
354:
336:
322:
303:
302:
300:
297:
296:
295:
292:
289:
271:
268:
238:<Format>
189:
183:
180:
167:
166:Query language
164:
154:
151:
147:Tabular Rowset
139:
138:
131:
111:
108:
99:
96:
75:
72:
24:
14:
13:
10:
9:
6:
4:
3:
2:
916:
905:
902:
900:
897:
895:
892:
891:
889:
866:
863:
861:
858:
857:
855:
851:
845:
842:
838:
835:
834:
833:
832:Ralph Kimball
830:
826:
823:
822:
821:
818:
817:
815:
811:
807:
800:
796:
782:
779:
777:
774:
772:
769:
768:
766:
762:
756:
753:
751:
748:
746:
743:
742:
740:
736:
730:
727:
725:
722:
720:
717:
715:
712:
710:
707:
705:
702:
701:
699:
695:
691:
684:
680:
666:
663:
661:
658:
656:
653:
651:
648:
646:
643:
642:
640:
636:
630:
627:
625:
622:
620:
617:
616:
614:
610:
604:
601:
599:
596:
594:
591:
590:
588:
584:
578:
577:Surrogate key
575:
573:
570:
568:
565:
563:
559:
556:
555:
553:
549:
543:
540:
538:
535:
533:
530:
528:
525:
521:
518:
516:
513:
511:
508:
507:
505:
503:
500:
498:
495:
493:
490:
489:
487:
483:
477:
474:
472:
469:
467:
464:
462:
459:
457:
454:
452:
449:
447:
444:
442:
439:
437:
434:
432:
429:
428:
426:
422:
418:
411:
407:
403:
396:
391:
389:
384:
382:
377:
376:
373:
367:
364:
363:
359:
350:
346:
345:"MDX / mdXML"
340:
337:
332:
326:
323:
318:
314:
308:
305:
298:
293:
290:
287:
286:
285:
284:
282:
277:
276:session state
269:
187:
181:
179:
177:
173:
165:
163:
160:
152:
150:
148:
144:
136:
133:Properties -
132:
129:
125:
121:
117:
116:
115:
109:
107:
105:
97:
95:
93:
89:
85:
81:
73:
71:
69:
68:SAS Institute
65:
61:
57:
53:
49:
45:
41:
37:
33:
29:
19:
844:Dan Linstedt
754:
349:the original
339:
325:
317:the original
307:
279:
275:
273:
185:
171:
169:
156:
146:
142:
140:
113:
101:
77:
56:XMLA Council
55:
31:
27:
26:
18:XMLA Council
781:Spreadsheet
714:Data mining
456:Star schema
247:TupleFormat
197:<Execute
40:data mining
38:(OLAP) and
888:Categories
820:Bill Inmon
624:Degenerate
593:Fact table
299:References
738:Languages
724:OLAP cube
709:Dashboard
660:Transform
612:Dimension
567:Data mart
502:Data mesh
471:Aggregate
436:Dimension
80:Microsoft
60:Microsoft
853:Products
697:Concepts
562:Metadata
551:Elements
497:Data hub
485:Variants
431:Database
424:Concepts
233:FoodMart
153:Discover
88:Hyperion
64:Hyperion
803:Related
655:Extract
638:Filling
603:Measure
283:headers
182:Example
110:Execute
74:History
813:People
200:xmlns=
764:Tools
537:ROLAP
532:MOLAP
527:HOLAP
172:MDXML
159:OLEDB
58:with
665:Load
586:Fact
451:OLAP
446:Fact
281:SOAP
206:>
104:SOAP
66:and
52:HTTP
50:and
48:SOAP
32:XMLA
176:MDX
145:or
135:XML
128:SQL
126:or
124:DMX
120:MDX
98:API
92:SAS
44:XML
890::
149:.
122:,
62:,
46:,
560:/
394:e
387:t
380:v
130:.
30:(
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.