EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB17937: How to prevent drilling from a particular attribute in MicroStrategy Developer 9.4.x - 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note lists the steps to prevent drilling from a particular attribute in MicroStrategy Developer 9.4.x - 10.x.

In Strategy Developer, after running a report, users may wish to prevent a particular attribute from being drillable. For instance, in the report below, users are able to drill up and down the Product hierarchy but there may be certain instances where upon running a report with the attribute Item, it is not desirable to drill from this attribute to anything else.
 

ka02R000000kaRCQAY_0EM440000002Esh.gif

 
How can drilling be prevented once users have drilled to attribute Item?
Once users have drilled to attribute Item, they can prevent drilling by creating an empty drill map and using the Drill Map Editor tool and associating to this drill map any objects that should have no drilling. 
To create this empty drill map, follow the steps outlined below:

  • Open the Drill Map Editor.
  • Do not create anything to be used as a drill path. Instead, just choose which objects to associate so that they should not be drillable. For this example, the attribute Item is chosen.
ka02R000000kaRCQAY_0EM440000002Esd.gif
  • Save this drill map, associate it with the report and rerun the report. Note that it is now not possible to drill from attribute Item anymore.
ka02R000000kaRCQAY_0EM440000002Esc.gif
  •  
    And when a right click is done on the attribute element, the option to drill is not available.
     
ka02R000000kaRCQAY_0EM440000002Ese.gif

Comment

0 comments

Details

Knowledge Article

Published:

April 24, 2017

Last Updated:

April 24, 2017