Wednesday, June 29, 2016

SSAS Tabular Part 3 : Rename and Filter the table data Before importing into Tabular Model

For Table Security and easy user access Microsoft added options for Rename table. You can give any Name for each table before import the table into model.

For example i have given some Friendly name for few tables.



Now come to Filer option of the table data.
To do that you have to select particular table and click on "Preview & Filter" button.


Here i have selected 'DimProduct' Table and given friendly name as 'Product'. Now i click on 'Preview & Filterbutton.


Now we can see Product table with all the columns. But in our model we have no need for all the columns in 'Product' Table. To unselect the column, we have to untick the check box near specific column.

Here i have removed 2 column from 'Product' table by untick the SpanishProductName and FrenchProductName.


Apart form that we can apply filter on specific selected column also. 


After filter click on 'Finish' Button.




No comments:

Post a Comment