KB45112: How to count all elements of an attribute even when a security filter is applied to the attribute attribute elements in MicroStrategy Developer

In some business scenarios, it is required to work around security filter and count all of attribute elements, as shown below:

 
NOTE: In normal situation, if security filter is used, the count metric will only count the current attribute elements and display 1 in this situation, as shown below:

 
 
Follow the steps below to achieve the requirement:

• Create a new attribute with exactly the same definition with attribute .
• Update Schema.
• Create a new metric and count attribute elements based on attribute . And ignore filtering of attribute , as shown below:
  

• Add the new metric into report.
• Run the report and the count metric will always display the real total of attribute elements, disregarding the Security Filter.