KB36495: Several attribute elements disappear once the attribute is moved to page-by field with MicroStrategy Developer 9.x and 10.x

 
SYMPTOM:
After moving the attribute with multiple element displayed in the grid to page-by field, only one element shown in the drop-down list. Strategy Tutorial project is used to explain this behavior.
 
STEPS TO REPRODUCE:

• Create a report with Subcategory in row, Region in page-by, and Month and Revenue metric in column. Notice that there are multiple month elements came back as a result.
   
  

• Move Month attribute in page-by field. Notice that only one element is available in Month.
   
  

 
CAUSE:
This is working as designed when the sorting is specified only on the attribute which is not placed on left-most position of the Page-by field.
 
 

 
 
 
 
ACTION:
Add sorting rule to the left-most attribute as well and confirmed that all of the attribute elements are now available. In this case, add Region attribute to be sorted before Month attribute to be sorted:
 

 
 
Notice all the month elements are now available: