EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB14045: Error ‘A derived metric’s leaf used in this report was not selected during prompting or is not available’ occurs when executing a Report Services document in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


When a user executes a Report Services document in MicroStrategy Developer, the following error occurs: "Report processing could not be completed. An derived metric's leaf used in this report was not selected during prompting or is not available. Please edit or re-run this report so that all of the required metrica are available** Error Code=-2147212244"

SYMPTOM:
When a user executes a Report Services document in Strategy Desktop 8.x, the following error occurs:

ka02R000000kZvUQAU_0EM440000002FTx.jpeg

Error Message below:
"Report processing could not be completed. An derived metric's leaf used in this report was not selected during prompting or is not available. Please edit or re-run this report so that all of the required metrica are available** Error Code=-2147212244"
 
CAUSE:
 
This issue occurs when a metric, that is used as part of a derived metric, is removed from the report that is part of the data set.
ACTION:
If the user knows which metric was removed from the report, follow the steps below:

  1. Return the deleted metrics to the original report.
  2. Save the report.
  3. Remove the data set from the Report Services document and add it again.
  4. Execute the Report Services document.

If the user cannot determine which metric is missing or was removed from the parent report, creating the document again will prevent the reference from being lost.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 2, 2017

Last Updated:

June 2, 2017