Question

1.     Explain how to filter a data source.

2.     Suppose you are creating a phone directory and have inserted the necessary merge fields in the first paragraph of the document. What do you need to do to ensure that each name and phone number is displayed on a separate line?

Answer 1

1. You can filters a data source,by reducing the amount of data in the data source.

If you create an extract from a data source that already has data source filters in place, those filters are automatically recommended as extract filters, and will appear in the Extract dialog. Those recommended filters are not required to be part of the Extract filter list, and can safely be removed without affecting the existing set of data source filters.

Data source filters can be useful for restricting the data users can see when you publish a workbook or data source. When you publish a data source to Server, the data source and any associated files or extracts are transported in entirety to the Server. As you publish a data source you can define access permissions for downloading or modifying the data source, and you can also choose the users and groups who can remotely issue queries through Server against that data source. When users have query permission and no download permission, you can share a rich data model having calculated fields, aliases, groups, sets and more

for example by filtering dimensions for specific users and groups, or by defining data source filters based on a fixed or relative date range. This is often useful for data security, and it also allows you to manage performance of the remote database whichnServer will ultimately query on a user's behalf. For systems that rely heavily on partitions or indexing.

2.  Suppose we are creating a phone directory and have inserted the necessary merge fields in the first paragraph of the document. We can ensure that each name and phone number is displayed on a separate line by adding merge fields is a way to personalize a document with information from the data source. The merge fields come from the column headings in the data source.we have to ensure about the selection of correct datafeild for the insertion or merging of new feild.