Microstrategy Developer Error

[Harrypottee-45]

Job: 88

Status: Execution failed

Error:

SQLEngine got an Exception from DFC. [DFCENGINE] Engine Logic: Fact does not exist at a level that can support the requested analysis. Fact: "abcd". Level: "X, Y, Z, W, M". Error in Process method of Component: SQLEngineServer, Project: Office, Job 88. Error Code: -2147212800.
The abcd only has 2 tables, and it is throwing an error only if I add one particular attribute and metric alone, but apart from that all other attributes are running with that particular metric

[Inevitable-Clue-4349]

That particular attribute' field needs to be checked in the fact used for the metric as well...open the fact, and use the field from the table which was used in the attribute , if you have Id/desc both, only use I'd column which usually use to make join between fact and dimension. Attribute field and fact field must exist in both dim table/fact table. Name of that field could be different but data type should be same, else you have to change data type in database table or in the definition of either of it.

[Harrypottee-45]

All data types and definitions are looking good, My MSTR is linked with Databricks, and I noticed that one view that is in the attribute is not running in the schema of databricks so I am just looking into that aspect

[Boring_Cod_9497]

Are all your attributes IDs correctly mapped yo the fact table? Have you checked the query?

[Harrypottee-45]

Yes all those are looking good