MicroStrategy ONE

Set Hidden Property statement

Sets the hidden property of a MicroStrategy metadata object to True or False.

Copy 
SET PROPERTY HIDDEN (TRUE | FALSE) FOR (CONSOLIDATION | DOCUMENT | FILTER | METRIC | PROMPT | REPORT | SEARCH | TEMPLATE | ATTRIBUTE | FACT | FUNCTION | HIERARCHY | TABLE | TRANSFORMATION | DRILLMAP | SECFILTER | AUTOSTYLE | BASEFORMULA) object_name IN FOLDER location_path FOR PROJECT "project_name";

where:

  • object_name is the name of the object whose hidden property is modified, of type string, between double quote.
  • 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 
SET PROPERTY HIDDEN TRUE FOR CONSOLIDATION "2003 & 2004" IN FOLDER "\Public Objects\Consolidations" FOR PROJECT "MicroStrategy Tutorial";
Copy 
SET PROPERTY HIDDEN TRUE FOR FILTER "Age Groups" IN FOLDER "\Public Objects\Custom Groups" FOR PROJECT "MicroStrategy Tutorial";