Instead of consuming tables directly in tabular cube, it is recommended to first create SQL views out of those tables and then consume these views in SSAS tabular cubes. When views are used we get the flexibility to make few changes as listed below to name a few of them:

- Renaming field names to user friendly names
- Concatenating fields
- Excluding fields

To create SQL view from table, below mentioned process is followed

1. Click “New query” button in SSMS (SQL server management studio)

2. In the query editor write code to create a SQL view from table as shown in example below:

SQL Query example for creating view

3. Select the database where this view needs to be created when this query is executed.

4. Click on execute button as shown below to run this SQL query.

Execute query

5. Once this query is executed a view will be created inside selected database in step 3

View created


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment