The first Schema Object to be created must be a MicroStrategy Table. The following is a quick reference table for this MicroStrategy Object:
This object is simply the logical representation of a table in the database (data warehouse). MicroStrategy imports into the object definition the table name, structure, columns, and data types. In addition, MicroStrategy assigns a value to the table based on the fields and Attributes mapped to it. It is important to mention that this number doesn't represent a measure of megabytes or number of rows but instead a conceptual value; this is why it is called the logical table size. This number is utilized by the MicroStrategy SQL Engine to choose which table should be used for the query when two tables are available to get the same data. MicroStrategy chooses the table with the smaller logical table size to...