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

KB45339: Is it possible to calculate view filter after derived metric in MicroStrategy 9.x-10.x?


Community Admin

• Strategy


In Strategy 9.x-10.x, derived metric is evaluated after view filter. This is per design.
 
However there are workarounds to limit the number of rows displayed depending upon the report design:

  • If the view filter is on attribute, use derived element instead of view filter.
  • If the view filter is on metric, use metric limit instead of view filter.

Evaluation order on metric limit/derived element can be adjusted together with derived metric in the view evaluation order.
 
Refer to the technical note below for specific example of evaluation order of derived metric and view filter:
KB441973: Consideration for using conditional derived metrics with related filters on the report in Strategy 10.x
 
Refer to the technical note below for explanation of the evaluation order:
KB31910: What are the Data Set and View evaluation orders in the Report Data Options Evaluation Order panel in Strategy Desktop 9.x? 
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

May 16, 2017