KB30097: Exporting to Excel from MicroStrategy Developer does not export all the data when there is an attribute in the page-by

SYMPTOM
Exporting to Microsoft Excel from Strategy Developer 9.4.1 and 10.x does not export all of the report data when there is an attribute in the page-by.
 
CAUSE
By default, Strategy only exports the first page of the page-by.
 
ACTION
To change the export option, do the following:

• In the report editor, go to the 'Data' menu.
• Select 'Export Options'.
• Select MS Excel Worksheet.
• Check the box next to 'Expand all page fields when exporting data'
   
  

KB30097