KB7120: ’SQLEngine got an Exception from DFC: [DFCENGINE] Engine Logic: Fact does not exist at a level that can support the requested analysis.’ error message appears when running a report in MicroStrategy Developer 9.4.x - 10.x

Salesforce Solutions Architect • Strategy

This technical note documents an issue that occurs when running a report in MicroStrategy Developer 9.4.x - 10.x

SYMPTOM:
When users run a report in Strategy Developer, they see the following error message:
'SQLEngine got an Exception from DFC: Engine Logic: Fact does not exist at a level that can support the requested analysis.

CAUSE 1:
The data requested does not exist in the warehouse at that level.

Example:
In the Fact_Table below, Dollar_Sales_Promotion only exists at the Year level.

Fact_Table:

The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326
The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326
The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326

If the template has Date and Dollar_Sales_Promotion, Strategy Engine will not be able to return data for this level.

ACTION 1:

Modify the schema tables to add the lowest level of the hierarchy (Date) in the fact table.
CAUSE 2:

This error message also appears when the parent/child relationship between the attributes in one hierarchy is not established correctly.

Example:

The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326
The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326
The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326	The Strategy Technical Support Team Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326

The relationship between the attributes in the Time hierarchy should be: Year > Date where Year is the Parent and Date the Child.
If, by mistake, Date is set to be a parent of Year and the template has Year and Dollar_Sales, then the report will return the same error message.

ACTION 2:

Edit the attribute. In the 'Parent/Child' tab, re-define the attribute's parent and child according to the schema.

IMPORTANT:
If the attributes in the fact table and the attributes on the template have no parent-child relationship whatsoever, the SQL Generation Engine will not present the "fact does not exist..." error message. Instead, it will generate a cross join to the attribute(s) that are not related to the fact table. This is by design. The correct relationship between unrelated attributes is a Cartesian product.
The "Fact does not exist..." error occurs when one or more of the fact table keys are related to one or more template attributes, and the template level is lower than the fact table level.
It may also occur if many-to-many relationships are not modeled correctly in the warehouse, or if the VLDB property "Dimensionality Model" is set to "Dimensional Model." (This VLDB property should normally be set to "Relational Model.")

Comment

0 comments

Details

Knowledge Article

Published:

April 4, 2017

Last Updated:

April 4, 2017