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

KB211816: Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9.x.


Community Admin

• Strategy


Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9.x.

SYMPTOM:
Reports and Dashboards no longer display one of the two attributes that have been linked together in a VI Dashboard from cubes that are used as datasets. KB45885 describes how the link definition is redefined through overwriting. 
 
STEPS TO REPRODUCE:

  • Create Cube 1:
ka04W000000OgyCQAS_0EM4400000025v4.jpeg
  • Create Cube 2: 
ka04W000000OgyCQAS_0EM4400000025v2.jpeg
  • Create Report 1 with grid based on Cube 1 that has attribute you will link:
ka04W000000OgyCQAS_0EM4400000025v0.jpeg
  • Create Report 2 with grid based on Cube 2 that has attribute you will link:
ka04W000000OgyCQAS_0EM4400000025ux.jpeg
  • Add cube 1 as a dataset to a Visual Insight Dashboard. Then add cube to as another dataset to the same Visual Insight Dashboard.
     
  • Link the cubes through 2 attribute that have different definitions in a VI Dashboard. In this case, link "Call Ctr Id" from cube 2 with "Quarter of Year of Day Date" of cube 1:
     
  • Examine Report 1 after linking:
ka04W000000OgyCQAS_0EM4400000025v0.jpeg
  • Examine Report 2 after linking. Notice that the attribute has been removed from the grid:
ka04W000000OgyCQAS_0EM4400000025v8.jpeg

 
CAUSE:
When the two attributes are linked, one attribute is replaced by the other on the cube object itself. However this replacement only happens on the cube. The reports/dashboards that refer to the attribute that is no longer in use do not have their references updated. This leaves an invalid reference to an attribute not present on the source cube which is then removed leaving the reports/dashboards without an attribute. 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
 
WORKAROUND:
There are steps that can be taken to prevent the issue from happening in the first place by changing the workflow. This involves ensuring that all tasks that involve remapping the attributes are done before any report/dashboard creation is done. Once all VI cubes have their attributes linked that are appropriate then report/dashboard creation can be done without issue. New cubes created after this should be fine as long as they are mapped to the existing cubes before they are used in reports/dashboards.
 
If the issue has already happened then the only option is to manually re-add the attribute back to the missing dashboards and reports.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 7, 2017