Created by James Hurrell on Apr 16, 2021
Summary: This section is intended to provide description of the CAST System Views (commonly known as "CSV") that can be used to facilitate queries against the Analysis or Dashboard Services. Using these views rather than tables will facilitate the migration of customized queries between different versions of CAST.

Update of CAST System Views

Analysis Service CSV

Analysis Service CSVs are updated automatically as part of the analysis process.

Dashboard Service CSV

Dashboard Service CSVs are updated automatically as part of the snapshot generation process.

Detailed information

Notes

  • Depending on your specific configuration, some views may not be available.
  • CAST System Views in the Analysis Service will contain "-1" as the value for length and precision for the following Microsoft SQL-Server 2005 objects whose datatype is "xml", "varchar(max)", "nvarchar(max)", or "varbinary(max)":
    • stored procedure or function parameters
    • table or view columns
    • column returned by table-functions
    • User defined types (UDTs)

  • Typographical errors have been discovered in columns in the CSV_OBJECT_STATUSES and CSV_VIOLATION_STATUSES views. These typographical errors have been fixed in CAST AIP ≥ 8.3.3 by adding new columns spelt correctly. The existing column names containing the spelling errors will remain and are now deprecated, therefore, please update any scripts or queries that use the existing column names. The columns containing typograhical errors will be removed in a future release of CAST AIP:

    • CSV_OBJECT_STATUSES
      • SNAPHOT_ID replaced by SNAPSHOT_ID
      • OBEJCT_TECHNO_TYPE_ID replaced by OBJECT_TECHNO_TYPE_ID
    • CSV_VIOLATION_STATUSES
      • SNAPHOT_ID replaced by SNAPSHOT_ID
  • Please note that the following Analysis Service CSVs may cause performance issues when used in conjunction with a large number of objects:
    • CSV_CALLED_OBJECTS - use CTV_LINKS instead
    • CSV_CALLER_OBJECTS - use CTV_LINKS instead

Please note that the CSV_PARENT table has been removed from CAST System Views for the Analysis Service: it caused performance and sizing issues and is often incorrectly used.References to this table must be replaced with references to the following tables:

  • CTT_OBJECT_APPLICATIONS
  • CTT_OBJECT_PARENTS
  • CTT_OBJECT_CONTAINERS
  • CTT_OBJECT_ANALYSIS
  • CDT_OBJECTS

If, for any reason, you need to extract information provided by the deprecated CSV_PARENT table for use with legacy client HSQ files, you can use the query listed below. Warning: the query is not resource-efficient (hence the deprecation of the original table); as such, it must be stripped of unnecessary information to improve its performance level (i.e. make sure you only use the fields you require); its purpose is only to showcase how to retrieve information.

select
distinct CO.OBJECT_ID,
CO.OBJECT_NAME,
CO.OBJECT_FULLNAME,
CO.OBJECT_MANGLING,
CO.OBJECT_TYPE_STR as "OBJECT_TYPE",
CO.OBJECT_TYPE_EXT,
COP.PARENT_ID ,
COC.CONTAINER_ID,
COC.APPLICATION_ID,
CAA.ANALYSIS_ID,
CAA.ANALYSIS_NAME,
CO.OBJECT_LANGUAGE_NAME as "LANGUAGE_NAME"
from
CDT_OBJECTS CO, CTT_OBJECT_PARENTS COP, CTT_OBJECT_CONTAINERS COC, CSV_ANA_APPLI CAA
where
CO.OBJECT_ID = COP.OBJECT_ID
and CO.OBJECT_ID = COC.OBJECT_ID
and COC.APPLICATION_ID = COP.APPLICATION_ID
and COC.APPLICATION_ID = CAA.APPLICATION_ID