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

KB40276: Logical tables are dependent on column objects even though the reference to the columns cannot be found in MicroStrategy Developer 9.4.x - 10.6


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note outlines an issue observed with logical tables that have dependencies on column objects that are no longer part of the table, in MicroStrategy Developer 9.4.x - 10.6

SYMPTOM:
Users might find that some logical tables have column object dependencies, but the references to these columns cannot be found out either directly in the table or in any schema objects that use the tables (such as attributes, facts, etc). This might be apparent when importing Strategy Object Manager package which includes logical tables without any of its dependents, and throw error messages such as:
 


The source manipulator found a missing dependency. Object: <Column id=xxxxxxx> is not found. A total of 1 object(s) need it, one of which is <Table Name>. Please turn on the log for more information.

 
CAUSE:
One possible cause for this behavior is that the column alias for attribute form(s) of one or more attribute(s) that use the logical table was changed sometime in the past. This can be done from Strategy Developer by editing the attribute and its form, and going to the 'Column Alias' tab as shown:
 

ka02R000000kaNAQAY_0EM440000002DEC.png

 
The reference to the column being used in the column alias is present in the attribute as well as the logical table from which the form expression is derived.
 
When the column alias is changed, the reference within the logical table does not get updated, which leads to the dependency on the old column alias' column.
 
ACTION:
This issue has been addressed in Strategy Developer 10.4 Hotfix 3 and 10.7. Upgrade to any of those versions to take advantage of the fix.
 


Comment

0 comments

Details

Knowledge Article

Published:

May 4, 2017

Last Updated:

May 4, 2017