on 02-12-2013 8:31 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.