Drill Across and Visualization of Cubes with Non-conformed Dimensions

Riazati, D., Thom, J.A. and Zhang, X.

Data analysts would benefit greatly from the ability to navigate and view combined multidimensional data from multiple sources, a key requirement of which is the conformity between their dimensions. The strict requirements of conformity restrict navigating to related multidimensional data from unseen or unfamiliar sources. In this paper we make a distinction between conformed dimension tables and conformed dimension attributes and discuss the merits of relaxing the conformity requirement. We propose extending the navigation operation drill across to include the non-conformed dimensions and introduce Nested Pivot Tables as an extension to Pivot Tables to show how sources that have conformed as well as non-conformed dimensions can be viewed and analyzed together.

Cite as: Riazati, D., Thom, J.A. and Zhang, X. (2008). Drill Across and Visualization of Cubes with Non-conformed Dimensions. In Proc. Nineteenth Australasian Database Conference (ADC 2008), Wollongong, NSW, Australia. CRPIT, 75. Fekete, A. and Lin, X., Eds. ACS. 85-93.

(from crpit.com) (local if available)