534:
675:
549:
708:
671:
545:
37:
553:
724:
657:
509:
573:
415:
469:
30:
704:
665:
541:
394:
95:
120:
504:
420:
115:
80:
649:
373:
273:
294:
289:
247:
363:
389:
186:
164:
481:
348:
90:
353:
268:
136:
85:
304:
242:
159:
110:
661:
216:
399:
105:
577:
299:
263:
202:
154:
46:
718:
587:
476:
221:
488:
425:
309:
358:
100:
464:
237:
368:
211:
146:
528:
206:
141:
75:
615:
will show the template collapsed, i.e. hidden apart from its title bar.
580:), it is hidden apart from its title bar; if not, it is fully visible.
572:, meaning that if there is another collapsible item on the page (a
181:
176:
171:
15:
446:
330:
57:
19:
696:
688:
684:
639:
will show the template expanded, i.e. fully visible.
618:
594:
497:
457:
408:
382:
341:
282:
256:
230:
195:
129:
68:
681:Editors can experiment in this template's sandbox
583:To change this template's initial visibility, the
510:Data warehousing products and their producers
31:
8:
454:
443:
338:
327:
65:
54:
38:
24:
16:
567:initial visibility currently defaults to
584:
7:
578:table with the collapsible attribute
395:MultiDimensional eXpressions (MDX)
14:
532:
416:Business intelligence software
295:Extract, load, transform (ELT)
290:Extract, transform, load (ETL)
1:
364:Decision support system (DSS)
725:Computing navigational boxes
666:Template:Data warehouses/doc
390:Data Mining Extensions (DMX)
151:Ensemble modeling patterns
121:Single version of the truth
741:
655:
505:Comparison of OLAP servers
709:Subpages of this template
650:Category:Data warehousing
453:
442:
374:Data warehouse automation
337:
326:
64:
59:Creating a data warehouse
53:
400:XML for Analysis (XMLA)
703:Add categories to the
537:Template documentation
332:Using a data warehouse
187:Operational data store
349:Business intelligence
165:Focal point modeling
137:Column-oriented DBMS
86:Dimensional modeling
470:Information factory
243:Early-arriving fact
160:Data vault modeling
111:Reverse star schema
421:Reporting software
526:
525:
522:
521:
518:
517:
438:
437:
434:
433:
322:
321:
318:
317:
217:Sixth normal form
732:
700:
692:
679:
638:
637:
633:
630:
627:
624:
621:
614:
613:
609:
606:
603:
600:
597:
586:
585:|state=
570:
565:This template's
557:
538:
536:
535:
455:
444:
339:
328:
106:Snowflake schema
66:
55:
40:
33:
26:
17:
740:
739:
735:
734:
733:
731:
730:
729:
715:
714:
713:
712:
702:
694:
682:
680:
669:
654:
646:
635:
631:
628:
625:
623:Data warehouses
622:
619:
611:
607:
604:
601:
599:Data warehouses
598:
595:
574:navbox, sidebar
568:
563:
558:
539:
533:
531:
527:
514:
493:
449:
430:
404:
378:
333:
314:
278:
274:Slowly changing
264:Dimension table
252:
226:
203:Data dictionary
191:
155:Anchor modeling
125:
60:
49:
47:Data warehouses
44:
12:
11:
5:
738:
736:
728:
727:
717:
716:
693:and testcases
653:
652:
645:
642:
641:
640:
616:
562:
559:
530:
529:
524:
523:
520:
519:
516:
515:
513:
512:
507:
501:
499:
495:
494:
492:
491:
486:
485:
484:
482:Enterprise bus
474:
473:
472:
461:
459:
451:
450:
447:
440:
439:
436:
435:
432:
431:
429:
428:
423:
418:
412:
410:
406:
405:
403:
402:
397:
392:
386:
384:
380:
379:
377:
376:
371:
366:
361:
356:
351:
345:
343:
335:
334:
331:
324:
323:
320:
319:
316:
315:
313:
312:
307:
302:
297:
292:
286:
284:
280:
279:
277:
276:
271:
266:
260:
258:
254:
253:
251:
250:
245:
240:
234:
232:
228:
227:
225:
224:
219:
214:
209:
199:
197:
193:
192:
190:
189:
184:
179:
174:
169:
168:
167:
162:
157:
149:
144:
139:
133:
131:
127:
126:
124:
123:
118:
113:
108:
103:
98:
93:
88:
83:
78:
72:
70:
62:
61:
58:
51:
50:
45:
43:
42:
35:
28:
20:
13:
10:
9:
6:
4:
3:
2:
737:
726:
723:
722:
720:
710:
706:
698:
690:
686:
677:
673:
667:
663:
659:
658:documentation
651:
648:
647:
643:
617:
593:
592:
591:
590:may be used:
589:
581:
579:
575:
571:
560:
555:
551:
547:
543:
511:
508:
506:
503:
502:
500:
496:
490:
487:
483:
480:
479:
478:
477:Ralph Kimball
475:
471:
468:
467:
466:
463:
462:
460:
456:
452:
445:
441:
427:
424:
422:
419:
417:
414:
413:
411:
407:
401:
398:
396:
393:
391:
388:
387:
385:
381:
375:
372:
370:
367:
365:
362:
360:
357:
355:
352:
350:
347:
346:
344:
340:
336:
329:
325:
311:
308:
306:
303:
301:
298:
296:
293:
291:
288:
287:
285:
281:
275:
272:
270:
267:
265:
262:
261:
259:
255:
249:
246:
244:
241:
239:
236:
235:
233:
229:
223:
222:Surrogate key
220:
218:
215:
213:
210:
208:
204:
201:
200:
198:
194:
188:
185:
183:
180:
178:
175:
173:
170:
166:
163:
161:
158:
156:
153:
152:
150:
148:
145:
143:
140:
138:
135:
134:
132:
128:
122:
119:
117:
114:
112:
109:
107:
104:
102:
99:
97:
94:
92:
89:
87:
84:
82:
79:
77:
74:
73:
71:
67:
63:
56:
52:
48:
41:
36:
34:
29:
27:
22:
21:
18:
582:
569:autocollapse
566:
564:
489:Dan Linstedt
23:
662:transcluded
552:] [
548:] [
544:] [
426:Spreadsheet
359:Data mining
101:Star schema
656:The above
465:Bill Inmon
269:Degenerate
238:Fact table
707:subpage.
610:collapsed
588:parameter
383:Languages
369:OLAP cube
354:Dashboard
305:Transform
257:Dimension
212:Data mart
147:Data mesh
116:Aggregate
81:Dimension
719:Category
644:See also
634:expanded
498:Products
342:Concepts
207:Metadata
196:Elements
142:Data hub
130:Variants
76:Database
69:Concepts
687:|
676:history
674:|
550:history
448:Related
300:Extract
283:Filling
248:Measure
701:pages.
697:create
689:mirror
685:create
458:People
664:from
629:state
605:state
576:, or
561:Usage
556:]
554:purge
540:[
409:Tools
182:ROLAP
177:MOLAP
172:HOLAP
705:/doc
672:edit
546:edit
542:view
310:Load
231:Fact
96:OLAP
91:Fact
660:is
721::
668:.
636:}}
620:{{
612:}}
596:{{
711:.
699:)
695:(
691:)
683:(
678:)
670:(
632:=
626:|
608:=
602:|
205:/
39:e
32:t
25:v
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.