MicroStrategy ONE
Removing sections that do not have metric data
Before you begin
You should understand how datasets are joined in a document. For background information, see Using datasets in documents.
Steps to remove sections that do not have metric data
A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. For example, a document contains two dataset reports. Dataset 1 contains Year and Revenue, with data for three years (2026-2028). Dataset 2 contains Year and Profit, filtered to return data for only two years (2027 and 2028). If you place Year and Profit in the Details and execute the document, it displays three rows, although no profit data exists for 2026. This is a product of the cross join between the two datasets.
|
Year |
Profit |
|---|---|
|
2026 |
|
|
2027 |
$1,740,085 |
|
2028 |
$2,249,397 |
You do not want to see the blank line for 2026 since it does not give you any data for profit. You can select the Trim the sections for which no data was available (this applies only to metric values) check box. This removes the row for 2026, since no metric data for Profit is available for 2026. The results are shown below:
Year | Profit |
|---|---|
2027 | $1,740,085 |
2028 | $2,249,397 |
An alternative solution is to define Dataset 2 as a primary dataset and Dataset 1 as secondary. For instructions and details, see Defining datasets as primary or secondary.
For an additional example, see the Document Creation Help.
To remove sections that do not have metric data
Open the document in the Document Editor. How?
From the Format menu, select Document Properties. The Document Properties dialog box opens.
Select Advanced.
Select the Trim the sections for which no data was available (this applies only to metric values) check box.
Click OK to return to the Document Editor.