SSRS [General] Questions: Notes: What is SSRS? SSRS stands for SQL Server Report Services. It is the component of Microsoft SQL Server 2008 that provides an enterprise-ready and extensible presentation layer for the Microsoft business intelligence platform to develop, manage and deliver reports. What are the stages of the Report Life Cycle? The stages […]
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 […]