Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords...
Tag: SSDT
Developing Report Models – (Part 1)
Developing Report Models – (Part 1) Author: Basit A. Farooq A report model is a metadata description of a data source. It contains a business model of a data, a physical model of the underlying database, and a mapping between the two. The business model, also known as a semantic model, describes the data by using familiar business names, usually...
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1)
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1) Author: Basit A. Farooq Introduction Your reporting solution design should match technologies provided by Microsoft SQL Server™ 2014 Reporting Services to the requirements and abilities of users, and the requirements of the business. The documents that make up your reporting specification should...