Strategy ONE
Exporting Report Results from MicroStrategy: Export Engine
The table below summarizes the Export Engine VLDB properties. Additional details about each property, including examples where necessary, are provided in the sections following the table.
| Property | Description | Possible Values | Default Value |
|
GUID of Attributes in Profit and Loss Hierarchy (Separated By ':') that has Dummy Rows to be Removed |
Lets you identify attributes that include empty elements, which can then be ignored when exporting to Microsoft Excel or to a PDF file. |
A list of attribute ID values, each one separated using a colon (:). |
NULL |
GUID of Attributes in Profit and Loss Hierarchy (Separated By ':') that has Dummy Rows to be Removed
GUID of attributes in profit and loss hierarchy (separated by ':') that has dummy rows to be removed is an advanced property that is hidden by default. For instructions on how to display this property, see Viewing and Changing Advanced VLDB Properties.
The GUID of attributes in profit and loss hierarchy (separated by ':') that has dummy rows to be removed VLDB property lets you identify attributes that include empty elements, which can then be ignored when exporting to Microsoft Excel or to a PDF file. This is useful when creating financial line item attributes as part of supporting a financial reporting solution in MicroStrategy. For a detailed explanation of how to support financial reporting in MicroStrategy, along with using this VLDB property to identify attributes that include empty elements, refer to the Project Design Help .
To identify attributes that include empty elements, type the ID value for each attribute in the text field for this VLDB property. To determine the ID value for an attribute object, navigate to an attribute in Developer, right-click the attribute, and then select Properties. Details about the attribute, including the ID value are displayed.
If you need to identify multiple attributes as having empty elements, separate each attribute ID using a colon (:).
Levels at Which You Can Set This
Project only