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

KB484911: Fix the problem that Visualization returns no data when Security Filter is based on one attribute used in a temprelation which is generated by Data Blending with Data Engine Version 2021


Min Zhao

Quality Engineer, Principal • MicroStrategy


This article explains a scenario that fix the random data issue when Security Filter is based on one Attribute used in a temprelation which is generated by Data Blending with Data Engine Version 2021

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
Description
Starting from Strategy 10.4, there is no data returned for the Visualization in a Dossier randomly when it meets the following criteria:

  1. Multiple Datasets are used in a Dossier
  2. Two Attributes are from one Dataset
  3. There is Security Filter defined on at least one of these two Attributes
  4. There is only one join path to generate relation for these two Attributes

When checking the Query Details, user will notice the empty Relation generated for the two Attributes like:
select [Month Id]@[ID],
    [Category Id]@[ID]
to    RELATION10-<Month Id, Category Id>
Cause
This is a known issue starting from Strategy 10.4.
Solution
This issue has been addressed in Strategy 2021.
To pick up the fix, upgrade to Strategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. For more details on enabling the setting, refer to Data Engine Version.
After the fix, the data should be returned for the Visualization in the Dossier.
When checking Query Details, there should no empty Relation generated.
Strategy internal reference number for this technical note is DE151152.


Comment

0 comments

Details

Knowledge Article

Published:

March 4, 2021

Last Updated:

March 21, 2024