Our plan is for this to be the first of a series of articles about accessing a tabular database deployed to an SSAS instance. You’ll learn about the components that make up a tabular database and the methods available to connect to the database to retrieve its data. We’ll introduce you to the tabular model through the eyes of SQL Server Management Studio (SSMS). What has not garnered nearly as much attention is what to do with a tabular database once it’s been deployed. Since the release of SQL Server 2012, much has been written about how to use SQL Server Data Tools (SSDT) to create a tabular model and deploy it to an instance of SSAS in tabular mode. Together these elements create a database that is fast and efficient and can deliver self-service business intelligence (BI) to a variety of applications, including Excel, PowerPivot, Power View and SQL Server Reporting Services (SSRS). Like a cube, the model also supports measures and key performance indicators (KPIs). Like a database, the tabular model supports tables and their relationships. You can think of the tabular model as a cross between a SQL Server relational database and an SSAS multidimensional cube. When Microsoft released SQL Server 2012, they introduced the SQL Server Analysis Services (SSAS) tabular model, an in-memory database that uses the xVelocity analytics engine and state-of-the-art compression algorithms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |