![]() If you are new to SSAS DSV or tutoring, use Name Matching Criteria for quick relationships from tables pulled from data source.To achieve this, Explore Data for a table and in window with sample click on Setting option and manipulate as your choice (Don’t forget to click on refresh button to sample, all highlighted in following screenshot). Even increase/decrease the number of sample rows, by default its 5000. Like select r andom or top sorted sample. You can also manipulate values in Explore Data.Did you use Zoom –> To Fit option ? If not then try it thank me later.This is your practice ground for dimension usage relationships. For example, where it should be Many to one or one to many, Matching data type warning etc. DSV always warn you for incorrect relationships.Change the table to Named Query and remove the column from list of SELECT is your option. You cannot delete a column just by Click–>Delete on DSV. ![]() Right Click –> un-check option Show Friendly Names.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |