Figure 1 shows Object Explorer with all nodes of the AdventureWorks Tabular Model SQL 2012 database expanded. So now that you’ve been forewarned, let’s take a closer look at our database in Object Explorer. That said, for many of the basic administrative operations, SSMS is more than adequate, and it provides an easy way to view the data, which is just as important, if not more. When it comes to the tabular model, Microsoft sees SSDT as the primary tool for most data-definition type operations, the idea being that you redeploy, rather than making changes on the fly. However, as you’ll quickly discover, the options you have in SSMS for managing a database are quite limited compared to what’s available for relational databases-or even SSAS multidimensional databases. In SSMS, you can manage your tabular databases as well as query the data in them. If you find it listed there, you’re good to go. Then, in Object Explorer, expand the Databases node to display the database. Once you get all the pieces in place and the AdventureWorks Tabular Model SQL 2012 database deployed to the SSAS instance, open SSMS and connect to that instance. For details about how to set up the project in SSDT, configure the necessary settings, and deploy the database, see the TechNet article “ SQL Server Samples Readme.” You download the project from the same AdventureWorks CodePlex site where you download the data warehouse.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |