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

KB42252: Report returns "No data exists for the criteria you selected" when multiple return values are passed to system prompts (LDAP attributes) in MicroStrategy 10.x.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


Report returns "No data exists for the criteria you selected" when multiple return values are passed to system prompts (LDAP attributes) in MicroStrategy 10.x

SYMPTOM:
Steps to reproduce:

  1. Link an LDAP attribute to a system prompt LDAP attribute in Strategy Desktop as in KB35069 "How to link LDAP attributes to system prompt LDAP attributes in Strategy Developer 10.x? "
  2. Within the LDAP directory, for user A, modify the attribute to contain 2 values, e.g. "001, 002".
  3. Create a report in Developer that filters based on the system prompt. 
  4. Login to Strategy with user A's credentials and try to run the report. Notice that the report returns "No data exists for the criteria you selected."
  5. Switch to SQL view and note that in the WHERE clause, the LDAP attribute filter returns a list of numbers, which are inserted into report SQL as e.g. ('001, 002') instead of (001, 002) or ('001', '002').

CAUSE:
Currently Strategy does not support multiple return values for system prompts.
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
WORKAROUND:
Configure the LDAP directory to only have one return value for the attribute for each user.


Comment

0 comments

Details

Knowledge Article

Published:

May 30, 2017

Last Updated:

May 30, 2017