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

KB18873: Using report as filter does not seem to be filtering data in target report in MicroStrategy


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article notes a scenario where a report as filter does not apply to a metric calculation

SYMPTOM:
Using a report as filter does not seem to be filtering data in the target report in Strategy, as shown below:
 

ka02R000000kWLZQA2_0EM440000002V2T.jpeg

CAUSE:
Reports as a filter are essentially a local report filter and is affected in the same manner by any settings as are usual report filters. Using a report as a filter does not filter data in target report if a metric in the target report has a conditionality from the same hierarchy as the attributes on the 'filtering' report and the `Remove related filter elements option` in the Advanced condition options is checked.
 
ACTION:
To correct the issue, uncheck the `Remove related filter elements option` in the Advanced condition options, as shown below:
 

ka02R000000kWLZQA2_0EM440000002V3B.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

July 18, 2017

Last Updated:

July 18, 2017