KB14547: How to expand all page-by fields in an HTML document for MicroStrategy Narrowcast Server 9.x - 10.x

In Strategy Developer, it is possible to export a report with page-by attributes to HTML and have all of those page-by attributes expanded. This is done by editing the export options for HTML and checking the 'Expand all page fields when exporting data' option. In Strategy Narrowcast Server, it is not possible to use a linked document to select a report and set the file type as HTML. Further, when using a Strategy Narrowcast Server HTML document, there is no option to expand all page-by fields in the information object.
 
In order to simulate the behavior of the export from Strategy Developer, follow the steps below when setting up the Strategy Narrowcast Server service:

• Use a linked document when selecting the report, as shown below:
  

• After selecting the report, make sure to set the document format as Excel, as shown below:
  

• Click on 'Advanced Properties.'
  
• Make sure 'Expand all pages' is selected, as shown below:
  

• Click OK.
  
• Click OK again.
  
• Use a Strategy Narrowcast Server control document to rename the file type from Excel to HTML, as shown below:
  

• Use the appropriate syntax for renaming the file/attachment inside the control document, as shown below:
  File Syntax:
  

  
  SaveDocumentAs='OLD_NAME.EXT=NEW_NAME.EXT'

  
  Email Syntax:
  

  
  ChangeAttachmentName='OLD_NAME.EXT=NEW_NAME.EXT'

  
   
  

NOTE: The above example is for the File Information Transmitter, but the same steps can be followed for other Information Transmitters. The syntax of the control document must be changed for the appropriate information transmitter. More information on control documents can be found in the Help section of the control document editor.