FlexNet Operations Reporting Model
This section describes the tables that comprise the FlexNet Operations reporting database. It includes entity-relationship diagrams; descriptions of the columns in the dimension, fact, and other tables; and information about sample SQL scripts.
This chapter describes the various tables—mainly dimensions and facts—that are available in the FlexNet Operations reporting model. You can use these tables when creating or modifying SQL scripts to generate your own reports.
|
Section |
Description |
|
Schema diagram illustrating the tables in the FlexNet Operations reporting database and the relationships among them. |
|
|
Most producers use reporting to view some sort of aggregated data. These data are called facts (or measures): numeric values that are measurable and additive. This section lists the FlexNet Operations reporting database fact tables. |
|
|
A dimension is a set of related properties based on available data, which can be made use of in a report. Most dimensions have attributes that express some aspect of the dimension. This section lists the FlexNet Operations reporting database dimension tables. |
|
|
Custom Attribute tables store custom content that is used in the End-User Portal to customize page instructions on supported pages, add announcements to the home page, or create standalone pages. This section lists the FlexNet Operations reporting database custom attribute tables. |
|
|
This section lists additional tables in the FlexNet Operations reporting database. |
|
|
Describes the scripts provided to illustrate SQL queries that generate reports based on data in the FlexNet Operations reporting database. |
The fact and dimension tables, as well as supporting date, user, and housekeeping tables, are documented in this chapter and illustrated in the Reporting Schema Diagrams.
Note:Unless the entity is specifically mentioned in this chapter, it is not supported by FlexNet Operations reporting.