Skip to Content
0
Former Member
Nov 29, 2013 at 04:32 PM

Error when joining Attribute View to Data Foundation in Analytic View

38 Views

Hi I get the error below when activating the Analytic View where I'm trying to join an Attribute View to the Data Foundation Table. Thanks.

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Analytic View: SQL: column store error: <?xml version="1.0" encoding="utf-8"?><createCubeResult version="1.0"><status><message>The scenario XML is not valid</message><errorCode>2112</errorCode></status><details><errors><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (DATE_SQL)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (ACTUALDATE_YEAR)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (ACTUALDATE_QUARTER)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (ACTUALDATE_MONTH)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (ACTUALDATE_CALQUARTER)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail><detail><element>cubeSchema -> cubes -> cube (_SYS_BIC:TEST/Q1ACC) -> characteristics -> dimension (ACTUALDATE_CALMONTH)</element><code>41</code><message>Referenced join path '_SYS_BI:M_TIME_DIMENSION' does not have table '$2$' as endpoint</message></detail></errors></details></createCubeResult>nCreate OLAP Scenario statement: CREATE OLAP SCENARIO '<?xml version="1.0" encoding="utf-8"?><cubeSchema version="3" operation="createHanaCube"><cube name="_SYS_BIC:TEST/Q1ACC" registerCubeForApsFlag="true"><cubeTables><cubeTable name="TEST:DATA" type="f-table"/><cubeTable name="_SYS_BI:M_TIME_DIMENSION" type="d-table"/></cubeTables><joinConditions><joinCondition name="JOIN_M_TIME_DIMENSION_DATA_2" cardinality="1:1" referentialIntegrity="true" joinType="inner"><partner1 table="_SYS_BI:M_TIME_DIMENSION" column="DATE_SQL"/><partner2 table="TEST:DATA" column="SHIPDATE"/></joinCondition></joinConditions><joinPaths/><dimensionAttributes><dimensionAttribute name="TEST/SHIPDATE_TIME$DATE_SQL"><columnMappings><columnMapping name="DATE_SQL" technicalName="TEST/SHIPDATE_TIME$DATE_SQL" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="DATE_SQL" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE_YEAR"><columnMappings><columnMapping name="ACTUALDATE_YEAR" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE_YEAR" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="YEAR" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE_QUARTER"><columnMappings><columnMapping name="ACTUALDATE_QUARTER" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE_QUARTER" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="QUARTER" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE_MONTH"><columnMappings><columnMapping name="ACTUALDATE_MONTH" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE_MONTH" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="MONTH" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE_CALQUARTER"><columnMappings><columnMapping name="ACTUALDATE_CALQUARTER" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE_CALQUARTER" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="CALQUARTER" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE_CALMONTH"><columnMappings><columnMapping name="ACTUALDATE_CALMONTH" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE_CALMONTH" type="key" table="_SYS_BI:M_TIME_DIMENSION" column="CALMONTH" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$ACTUALDATE"><columnMappings><columnMapping name="ACTUALDATE" technicalName="TEST/SHIPDATE_TIME$ACTUALDATE" type="key" table="TEST:DATA" column="SHIPDATE" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="TEST/SHIPDATE_TIME$SALESDOC_NO"><columnMappings><columnMapping name="SALESDOC_NO" technicalName="TEST/SHIPDATE_TIME$SALESDOC_NO" type="key" table="TEST:DATA" column="SALESDOC_NO" isVisible="true"/></columnMappings></dimensionAttribute></dimensionAttributes><measures><measure name="QTY" table="TEST:DATA" column="QTY" aggregationType="sum" isVisible="true"/><measure name="ORDER_QTY" table="TEST:DATA" column="ORDER_QTY" aggregationType="sum" isVisible="true"/></measures><constraints/></cube></cubeSchema>'n