SYMPTOM:
Users can add a prefix to temporary tables created in the Strategy generated SQL through the VLDB Settings. Datamart tables contain their own setting for specialized prefixes to be inserted into the SQL. If a user has configured datamart tables for the report but does not specify a prefix, or does not want a prefix for the datamart, the Strategy SQL will use the table prefix designated in the VLDB settings for the datamart tables as well.
STEPS TO REPRODUCE:
1. Designate a table prefix through the VLDB settings.
This will result in the following SQL
2.Configure datamart and leave the Prefix setting blank.
This will result in the following SQL Instead of there not being a prefix for the datamart table.
ACTION:
In order to remove this prefix, add the desired prefix to the datamart configuration or add a space to the field if no prefix is desired.
