KB413590: “MDX Metrics are not from the same source table” error occurs when executes a normal report against two different SAP cubes from the same SAP source in MicroStrategy Desktop 9.x

SYMPTOM:
 
In Strategy Desktop 9.x, execute a normal report with metrics from two different SAP cubes, but same MDX source gets following error:
 

Error: SQLEngine got an Exception from DFC; Engine Logic: HDA-MDX internal error: MDX Metrics are not from the same source table.

 
     3.    Execute the report gets following error:
 

 
NOTE:
 

• Create separate DB instance for the SAP cubes can’t workaround this error.
• Two separate DB instances means connecting the cubes a 2nd time, creating all compound metrics a 2nd time, formatting all attributes and metrics a 2nd time, creating all mapped attributes a 2nd time. 
• The query is seen twice.

However, run reports with metrics that from two different MDX source (one from SAP, other one from TM1) could successfully get data as shown below:
 

 
 
No attribute is included in the report since there is no relative SAP data on that level. Following is the SQL view:
 

 
 
 
CAUSE:
 
This is a known issue with Strategy Desktop 9.x
 
 
ACTION:
 
Please contact Strategy Technical Support for an update with this issue.
 
The Strategy Internal Reference Number for the issue discussed in this technical note is 513019.
 
 
 
 
KB38432 KB413590