RQP-DEF-0564 error has occured when opening OOTB Report using SAMPLEDW
Hi
I have installed Insight1.1.1.1. (Windows2008 R2, DB2 v9.7 FP4 32bit, WAS8.0.0.2 64bit)
After succesfull installation, I opened Portfolio Management View using SAMPLEDW. Following error has occured on the report "Portfolio Investment Map".
RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed.
cogserver.log is as follow.
170.225.189.29:9080 5932 2013-01-08 02:36:55.781 +0 0 0 3600 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 5932 2013-01-08 02:36:55.781 +0 0 0 3600 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 5932 2013-01-08 02:36:55.781 +0 0 0 3600 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 7068 2013-01-08 02:36:55.781 +0 5412 RSVP 6235 1 Audit.RTUsage.RSVP StartService ReportService Success
170.225.189.29:9080 5932 2013-01-08 02:36:55.781 +0 0 0 3600 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 7068 2013-01-08 02:36:58.796 +0 BF0CDB119B3234B649CDAA103E94114D8B1D2BEF wq8dqlhyGssCCd9M4j8wCCdM4lld98j9sGwhvjh4 wq8dqlhyGssCCd9M4j8wCCdM4lld98j9sGwhvjh4 6856 RSVP 6235 1 Audit.RTUsage.RSVP Response Report ReportService Failure RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed.
170.225.189.29:9080 7068 2013-01-08 02:36:58.781 +0 0 0 6324 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 7068 2013-01-08 02:36:58.781 +0 0 0 6324 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 7068 2013-01-08 02:36:58.781 +0 0 0 6324 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 7068 2013-01-08 02:36:58.781 +0 0 0 6324 QOS 6235 1 Audit.RTUsage.QOS <message code="4027" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. </message>
170.225.189.29:9080 5932 2013-01-08 02:37:02.765 +0 BF0CDB119B3234B649CDAA103E94114D8B1D2BEF vh9h42qlvdCq8M448vlj24dsMhhsCCCqqy4Myhwd 9yChwhsCCMh4wl9l8vvddhChsG4y4v8jww9C8C4q 6448 RSVP 6235 1 Audit.RTUsage.RSVP Response ReportService Failure RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed. RQP-DEF-0564 Unable to determine fact grain of semi-additive dimension '[Dimensions].[Date]' for measure '[Dimensions].[Resource Demand Supply Metrics with Skill and Competency (Monthly)].[Total Demand]'. Verify that a relationship is defined between the underlying query subjects from which the dimensions are constructed.
Does anyone advice me ?
One answer
Looks like a defect in the FM model, I will investigate.
Please subscribe and track this workitem: RQP-DEF-0564 error has occured when opening OOTB Report using SAMPLEDW (78526)
Please subscribe and track this workitem: RQP-DEF-0564 error has occured when opening OOTB Report using SAMPLEDW (78526)