KB38285: "None of the selected reports can make use of Dynamic Sourcing" error message appears after analyzing reports in MicroStrategy Cube Advisor 9.2.1 even with Metric Levels logging configured properly.

SYMPTOM:
 
With Metric Levels logging configured properly, Strategy Cube Advisor 9.2.1 returns the following result after analyzing the selected reports:

 
Sample Code/Error
None of the selected reports can make use of Dynamic Sourcing
 
 
CAUSE:
 
In the Cube Advisor configuration file "CubeAdvisorConfiguration.txt", which is typically located at C:\Program Files\Common Files\Strategy, the end time is not set correctly. Below is an example of the incorrect end time entry:
 
End"0001-01-01 00:00:00.000"
 
ACTION:
 
Contact Strategy Technical Support for an update on this issue.
 
WORKAROUND:
 
Follow the steps below to work this issue around:

1. Correct the end time in CubeAdvisorConfiguration.txt. Make it match the last report execution time in Metric Level logging.
2. Follow the steps in the following technical note to run Cube Advisor in Command Line mode and load the details file from GUI.
   KB30060 - How to use Strategy Cube Advisor with Strategy Intelligence Server Universal 9.0  
   

 
The Strategy Internal Reference Number for the issue discussed in this technical note is 511294.