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

KB483753: Description fail to display after linking MTDI cube attribute to project existing attributes


Qinyi Chen

Quality Engineer, Principal • Strategy


Before MicroStrategy 2020, when an attribute in MTDI cube is linked to a project existing attribute, while the IDs are linked correctly, the description may fail to be linked and cause the wrong display in visualization.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Symptoms

  • When a MTDI cube attribute is linked to a project schema attribute, the attribute form cannot display.

Glossary

  • MTDI  (Multi Table Data Import)  Cube

Steps to Reproduce


The following example uses the Strategy Tutorial project. 
1.    Open Strategy Web. 
2.    Create a new dossier, create 2 datasets:
a.    Create dataset DS1:
i.    Add data and choose “Existing Objects”.
ii.    Search for attribute “Quarter” in search bar and choose it. The attribute “Quarter” contains 16 rows from “2014 Q1” to “2017 Q4”.
iii.    Click add.
 

ka0PW0000001JalYAE_0EM2R000000mZoY.jpeg

b.    Create dataset DS2:
i.    Add data and choose “New Data”.
ii.    Click Clipboard and fill in the following data.

ka0PW0000001JalYAE_0EM2R000000mZod.jpeg

iii.    Click “Prepare Data” to enter the wrangle window.
iv.    Select both attributes and click “Create Multiform attribute”, Use QuarterID as ID form and QuarterDesc as DESC form.
v.    Rename the name of the attribute to “Quarter MTDI”.
vi.    Click finish to save the dataset.
3.    Right click on attribute “Quarter MTDI” in DS2, click “Link to Other Dataset” and link it to attribute “Quarter” in DS1.
4.    Add attribute “Quarter MTDI” to the visualization. Though the attribute has description “2018 Q1” for the ID “20181”, it is not displayed in the visualization. 

ka0PW0000001JalYAE_0EM2R000000mZoi.jpeg

Cause


This is a known defect before Strategy 2020.
MTDI cube and project have different configurations. MTDI cube attributes and project schema attributes have different locale setting in the description form, so when they are linked, the link only works for ID form.

Solution


To resolve this defect, please upgrade to Strategy 2020 or above, and set Data Engine Version setting to 12.
The project level setting Data Engine Version can only be enabled through Workstation. For more details on enabling the setting, see Change Data Engine Version . 
In Strategy 2020, MTDI cube locale for Description form now could match all other locales, attributes can be linked properly, and corresponding data could be displayed  correctly.

ka0PW0000001JalYAE_0EM2R000000mZpM.jpeg

Strategy Internal Reference number for this technical note is KB483753 and DE123585.
 


Comment

0 comments

Details

Knowledge Article

Published:

October 28, 2019

Last Updated:

March 21, 2024