SSAS Cube processing options. 1. Process Default. Performs the minimum number of tasks required to fully initialize the object. The server converts this option to one of the other options based on the object state. 2. Process full Drops the object stores and rebuilds the object. Metadata changes, such as adding a new attributes to […]
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 […]