Create Shortcut statement

Creates a shortcut to a specified object within a project. To create a shortcut to a subtype object, create a shortcut to an object of its parent type. For example, a shortcut to a subtotal should be created as a shortcut to a metric. For a list of subtype objects and their parents, see Object hierarchy.

Copy

CREATE SHORTCUT [shortcut_name] IN FOLDERlocation_pathFOR (FOLDER | CONSOLIDATION | DOCUMENT | FILTER | METRIC | PROMPT | REPORT | SEARCH | TEMPLATE | ATTRIBUTE | FACT | FUNCTION | HIERARCHY | TABLE | TRANSFORMATION | DRILLMAP | SECFILTER | AUTOSTYLE | BASEFORMULA | INTELLIGENTCUBE | DERIVEDELEMENT)object_nameIN FOLDERobject_location_path[HIDDEN (TRUE | FALSE)] FOR PROJECTproject_name;

where:

shortcut_name is the name of the shortcut, of type string, between double quotes (" ").
object_name is the name of the object of which a shortcut is being created, of type string, between double quotes (" ").
location_path is the folder where the shortcut is to be placed, of type string, between double quotes (" ").
object_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 (" ").

Examples

Copy

CREATE SHORTCUT "ShippingAnalysisShortcut" 
 IN FOLDER "\Public Objects" FOR DOCUMENT "Shipping Analysis" 
 IN FOLDER "\Public Objects\Reports\Enterprise 
 Reporting Documents FOR PROJECT MicroStrategy Tutorial;

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR METRIC "Revenue" IN FOLDER "\Public Objects\Metrics\Sales 
 Metrics" FOR PROJECT "MicroStrategy Tutorial";

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR ATTRIBUTE "Customer" IN FOLDER "\Schema Objects\Attributes\Customers" 
 FOR PROJECT "MicroStrategy Tutorial";

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR FACT "Profit" IN FOLDER "\Schema Objects\Facts\ 
 FOR PROJECT MicroStrategy Tutorial;

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR FILTER "Age Groups" IN FOLDER "\Public Objects\Custom 
 Groups" FOR PROJECT "MicroStrategy Tutorial";

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR FILTER "Eastern United States Customers" IN FOLDER "\Public 
 Objects\Filters" FOR PROJECT "MicroStrategy Tutorial";

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR FOLDER "Drill Maps" IN FOLDER "\Public Objects" 
 HIDDEN TRUE FOR PROJECT "MicroStrategy Tutorial";

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR HIERARCHY "Time (Browsing)" IN FOLDER "\Schema Objects\Hierarchies\Data Explorer 
 FOR PROJECT MicroStrategy Tutorial;

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR SECFILTER "New Security Filter1" IN FOLDER "\Project 
 Objects\MD Security Filters FOR 
 PROJECT MicroStrategy Tutorial;

Copy

CREATE SHORTCUT IN FOLDER "\Public Objects" 
 FOR TABLE "PMT_INVENTORY" IN FOLDER "\Schema Objects\Partition Mappings FOR PROJECT 
 MicroStrategy Tutorial;