Page tree
Skip to end of metadata
Go to start of metadata
This method of extracting information is deprecated. You should now use the CAST RestAPI to extract the information you require.
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)
  • Please note that the following Analysis ServiceCSVs 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 is no longer used in CAST System Views for the Analysis Service: it causes performance and sizing issues and is often incorrectly used. It is no longer populated with data and is thus deprecated. 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
  • No labels