MicroStrategy preamble-heavy grid export
A grid report or dossier grid exported from MicroStrategy to CSV/Excel/text, mistaken for a plain table when it is a banner-laden, multi-subtotalled, page-by-stacked rendering whose scoping filters live only in the preamble.
The shape, how the file is really laid out
Several banner rows sit above the real header: report title and description,
the prompt answers (the filter selections that scoped this run), and an
execution timestamp, frequently merged across columns, so the banner rows have
a different column count than the grid. A page-by axis can repeat the entire
grid once per page value, each preceded by its own banner ("Region: West"),
stacking multiple grids in one file. Subtotals and Grand Totals appear at every
grouping break, labelled "Subtotal" / "Total" / "Grand Total" and interleaved
with detail; in outline mode a parent attribute is labelled once and its
children left blank (forward-fill needed). An attribute can export multiple
forms, e.g. a "Customer ID" column and a "Customer" description column for one
entity. Numbers carry display formatting (separators, currency, percent,
parentheses negatives) as text, nulls render as a configured string, and text
exports can arrive tab-delimited or in a non-UTF-8 encoding (Latin-1 / UTF-16
with a BOM).
The traps
The header is many rows down and the merged banner rows mis-align a naive parser.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: MicroStrategy / Strategy Docs, "Export a grid report" · MicroStrategy Docs, "Subtotals" and "Page-by" · MicroStrategy Docs, "Attribute forms" · MicroStrategy Docs, "Prompt details in exported reports"