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

KB40273: In MicroStrategy Developer 9.4.x and 10.x a Last Year transformation is not applied if defined as "One to One" and the attribute is present in the Filter definition but not in the Report objects.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


In MicroStrategy Developer 9.4.x and 10.x a Last Year transformation is not applied if defined as "One to One" and the attribute is present in the Filter definition but not in the Report objects.

 
SYMPTOM:
 
In Strategy Developer 9.4.x and 10.x a Last Year transformation is not applied if defined as "One to One" and the attribute is present in the Filter definition but not in the Report objects, as shown below:
 

ka02R000000kcHIQAY_0EM440000002D9A.png

 
 
If the attribute is present in the Report objects the Last Year Transformation is applied as shown below:
 

ka02R000000kcHIQAY_0EM440000002D99.png

 
 
CAUSE:
 
This is a known issue in Strategy Developer 9.4.x and 10.x.
 
ACTION:
 
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
 
Set the Last Year transformation as "Many to Many" whilst the attribute is present in the filter definition but not in the report objects.   
 
  
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

May 16, 2017