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

KB12000: After creating a column in a logical table, automatic mapping does not occur for attributes referencing columns with the same name in MicroStrategy 9.x-10.x


Community Admin

• Strategy


SYMPTOM:
After defining a logical table and editing the attribute(s) that already reference the column(s) used in the logical table, the logical table is not listed as an available source table for the attribute form referencing the column.
 
A logical table is defined as follows with Year_ID, which is used in the Year attribute as shown in the image below:
 

ka04W000000OeotQAC_0EM440000002Fi5.jpeg

 
As shown below, the logical table is not listed as a source table for the ID attribute form when modifying the Year attribute:
 

ka04W000000OeotQAC_0EM440000002Fhu.jpeg

 
CAUSE:
This issue may occur if the column object created in the Logical Table is not identical in all aspects, including Object ID, with the column objects used for the other tables containing the same column.
 
ACTION:
Complete the following steps in the Logical Table Editor:
 

  • Remove the current column object associated with the column in the Logical Table SQL as shown in the image below:
ka04W000000OeotQAC_0EM440000002Fhs.jpeg
  • In the left-hand pane of the editor where the tables are listed, expand one of the tables presently used as a source table for the attribute form in question as shown below:
ka04W000000OeotQAC_0EM440000002Fi1.jpeg
  • Drag and drop the column object into the lower right-hand pane where the objects are defined for the Logical Table as shown in the image below:
ka04W000000OeotQAC_0EM440000002Fi7.jpeg
  • Save and close.
     
  • The logical table should now be listed as an available source table in the attribute.

 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017