SSAS: Data Cube

Designing OLAP Data Cubes OLAP Data cubes represent the primary logical object for providing critical, multidimensional analysis common to business intelligence which may be viewed using a variety of tools such as BIDS or Excel. Cubes contain data from two types of tables – a fact or “measure” table (typically one) and multiple dimension tables.…

SSAS: Data Warehouse

The Data Store for OLAP Analysis Before an organization may engage in OLAP analysis, leveraging cubes, the data must be denormalized from its primary operational OLTP system into a data warehouse, which consists of measures or “fact tables” for analysis, supporting by dimensions which provide context to the organization’s facts. Once analytical requirements have been…

SSAS: An Overview of OLAP

The Foundation of Business Intelligence (BI) Online Analytical Processing (OLAP) is the mechanism by which vast amounts of data is leveraged for strategic decision-making, allowing organizations desiring to achieve and maintain a competitive lead in their market. OLAP is chosen for its ability to deliver faster querying capability, from numerous types of data stores, utilizing…

Business Intelligence

Business Intelligence (BI) encompasses leveraging descriptive and inferential statistical analysis upon massive organizational data stores to enable strategic decision-making. SQL Server Analysis Services (SSAS) SQL Server Analysis Services (SSAS) is Microsoft’s solution to the organization’s needs for Online analytical processing (OLAP) which leverage a data warehouse to provide self-service business intelligence capabilities to end users. SQL…

SSAS: Refining a Dimension

Adding New Dimension Fields Often in the cycle of cube development it become necessary to add new fields to a dimension for future reporting purposes. In this article, I will demonstrate adding an aggregation of [City, State] to the data source view. First, I’ll open the AW data source view. Now I need to find…