KB35806: How to do modify ACL for attributes or metrics in Free Form SQL reports in MicroStrategy Desktop 9.0.2

SYMPTOM
 
When attempting to modify the ACL of attributes and metrics created inside a Free Form SQL report, users notice that the options are grayed out as shown in the image below:
 
 
 

 
Note that this behavior ocurrs when right clicking on the object in the Free Form SQL editor and selecting 'Properties'
 
CAUSE
Objects created inside of FFSQL reports are managed and their properties need to be changed outside of the FFSQL report editor.
 
ACTION
 
Follow the steps below to modify the ACLs of managed objects in Strategy Developer 9.x-10x
 

• Search for the attribute or metric using a standard search object in Strategy Developer 9.x-10.x
• In order to display the managed object in the search editor, the "Display Managed objects" option should be enabled as shown below:

• Right click on the Search results to modify the properties of the objects.