The Source – Tables

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 optimize the query. Nevertheless, this number can be manipulated by the project Architect. An example of this scenario would be forcing the MicroStrategy SQL Engine to choose a table with a lower level of detail over a summary table.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.198.59