MicroStrategy ONE

Get Object Property statement

Gets the properties of a MicroStrategy metadata object.

Copy 
GET PROPERTIES (property1,property2, ...propertyN) FROM (CONSOLIDATION | DOCUMENT | FILTER | METRIC | PROMPT | REPORT | SEARCH | TEMPLATE | ATTRIBUTE | FACT | FUNCTION | HIERARCHY | TABLE | TRANSFORMATION | DRILLMAP | SECFILTER | AUTOSTYLE | BASEFORMULA | FOLDER | SHORTCUT)object_nameIN FOLDERlocation_pathFOR PROJECT "project_name";

where:

  • property1, property2, ... propertyN are the names of the properties. These can be any of the following: NAME, ID, DESCRIPTION, LONGDESCRIPTION, LOCATION, CREATIONTIME, MODIFICATIONTIME, OWNER, LONGDESCRIPTION, HIDDEN.
  • object_name is the name of the object from which the Hidden property is obtained, of type string, between double quotes (").
  • location_path is the folder where the object resides, of type string, between double quotes (" ").
  • project_name is the name of the project, of type string, between double quotes (" ").

This is the object hierarchy used in property management. To identify an object at a lower hierarchy, just specify the name of the object at the top level.

Table:

  • Logical Table
  • Warehouse Partition Table
  • MetaData Partition Table

Metric:

  • Subtotal
  • Predictive Metric

Filter:

  • CustomGroup

Report:

  • Grid
  • Graph
  • GridGraph
  • Datamart
  • SQL

Document:

  • ReportService document
  • HTML Document

Examples

Copy 
GET PROPERTIES NAME, ID, MODIFICATIONTIME, HIDDEN FROM CONSOLIDATION "2003 & 2004" IN FOLDER "\Public Objects\Consolidations" FOR PROJECT "MicroStrategy Tutorial";
Copy 
GET PROPERTIES HIDDEN FROM FILTER "Age Groups" IN FOLDER "\Public Objects\Custom Groups" FOR PROJECT "MicroStrategy Tutorial";
Copy 
GET PROPERTIES NAME FROM ATTRIBUTE "Customer" IN FOLDER "\Schema Objects\Attributes\Customers" FOR PROJECT "MicroStrategy Tutorial";

ResultSet columns

CREATION_TIME: The date and time of the creation of the object, returned as a date/string.

DESCRIPTION: The description of the object, returned as a string.

FOLDER: The complete path to the object, returned as a string.

HIDDEN: Whether or not the object is hidden , returned as a Boolean.

ID: The GUID of the object, returned as a string.

LONG_DESCRIPTION: The long description of the object, returned as a string.

MODIFICATION_TIME: The date and time the object was last modified, returned as a date/string.

NAME: The name of the object, returned as a string.

OWNER: The owner of the object, returned as a string.