DataWarehouse Database Schema

IT Asset Management (Cloud)

This chapter describes a schema for the dimensional data model available for reporting using the Flexera Analytics (powered by Cognos).

There are three separate data models related to IBM Cognos within IT Asset Management:

• A model for use when customizing dashboards for IT Asset Management (see Dashboard Tables)
• An operational model for reporting on live data (this model is not separately documented)
• The dimensional data model for reporting on data that changes over time, which is the subject of this chapter.