MicroStrategy ONE
List Document Properties statement
Lists all properties of a document in a project.
LIST [ALL] PROPERTIES FOR
DOCUMENTdocument_nameIN FOLDERlocation_pathFOR PROJECTproject_name;
where:
-
document_name is the name of the document, of type string, between double quotes (" ").
-
location_path is the folder where the document resides, of type string, between double quotes (" ").
-
project_name is the name of the project, of type string, between double quotes (" ").
Example
LIST ALL PROPERTIES FOR DOCUMENT "Profit Forecast"
IN FOLDER "\Public Objects" FOR PROJECT "MicroStrategy
Tutorial";
ResultSet Columns
CREATION_TIME: The date and time the document was created, returned as a date/string.
DESCRIPTION: The description of the document, returned as a string.
DOC_DISPLAY_MODES: A list of the available display modes for the document, such as Interactive and Editable. Returned as a string.
DOC_EXPORT_MODES: A list of the available export formats for the document, returned as a string.
DOC_REPORT_DATASETS: A ResultSet listing each report used in the document, as well as related details such as the report's location and type.
-
DSS_OBJECT_TYPE: The type of report, such as "Grid Report" or "Graph Report". 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: Hierarchy03840: 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
-
FOLDER: The path to the report, returned as a string.
-
HIDDEN: Whether or not the report is hidden, returned as a boolean value.
-
REPORT_NAME: The name of the report, returned as a string.
ENABLE_CACHE: Whether or not caching is enabled for the document, returned as a string.
HIDDEN: Whether or not the document is hidden, returned as a boolean value.
ID: The object ID of the document, returned as a string.
LONG_DESCRIPTION: The long description of the document, returned as a string.
MODIFICATION_TIME: The date and time the document was last modified, returned as a date/string.
NAME: The name of the document, returned as a string.
OWNER: The owner of the document, returned as a string.