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
  3. Topics

KB38442: "Error: SQLEngine got an Exception from DFC: The incremental refresh report cannot be a MDX report when it is defined as delete by filter..." received when trying to run an incremental refresh of an MDX report as "Delete by Filter"

Community Admin

• Strategy

This article notes a limitation of MDX when used with incremental refresh delete filters

SYMPTOM:
Users get the following error message when trying to use incremental refresh, "Delete by filter", on an MDX cube report.

ka04W000000OblXQAS_0EM440000002DT1.png

 


Error: SQLEngine got an Exception from DFC: The incremental refresh report cannot be an MDX report when the MDX report is defined as "Delete by filter" Error in Process method of component: SQLEngineServer ,...

 
Note: This only occurs when using incremental refresh of type "Delete by Filter" only.
 
CAUSE: 
This is a product limitation. Incremental refresh functionality for Delete by Filter on MDX cubes is not available in Strategy. The error message above has been added to inform the user of this limitation.
 
ACTION:
Use Incremental refresh type "Delete by Report"  instead of "Delete by Filter".  With this type of Incremental refresh, any data that meets the reports definition is deleted from the cube. 
 

Comment

0 comments

Details

Knowledge Article

Published:

May 15, 2017

Last Updated:

May 15, 2017