List Dependents statement

Lists all dependent objects of a FOLDER, REPORT, DOCUMENT, CONSOLIDATION, CUSTOMGROUP, FILTER, METRIC, SEARCH, SHORTCUT, TEMPLATE, TRANSFORMATION, SECURITY FILTER, ATTRIBUTE, HIERARCHY, DRILLMAP, or PROMPT.

LIST [ALL] DEPENDENTS FORobject_type"object_name" IN FOLDER "location_path" [RECURSIVELY] IN PROJECT "project_name";

where:

• object_type is the type of the object, between double quotes, from the following list:

• FOLDER
• REPORT
• DOCUMENT
• CONSOLIDATION
• CUSTOMGROUP
• FILTER
• METRIC
• SEARCH
• SHORTCUT
• TEMPLATE
• TRANSFORMATION
• SECURITY FILTER
• ATTRIBUTE
• HIERARCHY
• DRILLMAP
• PROMPT
• TABLE
• object_name is the name of the object, of type string, between double quotes (" ").
• location_path is the folder path where the object is located, of type string, between double quotes (" ").
• project_name is the name of the project that contains the object, of type string, between double quotes (" ").

Example

LIST ALL DEPENDENTS FOR METRIC "New Metric" IN FOLDER "\Public Objects\Metrics" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

LIST ALL DEPENDENTS FOR <PROJECT OBJECT>

• DSS_OBJECT_TYPE: The type of the dependent, returned as an integer:

  • 256: Filter
  • 257: Custom Group
  • 512: Template
  • 768: Grid Report
  • 769: Graph Report
  • 770: SQL Report
  • 771: Text Report
  • 772: Data Mart Report
  • 773: Base Report
  • 774: Grid Graph Report
  • 775: Non Interactive Report
  • 776: Intelligent Cube
  • 1024: Metric
  • 1025: Subtotal
  • 1026: Subtotal
  • 1027: Predictive Metric
  • 1028: Training metric
  • 1536: AutoStyle
  • 1792: Base Formula
  • 2048: Folder
  • 2560: Prompt
  • 2561: Boolean prompt
  • 2562: Long number prompt
  • 2563: Text prompt
  • 2564: Numeric prompt
  • 2565: Date prompt
  • 2566: Object prompt
  • 2567: Elements prompt
  • 2568: Expression prompt
  • 2569: Expression draft prompt
  • 2571: Big Decimal Prompt
  • 2816: Function
  • 3072: Attribute
  • 3073: Role Attribute
  • 3074: Transformation Attribute
  • 3075: Abstract Attribute
  • 3328: Fact
  • 3584: System Hierarchy
  • 3585: Hierarchy
  • 3586: Ordered User Hierarchy
  • 3587: Hierarchy
  • 3840: Logical Table
  • 3841: Metadata Partition Mapping
  • 3842: Warehouse Partition Mapping
  • 4352: Fact Group
  • 4864: Resolution
  • 5376: Attribute form
  • 5377: Form
  • 5378: Form
  • 5632: Schema
  • 6144: Catalog
  • 6400: Catalog definition
  • 6656: Column
  • 7168: Property Set
  • 7424: Database Instance
  • 7680: Database login
  • 7936: Database connection
  • 8192: Project
  • 8448: Server Definition
  • 8704: User
  • 8705: User Group
  • 9216: Configuration
  • 9472: Request
  • 9984: Search
  • 10240: Search folder
  • 10752: Function Package Definition
  • 11008: Role
  • 11009: Transformation
  • 11264: Security role
  • 12032: Consolidation
  • 12288: Consolidation Element
  • 12544: Event
  • 12800: Schedule
  • 13056: Schedule
  • 13312: Link
  • 13568: Warehouse Table
  • 13569: Partition table
  • 13824: Table source
  • 14080: HTML Document
  • 14081: Document
  • 14336: Drill Map
  • 14592: DBMS
  • 14848: Security Filter
• ID: The object ID of the dependent, returned as a string.
• MODIFICATION_TIME: The date and time the dependent was last modified, returned as a date/string.
• NAME: The name of the dependent, returned as a string.
• OWNER: The owner of the dependent, returned as a string.
• PATH: The path to the dependent, returned as a string.

LIST ALL DEPENDENTS FOR <CONFIGURATION OBJECT>

• DSS_OBJECT_TYPE: The type of the dependent, returned as an integer:

  • 256: Filter
  • 257: Custom Group
  • 512: Template
  • 768: Grid Report
  • 769: Graph Report
  • 770: SQL Report
  • 771: Text Report
  • 772: Data Mart Report
  • 773: Base Report
  • 774: Grid Graph Report
  • 775: Non Interactive Report
  • 776: Intelligent Cube
  • 1024: Metric
  • 1025: Subtotal
  • 1026: Subtotal
  • 1027: Predictive Metric
  • 1028: Training metric
  • 1536: AutoStyle
  • 1792: Base Formula
  • 2048: Folder
  • 2560: Prompt
  • 2561: Boolean prompt
  • 2562: Long number prompt
  • 2563: Text prompt
  • 2564: Numeric prompt
  • 2565: Date prompt
  • 2566: Object prompt
  • 2567: Elements prompt
  • 2568: Expression prompt
  • 2569: Expression draft prompt
  • 2571: Big Decimal Prompt
  • 2816: Function
  • 3072: Attribute
  • 3073: Role Attribute
  • 3074: Transformation Attribute
  • 3075: Abstract Attribute
  • 3328: Fact
  • 3584: System Hierarchy
  • 3585: Hierarchy
  • 3586: Ordered User Hierarchy
  • 3587: Hierarchy
  • 3840: Logical Table
  • 3841: Metadata Partition Mapping
  • 3842: Warehouse Partition Mapping
  • 4352: Fact Group
  • 4864: Resolution
  • 5376: Attribute form
  • 5377: Form
  • 5378: Form
  • 5632: Schema
  • 6144: Catalog
  • 6400: Catalog definition
  • 6656: Column
  • 7168: Property Set
  • 7424: Database Instance
  • 7680: Database login
  • 7936: Database connection
  • 8192: Project
  • 8448: Server Definition
  • 8704: User
  • 8705: User Group
  • 9216: Configuration
  • 9472: Request
  • 9984: Search
  • 10240: Search folder
  • 10752: Function Package Definition
  • 11008: Role
  • 11009: Transformation
  • 11264: Security role
  • 12032: Consolidation
  • 12288: Consolidation Element
  • 12544: Event
  • 12800: Schedule
  • 13056: Schedule
  • 13312: Link
  • 13568: Warehouse Table
  • 13569: Partition table
  • 13824: Table source
  • 14080: HTML Document
  • 14081: Document
  • 14336: Drill Map
  • 14592: DBMS
  • 14848: Security Filter
• ID: The object ID of the dependent, returned as a string.
• MODIFICATION_TIME: The date and time the dependent was last modified, returned as a date/string.
• NAME: The name of the dependent, returned as a string.
• OWNER: The owner of the dependent, returned as a string.