Reporting Server

You can use the Synonym Editor to create a cluster synonym by joining together multiple tables or synonyms from your data source that contain related data. You can create a cluster synonym when connecting to data stored in a remote database, or you can create a new cluster synonym from existing synonyms. In both of these processes, you use the Join Editor in the Synonym Editor to add and edit joins in the cluster. The Join Editor presents a modeling view of the cluster synonym that visually represents the structure of the cluster.

Your data may be arranged and structured in different ways depending on the size and amount of detail that it provides. Smaller data sources may be saved in a single spreadsheet or flat file, such as a CSV file, making them easy to access and distribute. Larger data sources, however, may contain too many records or fields to efficiently store in a single file.