SQL SERVER 2012 BI SEMANTIC MODEL – LIMIT AMOUNT OF DATA ON FIRST IMPORT

SQL SERVER 2012 BI SEMANTIC MODEL – LIMIT AMOUNT OF DATA ON FIRST IMPORT

Hello!

This blog is on BI Semantic Model and I assume that you are aware what BI Semantic model is. I plan to take you through a brief introduction on data import or precisely selective data import.

Please see below for the steps. This is fairly significant as this description showcases an important feature of “Editing an existing connection”.

• Create a new analysis services tabular project. This opens up a blank designer.
• Click on import from data source and configure the window to use a SQL query.
• Give a suitable name to the table and compose a SQL query.
• Now finish the wizard and you end up with one table object in your new tabular model.
• In order to add more table objects, we need to edit the connection manager and write more SQL queries. 
• To do that, click on existing connections and edit the already existing connection.
• Click on open and compose a new custom SQL query and give it a suitable name.

You may relate this feature with the named query and named calculations made available to implement the design changes in the data source view while building a cube using SQL Server Analysis Service.

Few benefits that I can cite would be:

• Perform joins in the SQL query can bring joined data for tabular modeling, rather than using RELATED or RELATEDTABLE DAX functions.
• Perform any string operations, date calculations and bring transformed data to the designer pane.

That’s all. Happy Learning!

Find us on Facebook at http://www.FaceBook.com/SQLServerGeeks and Twitter at @SqlServerGeeks

Thanks | Raunak Jhawar | t:@raunakjhawar