HANA Modeler Error When Activating Analytic View in SP05

[Former Member]

Hi all,

I am working on the E2EHANATUTORIAL experiential learning and ran into an error activating a analytic view using SP05.

I was able to successfully validate and activate four of the attribute views that comprise the analytic view.

Error message:

Message :

    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 -> cube (_SYS_BIC:i834605-efashion/AN_EFASHION) -> dimensionAttributes -> dimensionAttribute (i834605-efashion/AT_ARTICLE_COLOR$ARTICLE_ID)</element><code>46</code><message>dimension 'ARTICLE_ID' is already existing</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:i834605-efashion/AN_EFASHION" registerCubeForApsFlag="true"><cubeTables><cubeTable name="I834605:ARTICLE_COLOR_LOOKUP" type="d-table"/><cubeTable name="I834605:ARTICLE_LOOKUP" type="d-table"/><cubeTable name="I834605:CALENDAR_YEAR_LOOKUP" type="d-table"/><cubeTable name="I834605:OUTLET_LOOKUP" type="d-table"/><cubeTable name="I834605:SHOP_FACTS" type="f-table"/></cubeTables><joinConditions><joinCondition name="JOIN_SHOP_FACTS_ARTICLE_LOOKUP_1" cardinality="n:1" joinType="leftOuter"><partner1 table="I834605:SHOP_FACTS" column="ARTICLE_ID"/><partner2 table="I834605:ARTICLE_LOOKUP" column="ARTICLE_ID"/></joinCondition><joinCondition name="JOIN_SHOP_FACTS_ARTICLE_COLOR_LOOKUP_2" cardinality="n:1" joinType="leftOuter"><partner1 table="I834605:SHOP_FACTS" column="COLOR_CODE"/><partner2 table="I834605:ARTICLE_COLOR_LOOKUP" column="COLOR_CODE"/></joinCondition><joinCondition name="JOIN_SHOP_FACTS_ARTICLE_COLOR_LOOKUP_3" cardinality="n:1" joinType="leftOuter"><partner1 table="I834605:SHOP_FACTS" column="ARTICLE_ID"/><partner2 table="I834605:ARTICLE_COLOR_LOOKUP" column="ARTICLE_ID"/></joinCondition><joinCondition name="JOIN_SHOP_FACTS_CALENDAR_YEAR_LOOKUP_4" cardinality="n:1" joinType="leftOuter"><partner1 table="I834605:SHOP_FACTS" column="WEEK_ID"/><partner2 table="I834605:CALENDAR_YEAR_LOOKUP" column="WEEK_ID"/></joinCondition><joinCondition name="JOIN_SHOP_FACTS_OUTLET_LOOKUP_5" cardinality="n:1" joinType="leftOuter"><partner1 table="I834605:SHOP_FACTS" column="SHOP_ID"/><partner2 table="I834605:OUTLET_LOOKUP" column="SHOP_ID"/></joinCondition></joinConditions><joinPaths><joinPath name="PATH_ARTICLE_LOOKUP_1"><joins><join name="JOIN_SHOP_FACTS_ARTICLE_LOOKUP_1"/></joins></joinPath><joinPath name="PATH_ARTICLE_COLOR_LOOKUP_2"><joins><join name="JOIN_SHOP_FACTS_ARTICLE_COLOR_LOOKUP_2"/><join name="JOIN_SHOP_FACTS_ARTICLE_COLOR_LOOKUP_3"/></joins></joinPath><joinPath name="PATH_CALENDAR_YEAR_LOOKUP_3"><joins><join name="JOIN_SHOP_FACTS_CALENDAR_YEAR_LOOKUP_4"/></joins></joinPath><joinPath name="PATH_OUTLET_LOOKUP_4"><joins><join name="JOIN_SHOP_FACTS_OUTLET_LOOKUP_5"/></joins></joinPath></joinPaths><dimensionAttributes><dimensionAttribute name="i834605-efashion/AT_ARTICLE$ARTICLE_ID"><columnMappings><columnMapping name="ARTICLE_ID" technicalName="i834605-efashion/AT_ARTICLE$ARTICLE_ID" type="key" table="I834605:SHOP_FACTS" column="ARTICLE_ID" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_ARTICLE$CATEGORY"><columnMappings><columnMapping name="CATEGORY" technicalName="i834605-efashion/AT_ARTICLE$CATEGORY" type="key" table="I834605:ARTICLE_LOOKUP" column="CATEGORY" joinPath="PATH_ARTICLE_LOOKUP_1" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_ARTICLE$FAMILY_NAME"><columnMappings><columnMapping name="FAMILY_NAME" technicalName="i834605-efashion/AT_ARTICLE$FAMILY_NAME" type="key" table="I834605:ARTICLE_LOOKUP" column="FAMILY_NAME" joinPath="PATH_ARTICLE_LOOKUP_1" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_ARTICLE_COLOR$ARTICLE_ID"><columnMappings><columnMapping name="ARTICLE_ID" technicalName="i834605-efashion/AT_ARTICLE_COLOR$ARTICLE_ID" type="key" table="I834605:SHOP_FACTS" column="ARTICLE_ID" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_ARTICLE_COLOR$COLOR_CODE"><columnMappings><columnMapping name="COLOR_CODE" technicalName="i834605-efashion/AT_ARTICLE_COLOR$COLOR_CODE" type="key" table="I834605:SHOP_FACTS" column="COLOR_CODE" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_ARTICLE_COLOR$COLOR_LABEL"><columnMappings><columnMapping name="COLOR_LABEL" technicalName="i834605-efashion/AT_ARTICLE_COLOR$COLOR_LABEL" type="key" table="I834605:ARTICLE_COLOR_LOOKUP" column="COLOR_LABEL" joinPath="PATH_ARTICLE_COLOR_LOOKUP_2" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_CALENDAR_YEAR$WEEK_ID"><columnMappings><columnMapping name="WEEK_ID" technicalName="i834605-efashion/AT_CALENDAR_YEAR$WEEK_ID" type="key" table="I834605:SHOP_FACTS" column="WEEK_ID" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_CALENDAR_YEAR$YR"><columnMappings><columnMapping name="YR" technicalName="i834605-efashion/AT_CALENDAR_YEAR$YR" type="key" table="I834605:CALENDAR_YEAR_LOOKUP" column="YR" joinPath="PATH_CALENDAR_YEAR_LOOKUP_3" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_CALENDAR_YEAR$QTR"><columnMappings><columnMapping name="QTR" technicalName="i834605-efashion/AT_CALENDAR_YEAR$QTR" type="key" table="I834605:CALENDAR_YEAR_LOOKUP" column="QTR" joinPath="PATH_CALENDAR_YEAR_LOOKUP_3" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/AT_CALENDAR_YEAR$MTH"><columnMappings><columnMapping name="MTH" technicalName="i834605-efashion/AT_CALENDAR_YEAR$MTH" type="key" table="I834605:CALENDAR_YEAR_LOOKUP" column="MTH" joinPath="PATH_CALENDAR_YEAR_LOOKUP_3" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/OUTLET_LOOKUP$SHOP_ID"><columnMappings><columnMapping name="SHOP_ID" technicalName="i834605-efashion/OUTLET_LOOKUP$SHOP_ID" type="key" table="I834605:SHOP_FACTS" column="SHOP_ID" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/OUTLET_LOOKUP$MANAGER"><columnMappings><columnMapping name="MANAGER" technicalName="i834605-efashion/OUTLET_LOOKUP$MANAGER" type="key" table="I834605:OUTLET_LOOKUP" column="MANAGER" joinPath="PATH_OUTLET_LOOKUP_4" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/OUTLET_LOOKUP$CITY"><columnMappings><columnMapping name="CITY" technicalName="i834605-efashion/OUTLET_LOOKUP$CITY" type="key" table="I834605:OUTLET_LOOKUP" column="CITY" joinPath="PATH_OUTLET_LOOKUP_4" isVisible="true"/></columnMappings></dimensionAttribute><dimensionAttribute name="i834605-efashion/OUTLET_LOOKUP$STATE"><columnMappings><columnMapping name="STATE" technicalName="i834605-efashion/OUTLET_LOOKUP$STATE" type="key" table="I834605:OUTLET_LOOKUP" column="STATE" joinPath="PATH_OUTLET_LOOKUP_4" isVisible="true"/></columnMappings></dimensionAttribute></dimensionAttributes><measures><measure name="MARGIN" table="I834605:SHOP_FACTS" column="MARGIN" aggregationType="sum" isVisible="true"/><measure name="AMOUNT_SOLD" table="I834605:SHOP_FACTS" column="AMOUNT_SOLD" aggregationType="sum" isVisible="true"/><measure name="QUANTITY_SOLD" table="I834605:SHOP_FACTS" column="QUANTITY_SOLD" aggregationType="sum" isVisible="true"/></measures><constraints/></cube></cubeSchema>'nVersion: 42n

Any and all comments are appreciated, thanks for taking the time to look over this.

Cheers,

Bryan Hang

[former_member184768 · Accepted solution]

Hi Bryan,

It would help if you can post the screenshots of AT_ARTICLE_COLOR, SHOP_FACTS and ARTICLE_LOOKUP. It seems that the ARTICLE_ID exists in all three and might be getting repeated without unique alias name associated with each of them. I am just speculating as I am not aware of the data model. Hence it will help if you can post the screenshots of these attribute views, fact tables and the joins.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravindra,

Thank you for the promptness of your response. You were, in fact, correct as the solution to this issue was nothing more than creating an alias for ARTICLE_ID.

I was able to create the alias and successfully activate the model!

Best Regards,

Bryan Hang