what is OLAP Cube Design ?
OLAP databases provide aggregated summary information quickly using a schema that is easily understood by end users. In the OLAP design it is not required to join tables together the way it is done in relational database. It contains all the relationships required to enable a specific sets of queries for a database. At the center there’s an object called Cube, which may contain many Cubes. Usually a small DW(Data warehouse) project consist of only one such Cube. You can use a client browsing tools such as Microsoft Excel or a 3rd party application to attach to the data cube. After you attach the client browser, you can drag and drop the cube elements onto a design surface or pivot table to formulate questions and retrieve answers quickly. The cube pre-aggregates information, and is optimized to answer questions like “What is the total number of bugs on each day that meet a set of criteria?” The cube consists of two primary concepts: measures and dimensions. The measures are the (usuall
