1. Select Manage profiling methods from the Tools menu:
  2. Right-click the required Vendor / Version and select Copy.

    Change the Name , Vendor and Version as required and click OK .
     

    Note

    An asterix * can be used as a wildcard for either the whole version number or the minor version number in both the Min version and max version. For example , 9., and 9.0 are all valid values for Min version and Max version and match any version, any version 9 release, and only version 9.0 respectively. The method will be allowed to be used for any version between Min version and Max version (inclusive). Any User Defined Profiling methods created with a version of 3D prior to 2.4.0.0 match on the Version string returned by the RDBMS server. Leaving the version as * will allow the method to be used for any version.


    You need to assign the new profiling method to a model version for it to be used. Leaving the version as * will allow the method to be used for any version.

  3. The User defined methods can be edited as required—see details below.
    The toolbar enables you to perform the following:

    Icons

    Definition

    Click to import a method from a file.

    Click to export a method to a file.

    Click to reset a method from last save.

    Click to restore a method from last backup (before the last save)


    Looking at the Profiling Method for MS SQL Specifics for example; you can configure the profiling on Queries for:

    • Rowcount Query
    • Space used
    • Inferred data type query
    • General collection
    • String collection
    • Statistics collection
    • Min/Max query
    • Top 10 most frequent values query
    • Top 10 least frequent values query
    • In use % query
    • Ref invalid % query
    • Top 10 used PKs
    • Top 10 unusued PKs
    • Top 10 invalid FKs


To copy or delete a query, right-click the query as shown:

To add a query or copy multiple queries, right-click Queries as shown:

Looking again at the Profiling Method for MS SQL Specifics example; you can configure the profiling on Metrics for

    • Rowcount
    • Space used in MB
    • Average row length
    • Inferred data type
    • Distinct value count
    • Is unique
    • Null count
    • Null %
    • Populated count
    • Populated %
    • Min value
    • Max value
    • Min character count
    • Max character count
    • Avg character count
    • Max trimmed length
    • Standard deviation
    • Sum value
    • Avg value
    • Numeric range
    • Top 10 most frequent values
    • Top 10 least frequent values
    • In use %
    • Referentially invalid values %
    • Top 10 used PKs
    • Top 10 unused PKs
    • Top 10 invalid PKs


To delete a metric, right-click the metric and choose Delete metric as shown:

To add a metric, right-click Metrics and choose Add metric as shown:


Note

The Rowcount metric is not actually used as a profiling metric—it enables you to customize how 3D performs a row count on each table at the start of the profiling process. You can create your own metric to do this but it MUST be named Rowcount.

  • No labels