The cube metadata is always stored in the SSAS server, but as an administrator, you can control the storage locations of the cube data and any aggregations. MOLAP(Multidimensional OLAP)-Metadata, Aggregation and Data are stored in SSAS. Data is stored in a compressed format on the server. Storage size is 20-25% of the relational data. […]
Partitions -They can be done only for fact tables/measure groups. -A partition stores part of the data for a measure group. -Each partition can pull its data from the same table or from separate table as long as the structure matches. -Each partition can have its own aggregation and storage scheme. -Most commonly, you will […]
KPI’s are quantifiable measures that represent critical success factors, and analysts use them to measure company performance over time, against a predefined goal. For example, sales profit, Revenue Growth, and Growth in Customer base are good KPI Candidates. KPIs are typically used as part of a strategic performance measurement framework, commonly known as a business […]
These are notes l’m sharing for any one interested in SSAS 1. Attribute Hierarchy (All level and key level) 2. User Defined Hierarchy (Multiple Levels) By default SSAS will create a hierarchy called – attribute hierarchy (All level and key level) Natural hierarchies – If the parent level and child level in the hierarchy has […]