Software Title Dimension

FlexNet Manager Suite 2020 R2 (On-Premises)

As part of the Installation analysis, the Software title dimension allows you to drill down to an individual application (or 'software title') as part of analyzing software installed throughout your enterprise.

The Software title dimension expands into a three-level hierarchy that gives you access to (in order):
  • Publisher
  • Product
  • Software Title Name (or, as seen within FlexNet Manager Suite, the application name).
You may report on any level. For example, if you choose only a publisher, your report includes all products and applications from that publisher.
Table 1. Attributes for the Software title dimension, Publisher level
Attribute Notes
Publisher

The name of the company that publishes this application (and product).

Related management view: For each application, the publisher is linked through the General tab of the application properties. However, the publisher must exist first for linking, and these records are maintained in the Procurement > All Vendors view. The publisher for each application is widely available in application listings, such as License Compliance > All Applications.

Database reference: The primary list of all vendors (including both publishers and resellers) is maintained in the Vendor table. Once linked to an application, minimal detail about the publisher is replicated in the SoftwareTitlePublisher table, where this value is visible as PublisherName. This table is referenced through the SoftwareTitleProduct table, which is in turn referenced by the SoftwareTitle (application) table.

Data warehouse reference: PublisherName column in the SoftwareTitleData table.

Table 2. Attributes for the Software title dimension, Product level
Attribute Notes
Product

The common name for a family of applications, independent of version or edition details. This must be unique for any given publisher.

Related management view: For each application, the Product name is displayed in the General tab of application properties (and when you manually create an application record, you can link the product value there). All applications that share a common value in that Product field are deemed to be distinct versions/editions of the same product. The product name is widely available in application listings, such as License Compliance > All Applications (although sometimes you must add it to the listing from the column chooser).

Database reference: Product names are maintained in the SoftwareTitleProduct table.

Data warehouse reference: ProductName column in the SoftwareTitleData table.

Table 3. Attributes for the Software title dimension, Software Title (or application) level (alphabetical listing)
Attributes Notes
Application

The name of the application.

Related management view: For each application, the Name is displayed in the General tab of application properties (and when you manually create an application record, you can edit the application name there). The application name appears in all application listings, such as License Compliance > All Applications.

Database reference: Available in the SoftwareTitle table, FullName column.

Data warehouse reference: SoftwareTitleName column in the SoftwareTitleData table.

Application status

Shows the current status for the application, from values such as Authorized, Ignored, Deferred. and others.

Related management view: For each application, the Status is displayed in the General tab of application properties (and when you manually create an application record, you can edit the status there). The application Status is widely available in application listings, such as License Compliance > All Applications.

Database reference: Status values (for all applications) are saved in the SoftwareTitleAction table. The SoftwareTitle table references the appropriate value through the SoftwareTitleActionID column.

Data warehouse reference: Action column in the SoftwareTitleData table.

Classification

The classification applied to this application, such as Commercial or Malware.

Related management view: For each application, the Classification is displayed in the General tab of application properties (and when you manually create an application record, you can edit the classification there). The application classification is widely available in application listings, such as License Compliance > All Applications.

Database reference: Classifications (for all applications) are saved in the SoftwareTitleClassification table. The SoftwareTitle table references the appropriate value through the SoftwareTitleClassificationID column.

Data warehouse reference: Classification column in the SoftwareTitleData table.

Edition

The edition of this application. Editions describe different levels of product functionality, such as Standard and Pro.

Related management view: For each application, the Edition is displayed in the General tab of application properties (and when you manually create an application record, you can edit the edition there). The application edition is widely available in application listings, such as License Compliance > All Applications.

Database reference: All editions (for all applications) are saved in the SoftwareTitleEdition table. The SoftwareTitle table references the appropriate value through the SoftwareTitleEditionID column.

Data warehouse reference: EditionName column in the SoftwareTitleData table.

Is licensed

A Boolean that indicates whether the application is linked to any license.

Related management view: For each application, the Licenses tab of application properties lists the license(s) to which this application is linked. You can also attach or detach licenses to/from the application on that tab. The Licensed column is widely available in application listings, such as License Compliance > All Applications.

Database reference: The SoftwareTitleLicense table links applications to licenses. If the SoftwareTitleID for the chosen application appears in this table (at snapshot time), then Is licensed reports Yes.

Data warehouse reference: IsLicensed column in the SoftwareTitleData table.

Version

The version (or release number) of this application.

Related management view: For each application, the Version is displayed in the General tab of application properties (and when you manually create an application record, you can edit the version there). The application version is widely available in application listings, such as License Compliance > All Applications.

Database reference: All versions (for all applications) are saved in the SoftwareTitleVersion table. The SoftwareTitle table references the appropriate value through the SoftwareTitleVersionID column.

Data warehouse reference: VersionName column in the SoftwareTitleData table.

FlexNet Manager Suite (On-Premises)

2020 R2