Error when joining Attribute View to Data Foundation in Analytic View

[Former Member]

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

[former_member185171]

Jordan,

did you get an answer to this question?

I have the same problem and I have the impression that in an analytical view you cannot have tables in the CUBE that do not have any MEASURES.

In you case you have a measure for TEST:DATA but not for _SYS_BI:M_TIME_DIMENSION.

And the first on is an 'f-table' and the other a 'd-table' in the XML.

  <cubeTables>

   <cubeTable name="TEST:DATA" type="f-table"/>

   <cubeTable name="_SYS_BI:M_TIME_DIMENSION" type="d-table"/>

  </cubeTables>

This is my join:

  <cubeTables>

   <cubeTable name="DATA_SLT_D11220:FMIFIHD" type="d-table"/>

   <cubeTable name="DATA_SLT_D11220:FMIFIIT" type="f-table"/>

   <cubeTable name="DATA_SLT_D11220:PRPS" type="d-table"/>

  </cubeTables>

I get the error on FMFIHD and PRPS - also 'd-table' ...

Any advice?

Thanks.

Kris

[Former Member]

Hi Jordan,

Apart from the above steps mentioned by Ravi and Raj. Please check if you can Generate Time Data from the Quick Launch. This may create the required tables if they are absent.

--

Shreepad

[rindia]

Hi Jordan,

As suggested by Ravindra, first check whether you can do the data preview on SYS_BI.M_TIME_DIMENSION.

If yes then look whether Attribute view is based on this table and again check whether can you do the data preview on this. Still not a problem then in the analytic view check to which fact table you are joining the attribute view. Both the data types and size should match else you might get error while validation/activation of view.

Still this does not help, please post the screenshot with data type and size of joining attributes.

Regards

Raj

[former_member184768]

Hi Jordan,

I did not face such issue ever with the M_TIME_DIMENSION. Can you please check if the table is valid and you can view the data from the table.

Also can you please confirm your Studio and HANA database revisions.

Regards,

Ravi