Building ad hoc schemas
MicroStrategy Desktop allows us to build ad hoc schemas in intuitive ways using a friendly interface. Ad hoc schemas help business users to achieve quicker values. The core of the ad hoc building process is Data Import, which has many features such as auto-detect attributes type, auto-create metrics, auto-identify data relations, and allows us to preview data. In addition, it allows us to combine data from multiple sources in a single dataset, create multi-form attributes, and create and edit relationships across attributes. Finally, it can be mapped to project attributes in order to inherit project security filters in MicroStrategy Enterprise.
We are going to work with relational databases and use the same source as we used in Chapter 2, Setting Up an Analytics Semantic Layer and Public Objects when we built schemas. There is a picture from CA ERwin Data Modeler, that displays physical data models. Using this model, we can easily identify what tables we need and what...