![]() See Data Selection Rules for more information about adding data selection rules. By applying selection rules, only the subset of data that you actually need is loaded into the semantic table. Click OK to add the relations (if any).ĭata selection rules are used to specify a set of conditions that data extracted from a source table must satisfy.Field relation: Relate using identical field names on both tables.An existing relation defined in the data warehouse (recommended).None: No relations to that table model.For each existing table, you have the following options: Here, you can set how the table you are adding is related to existing tables in the semantic model. If there are other tables on the model that have an existing relation to the new table or a field with the same name as a field on the new table, the Set Up Relations window appears.(Optional) In the Hidden column, select the fields you want to add to the semantic table, but not show in the endpoint.Select the fields you want in the semantic table.Note: This setting applies to SSAS Tabular endpoints only. In the Description box, type a description of the model to use in front-end tools.If you would like the table to have a different name in the semantic model, type the new name in the Name box.Drag a table from a data warehouse or business unit to Tables under the relevant model.To add a table to a semantic model, follow the steps below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |