KB484781: Executing documents with dynamic text or html container in the Detail section results in a blank page if there is a derived unit in the dataset in MicroStrategy Web 2020 Update 2

Description

When running a document with dynamic text or html container in the Detail section in Strategy Web, a blank page is returned if there are derived units in the datasets. The dynamic text does not show in the document. 
 

For other similar cases, the document throws the following error message when executed in Web:
No such interface supported

Steps to reproduce 

• Create a new document with the sample file, "Airline Sample Data," in Strategy Web. 
  

• Create a derived attribute based on Month and change the data type to String. 
  

• Add the dynamic text {Year} to the Detail section.
  

• Run the document. A blank page displays and the dynamic text does not show in the document. 
  

Why is this happening? 

This is a problem exposed in documents with the introduction of the feature for optimizing memory usage for derived objects during document execution.
 

Solution 

This issue has been addressed in Strategy 2020 Update 3 and Strategy 2021. 
 
After upgrading to Strategy 2020 Update 3 or Strategy 2021, you should not experience this issue. However, you may experience performance degradation for documents with dynamic text or html container in the Detail section with a derived unit in the dataset. SQL and data remains unchanged. 
 

Workaround

In Strategy 2020 Update 2, there is an option to disable the Optimize memory usage of derived objects setting.