The following are some of the attributes you might want
to add to the synonym to enhance your data access and reporting
capabilities. You can:
Create a cluster
Join view by linking available synonyms to create a multisegment
(multitable) file for reporting.
Apply security rules for fields and values
to ensure that user access is based on Information Builders data
source security (DBA) specifications.
Add dimensions
for OLAP analysis.
Add virtual
columns (DEFINE fields) and columns for aggregated values (COMPUTE fields).
Add filters
to specify data selection criteria.
Add group definitions
for data sources that support groups.
Add meaningful
titles and descriptions, including multilanguage variations.
Change the
format of fields (for example, the size of an alphanumeric field
or the format of a date field).
Create business views of the metadata
in order to limit the fields available to any retrieval request
that references the business view and to group fields together based on
their roles in an application.
Define parent
and child hierarchies for cube data sources such as SAP BW and Essbase.