-
Book Overview & Buying
-
Table Of Contents
Mastering Business Intelligence with MicroStrategy
By :
Schema objects represent different components of the logical data model and are directly mapped to a column or columns in the database. Attributes, facts, functions, and operations, hierarchies, partition mappings, tables, and transformations are all schema objects; however, three schema objects comprise the core of project definition and will be covered in this section:

Attributes are the descriptive part of the database. They provide information about the data; for example, customer name and city are attributes. The SELECT clause of a SQL statement is based on these attributes.
The following is the report with the Policy Number and Broker Name as an attribute:

When we see the SQL for this report, the Policy Number and Broker Name will be shown in the SELECT clause as follows:

We have three different types of attribute:
Compound attribute: Uses two or more columns as its ID. It is like...
Change the font size
Change margin width
Change background colour