Archives for: August 2006, 16

Multidimensional Cube - Simple Explanation for Users

08/16/06 | by Clarise Z. Doval Santos [mail] | Categories: Business Analytics, Computers and Internet, Business Intelligence

The concept of multidimensional cube is a good way to help users understand how they may want to query the multidimensional database or create OLAP reports. The dimensions of a cube are stored in a database table.

The data cube in the diagram below is composed of there dimensions: Customer, Product and Time.

Data Cube

This cube would allow query BY customer, BY time and BY product. Hence, sample query could be selecting a customer BY time and BY Product.

Additional dimensions (e.g. sales territory, sales person, etc) increase the size of the cube geometrically.

Permalink
August 2006
Mon Tue Wed Thu Fri Sat Sun
 << < Current> >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      

This blog contains thoughts that range from non-technical to technical. Its name is derived from "Yakity Blah Blah" a column I once had that discussed a cornucopia of ideas. Who am I? I'm Clarise Z. Doval Santos, providing Project Management and Technical Leadership as part of InterActive Systems & Consulting, Inc.

InterActive Systems & Consulting, Inc. (IASC) performs research in the areas of data analytics, collaboration and remote access.

InterASC Professional Services, a service mark of IASC, provides strategic consulting and project management for data warehousing, business intelligence and collaboration projects using proprietary and open source solutions. We formulate vendor-independent strategies and implement solutions for information management in an increasingly complex and distributed business environment, allowing secure data analysis and collaboration that provides enterprise information in the most valuable form to the right person, whenever and wherever needed.

TeleInterActive Networks, a service mark of IASC, hosts open source applications for small and medium enterprises including CMS, blogs, wikis, database applications, portals and mobile access. We provide the tools for SME to put their customer at the center of their business, and leverage information management in a way previously reserved for larger organizations.

37.652951177164 -122.490877706959

Search

XML Feeds

Blogroll

  • Business Life
Powered by b2evolution