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

Key Analytics and Mobility Applications for Sales


Diego Patterson

Account Executive • MicroStrategy


MicroStrategy analytical and mobility sales enablement solutions help companies optimize every aspect of their sales operation from any location.

SYMPTOM
In Strategy Secure Enterprise 10.x, it is seen that the view filter is not applied as in earlier versions for attributes with NULL IDs.
Consider a report with an attribute 'A' that contains 2 elements with NULL IDs, but different DESC data.  

  • One element (call it a1) has ID = NULL and the corresponding DESC = NULL
  • The second element (call it a2) also has ID = NULL and the DESC = Not Assigned.

When creating a report with the following view filter, element a2 is excluded as expected, but the element a1 with NULL DESC is also not seen on the grid. 


A NOT IN LIST “Not Assigned”

In Strategy 9.4.1, the behavior was different where only attribute a2 was not displayed on the grid. 
 
CAUSE
This is working as designed in Strategy 10.x. A design change has been implemented in Strategy Secure Enterprise 10.0 where data with NULL ID is excluded from the dataset (Null Checking option doesn't take effect for filter evaluation).
 
ACTION
An enhancement has been logged with Strategy to modify this behavior. Strategy will continue to investigate and post updates as soon as they are available.
Users should also take advantage of the Ideas Exchange to comment further on the enhancement.
 
WORKAROUND:
Add an “OR” condition for attribute form ID “Is Null” to add the Null (AttributeID) Null (AttributeDESC) value back as shown below:

ka04W000000OfmZQAS_0EM440000002C1O.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

May 17, 2017

Last Updated:

May 17, 2017