SYMPTOM:
The following error is thrown when multiple attributes whose ID's are based on the same column are on a report along with a metric in Strategy.
Fact group does not exist at a common level that can support the requested analysis
SQL does not generate for the report when attempting to go straight to SQL view instead of executing.
CAUSE:This is caused when the VLDB property "engine attribute role option" is set to enabled for the database instance the project uses. This causes the fact table which contains all the necessary attributes for the fact used in the metric to be split into table aliases which each only contain one of the attributes with shared IDs.
From there the fact does not see any single table containing all the needed attributes for SQL generation and throws the error message discussed above.
ACTION:Disable the VLDB property "engine attribute role option".
If the table aliases produced by that VLDB property are needed for lookup tables it will be necessary to manually create the table aliases as needed.
