SYMPTOM:
After making changes in the Warehouse tables (i.e., changing column names, adding or deleting a column, etc), if users open Strategy Developer and update the schema, those changes never take place. In the Physical View of the table in question, in the folder "Tables", users cannot see the modifications.
In the Fact editor, when selecting the columns that will be applied, the changes never occur. Users are not warned that the tables were changed. It appears that editor does not know the tables were changed.
When creating a report with a metric built upon the specific fact column changed, users receive the following error:
The QueryEngine encountered error: Call SQLExecDirect got error SQL_ERROR Too few parameters. Expected 1
CAUSE:
After any modification takes place in the Warehouse tables, the Logical Table Structure in the Strategy project must be updated along with the schema.
ACTION:
The changes must be updated in the Warehouse Catalog. To update the Logical Table Structures:
