Is there a query that can be run in the Query Tool to show the relationship between the logical entity and attribute and the physical table and column? Generating a report using the Report Designer, the presence of a logical only attribute causes the columns in the report to be out of sync from that point forward. In other words, when the logical only attribute appears, the column name shows the next column name and not a blank.
Please use this Query in the Query Tool.
SELECT TRAN(En.Name) 'Entity Name', CASE WHEN At.IS_PHYSICAL_ONLY = 'T' THEN '' ELSE TRAN(At.Name) END AS 'Attribute Name', TRAN(En.Physical_Name) 'Table Name', CASE WHEN At.IS_LOGICAL_ONLY = 'T' THEN '' ELSE TRAN(At.Physical_Name) END AS 'Column Name' FROM M0.Entity En INNER JOIN M0.Attribute At ON [email protected] = [email protected];
An example of the output is...