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

KB439532: "Leaf-Expression-Expression-Object is not found in DFCSchema during DFC conversion" error appears with MicroStrategy Developer 10.x


Mari Sugimura

Senior Cloud Support Engineer III • MicroStrategy


This article explains how to overcome the error, "Aggregation Metric Expression-Aggregation Metric-Aggregation Metric Leaf-Expression-Expression-Object is not found in DFCSchema during DFC conversion" returned when a user tried viewing SQL of a report or Intelligent Cube.

SYMPTOM:
After an Intelligent Cube object imported to another project by an Object Package created with Strategy Object Manager, "View SQL" operation of the Cube fails with following error message:
 


DSSSQLEngine: Schema loading error: Template (Local Template). -Template Unit Metrics-Template Metrics-Dimensional Metric (M). -Dimensional Metric-Dimensional Metric-Aggregation Metric (). -Aggregation Metric Expression-Aggregation Metric-Aggregation Metric Leaf-Expression-Expression-Object is not found in DFCSchema during DFC conversion..Error in Process method of Component: SQLEngineServer, Project xxx, Job xxx, Error Code= -2147212797.)

ka02R000000kUzmQAE_0EM44000000QGwU.png

CAUSE:
Schema Update was not performed after the Object Package was imported to the project. 
ACTION:
Update schema with at least following options checked:

ka02R000000kUzmQAE_0EM44000000QGwZ.png

  KB439532


Comment

0 comments

Details

Knowledge Article

Published:

January 25, 2018

Last Updated:

December 31, 2018