# SSAS: Tabular and Multidimensional Models **URL:** \ **Category:** How-to with CData\ **Tags:** article, ado.net, ssas, odbc-drivers\ **Created:** [September 22, 2023, 3:07pm UTC](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412 "2023-09-22T15:07:07Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![jerodj-cdata](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/jerodj-cdata/32/7_2.png) [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Post date:** [September 22, 2023, 3:07pm UTC](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412/1 "2023-09-22T15:07:37Z")
SQL Server Analysis Services (SSAS) allows you to build both tabular and multidimensional models. Tabular models support the relational model (model, tables, columns) of most data sources. Multidimensional models are Online Analytical Processing (OLAP) modeling constructs (cubes, dimensions, measures) built from relational data to provide deeper analytics and business intelligence. Both technologies have their benefits, and which one is right for you is dependent on your organization’s data and needs. If you’re looking for a solution that is easier to learn, fast performance with in-memory processing, and you have datasets that are not exceedingly large, tabular models make a lot of sense. If you have large datasets, need advanced analytics features or are working with legacy systems that already use multidimensional modes (see our [Office Depot Case Study](https://www.cdata.com/case-study/officedepot/)), then multidimensional models might be more appropriate. Thankfully, CData solutions allow you to build both tabular models (using our ODBC Drivers) and multidimensional models (using our [ADO.NET](http://ADO.NET) Providers) for any of the [250+ supported SaaS, Big Data, and NoSQL sources](https://www.cdata.com/drivers). Due to limitations in the SSAS  In this article, we briefly describe how to build either model using CData technologies. We use Snowflake as a data source, but the principals apply to any supported source. ## Building SSAS tabular models with CData ODBC Drivers  Building a SSAS tabular model from real-time data involves 5 basic steps: ### 1a. Connecting to data  First, you’ll need to configure your connection to the data source by configuring your ODBC DSN (data source name). This is the last step of the driver installation but can be completed later using the ODBC Data Source Administrator. ![8z8GWLKZmH4hG-J0h5-BjkZnYdjjNZ1DlEZJzkXJdRR1JwdFTw3fI_yW_CYAlfo9gDio9Zwnvxa2Bn_o8lYlRpGT36L4r1OFS8cTiZfDO3S4KJW4Q1GyeHAiAdVsbLfAHb-OBsgfQS5KbKahmly8FaU](https://us1.discourse-cdn.com/cdata/original/1X/2900ea83555bdce70f0f21c8fff9e9472ab03731.png) ### 1b. Create a new Analysis Services project  Once the DSN is configured, create a new Analysis Services Tabular Project in Visual Studio. ### 2. Creating a Data Source  In the project in Visual Studio, create a new Data Source in the Tabular Model Explorer, using the DSN you just configured as the data source. ![16XxAe4qu_IVvcXFxyJQRcCm_h76WZdWSk-qLTV6IanFGceEs3PAmBPpbwK5lVN70SectzxyUVeieyEDFOOcPn7CcM95dDDFl1votvTgrCo03nWr5EUGyyVqOXqSTOtKd9JV09meFGdnVEmm5st1Mm8](https://us1.discourse-cdn.com/cdata/original/1X/ad00d8dffe8ed6ca9e185a19f9c8660af6cd86f9.png) ### 3. Adding tables & relationships  After creating the data source, import the table(s) you wish to work with and define the foreign key relationships between the tables. ![ee0S2qozZ8HIqKX-mqQtMTBucR_CFX4h6u2PVMPSSvDZ7gUgcFZHXT83erfqhd7Wql2IWavL0xOWz7cyKvd0M2HckTfGjWiprAq3nKF2wF4YJX5ttm2FAQyX2bv4UC_bUiDapwGNHuxjqaWRT5n5xB4](https://us1.discourse-cdn.com/cdata/original/1X/c0d44c1c46592b27ed78c728993effa03fcf2993.png) ### 4. Creating measures  Once you import the tables and define the relationships, create your desired measures based on the columns in your tables. ![b18b33e3-8ef5-4ad1-aa8e-213bb9f33cd1.png](https://us1.discourse-cdn.com/cdata/original/1X/024c5a101b202e3f10558363109e093717c0d9ef.png) ### 5. Deploying the model  Last, configure your deployment server and deploy the model. Now you have a tabular model of your Snowflake data in your SSAS instance, ready to be analyzed, reported, and more. For a detailed guide, check out our in-depth [Knowledge base article](https://www.cdata.com/kb/tech/snowflake-odbc-ssas-tabular.rst). ## Building SSAS multidimensional models with CData [ADO.NET](http://ADO.NET) Providers  Building a SSAS multidimensional model from real-time data involves 4 basic steps: ### 1a. Create a new Analysis Services project  Open visual studio and create a new Analysis Services Multidimensional and Data Mining Project. ### 1b. Creating a Data Source  In the new project in Visual Studio, create a Data Source based on the CData [ADO.NET](http://ADO.NET) Provider (for Snowflake) ![ijscjPyHj70i75jJ8bSumlXaYy-9JXei7LM2WdzT0MIdOu6EEW75H5Yy8qr9UdK1ZYD8DvIHuyxF_9VtTp1eL9KUgQhU4Kpaq9XevC2dl9b0QLgLurYk1L5bkOiyCvOHBoFuWWTbu5rl4mCPwqe5Cas](https://us1.discourse-cdn.com/cdata/original/1X/ed90164a442e8ca4a56d93fedf9f60851300f9d7.png) ### 2. Creating a Data Source View  In the Solution Explorer, create a new Data Source View based on the new Data Source, configuring the foreign key pattern, and selecting the tables and views to model. ![71104e12-5696-4c63-a729-80f29a41bdb4.png](https://us1.discourse-cdn.com/cdata/original/2X/0/043c6951da2a749ebf24ddf2df58c5f76e18231b.png) ### 3. Create a Cube for Snowflake  In the Solution Explorer, create a new Cube, select the tables, measures, and dimensions you wish to model. ![3a56db73-63e8-47f6-9ca8-caed4a769bdf.png](https://us1.discourse-cdn.com/cdata/original/1X/0a24463e92200dba8140050acc10f2fcbf4c847e.png) ### 4. Process the project  Once the cube is configured, deploy it to SSAS. Configure the target server and database and process the project to build and deploy the cube. Now you have an OLAP cube for Snowflake in your SSAS instance, ready for analysis, reporting, and more. For a detailed guide, check out our in-depth [Knowledge base article](https://www.cdata.com/kb/tech/snowflake-ado-ssas.rst). ## More information & free trial  For more information on our connectivity solutions and to download a free trial, check out our [drivers page](https://www.cdata.com/drivers).