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

KB11538: Does the Metric-Level or Report-Level metric join-type take precedence when executing a MicroStrategy report?


Stefan Zepeda

Salesforce Solutions Architect • Strategy


The Report-level join type setting for the metric always takes precedence over the Metric-level setting.

Consider a user who has a Metric-level join type for Revenue set to Outer, as illustrated below:

ka02R000000kY12QAE_0EM440000002Fk2.jpeg

 
The Report-level metric join type for Revenue is set to Inner:

ka02R000000kY12QAE_0EM440000002Fk4.jpeg

 
The Report-level join type setting for the metric always takes precedence over the Metric-level setting.
This enables users to have a Metric-level join type which can be inherited by any newly created report if the Report-level metric join type is set to "Default." In addition, a user still has the ability to override the Metric-level join type if he/she would like a report to use a different join type, as shown above with the Metric-level join type set to Outer and the Report-level join type set to Inner.
This gives users the flexibility to define a metric join type at the Metric-level which can be used repeatedly and inherited, but then also allows users to set on a report-by-report basis a different metric join type if their report requires it by changing the Report-level join type setting.
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017