Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Notewarning

This

method of extracting information is deprecated. You should now use the CAST RestAPI to extract the information you require

documentation is no longer maintained and may contain obsolete information.


Panel
Table of Contents

This document provides a detailed description of each DSS_ table provided in the Dashboard Service together with column information. Depending on your specific configuration, some tables/views may not be available.

...

Log table for saving transfered DSS_OBJECTS table:

OBJECT_CHECKSUM

int

NULL

-

 


OBJECT_DESCRIPTION

varchar

1000

Object description

 


OBJECT_FULL_NAME

varchar

1000

Object full name

 


OBJECT_ID

int

NULL

Object ID - this ID is unique in the Dashboard Service. Use DSS_TRANSLATION_TABLE to find the ID of the Object in the Analysis Service.

 


OBJECT_NAME

varchar

255

Object name 


OBJECT_TYPE_ID

int

NULL

Object type ID - see DSS_OBJECT_TYPES

SITE_ID

int

NULL

Site ID

SNAPSHOT_ID

int

NULL

Snapshot ID

...

FLAT_INDEX

varchar

255

-

METRIC_CHILD_OR_VALUE

int

NULL

-

METRIC_ID

int

NULL

Quality Rule ID

METRIC_PARENT_ID

int

NULL

Quality Rule's parent ID

OPERATION_AGGREGATE

int

NULL

 


OPERATION_DONE

int

NULL

  • 0: The operation has not made yet.
  • 1: The operation is finished.
  • 2: The operation is disabled.
  • 999: The operation is on the way.
  • 888: The operation was started, but
    cancelled.

OPERATION_ID

int

NULL

-

OPERATION_PROCNAME

varchar

255

-

OPERATION_TYPE

int

NULL

  • 1: scope
  • 2: results
  • 3: aggregate

...

FLAT_INDEX

varchar

255

-

FLAT_LEVEL

int

NULL

-

METRIC_GRAND_PARENT_ID

int

NULL

Quality Rule's grandparent ID

METRIC_ID

int

NULL

Quality Rule ID

METRIC_INDEX

int

NULL 


METRIC_PARENT_ID

int

NULL

Quality Rule's parent ID

...