Getting Error while activating Calculation view

[Former Member]

Dear All,  

I am getting follwing error in calculation view while activating it. Pls. help me.

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario failed: nnNumber of inputs has to be between 2 and 2(CalculationNode (Join_2) -> inputs)nnThe following errors occured: Inconsistent calculation model (34011)nDetails (Errors):n- CalculationNode (Join_2) -> inputs: Number of inputs has to be between 2 and 2.nnnn<?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createCalculationScenario" version="3"><calculationScenario name="PRAPROJECT.MODEL/SALES_CALC" schema="_SYS_BIC"><dataSources><tableDataSource name="PRAPROJECT.SALES::Product" schema="HANA" table="PRAPROJECT.SALES::Product"><attributes><allAttribute /></attributes></tableDataSource><tableDataSource name="PRAPROJECT.SALES::Region" schema="HANA" table="PRAPROJECT.SALES::Region"><attributes><allAttribute /></attributes></tableDataSource><tableDataSource name="PRAPROJECT.SALES::SALES_NEW" schema="HANA" table="PRAPROJECT.SALES::SALES_NEW"><attributes><allAttribute /></attributes></tableDataSource></dataSources><calculationViews><projection name="Product" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_NAME"/></viewAttributes><inputs><input name="PRAPROJECT.SALES::Product"  ><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="PRODUCT_NAME" target="PRODUCT_NAME"/></input></inputs></projection><projection name="Region" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_NAME"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SUB_REGION_NAME"/></viewAttributes><inputs><input name="PRAPROJECT.SALES::Region"  ><mapping source="REGION_ID" target="REGION_ID"/><mapping source="REGION_NAME" target="REGION_NAME"/><mapping source="SUB_REGION_NAME" target="SUB_REGION_NAME"/></input></inputs></projection><projection name="Sales_New" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SALES_AMT"/></viewAttributes><inputs><input name="PRAPROJECT.SALES::SALES_NEW"  ><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="REGION_ID" target="REGION_ID"/><mapping source="SALES_AMT" target="SALES_AMT"/></input></inputs></projection><join name="Join_1" type="inner"><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_NAME" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SUB_REGION_NAME" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID_1" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SALES_AMT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID_2" /></viewAttributes><inputs><input name="Region"><mapping source="REGION_ID" target="REGION_ID"/><mapping source="REGION_NAME" target="REGION_NAME"/><mapping source="SUB_REGION_NAME" target="SUB_REGION_NAME"/><mapping source="REGION_ID" target="REGION_ID_2"/></input><input name="Sales_New"><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="REGION_ID" target="REGION_ID_1"/><mapping source="SALES_AMT" target="SALES_AMT"/><mapping source="REGION_ID" target="REGION_ID"/></input></inputs><joinAttributes><joinAttribute excludeFlag="false" name="REGION_ID" /></joinAttributes></join><join name="Join_2" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_NAME" /></viewAttributes><inputs><input name="Product"><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="PRODUCT_NAME" target="PRODUCT_NAME"/></input></inputs></join><join name="Join_3" type="inner" cardinality="n:1"><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_NAME" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_NAME" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SUB_REGION_NAME" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID_1" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID_1" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SALES_AMT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="REGION_ID_2" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="PRODUCT_ID_2" /></viewAttributes><inputs><input name="Join_2"><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="PRODUCT_NAME" target="PRODUCT_NAME"/><mapping source="PRODUCT_ID" target="PRODUCT_ID_2"/></input><input name="Join_1"><mapping source="REGION_ID" target="REGION_ID"/><mapping source="REGION_NAME" target="REGION_NAME"/><mapping source="SUB_REGION_NAME" target="SUB_REGION_NAME"/><mapping source="PRODUCT_ID" target="PRODUCT_ID_1"/><mapping source="REGION_ID_1" target="REGION_ID_1"/><mapping source="SALES_AMT" target="SALES_AMT"/><mapping source="REGION_ID_2" target="REGION_ID_2"/><mapping source="PRODUCT_ID" target="PRODUCT_ID"/></input></inputs><joinAttributes><joinAttribute excludeFlag="false" name="PRODUCT_ID" /></joinAttributes></join><aggregation name="finalAggregation" defaultViewFlag="true"><inputs><input name="Join_3"><mapping source="PRODUCT_ID" target="PRODUCT_ID"/><mapping source="PRODUCT_NAME" target="PRODUCT_NAME"/><mapping source="REGION_ID" target="REGION_ID"/><mapping source="REGION_NAME" target="REGION_NAME"/><mapping source="SUB_REGION_NAME" target="SUB_REGION_NAME"/><mapping source="PRODUCT_ID_1" target="PRODUCT_ID_1"/><mapping source="REGION_ID_1" target="REGION_ID_1"/><mapping source="REGION_ID_2" target="REGION_ID_2"/><mapping source="PRODUCT_ID_2" target="PRODUCT_ID_2"/><mapping source="SALES_AMT" target="SALES_AMT"/></input></inputs><viewAttributes><viewAttribute name="PRODUCT_ID"/><viewAttribute name="PRODUCT_NAME"/><viewAttribute name="REGION_ID"/><viewAttribute name="REGION_NAME"/><viewAttribute name="SUB_REGION_NAME"/><viewAttribute name="PRODUCT_ID_1"/><viewAttribute name="REGION_ID_1"/><viewAttribute name="REGION_ID_2"/><viewAttribute name="PRODUCT_ID_2"/></viewAttributes><keyfigures><keyfigure name="SALES_AMT" aggregationType="sum"/><keyfigure name="row.count" datatype="fixed" length="18" isVisible="false" aggregationType="count"/></keyfigures><unitConversionInfos></unitConversionInfos><calculationNodeHints countStarAttribute="row.count"/></aggregation></calculationViews><variables><variable name="$$language$$" typeMask="512" isGlobal="true" usage="optional"/><variable name="$$client$$" typeMask="512" isGlobal="true" usage="optional"/></variables></calculationScenario></cubeSchema>n

[Former Member · Accepted solution]

Hi Pradeep,

Seems you have maintained only one object in your join node. If you select a join node, you should have 2 objects to set a join. It will not allow to add or join more than 2 objects in a single join node.

Regards,

Sharath

[Former Member]

Hi All,

Thank you all for the response.

Sharath b : you are correct i was trying to maintain only one object in join node because of which it was giving an error.Thank you Sharath it helped.

[former_member182302]

Hi Pradeep,

The error message says that you have more than 2 inputs to your JOIN node. Join can only take 2 inputs.

Regards,

Krishna Tangudu

[Former Member]

Hi Pradeep,

Please give details :  what are you trying out in the calculation view, so that we can help you.

Regards,

Sharath

[christianschuer]

PRADEEP KHUBA wrote:

Inconsistent calculation model (34011)nDetails (Errors):n- CalculationNode (Join_2) -> inputs: Number of inputs has to be between 2 and 2

Hi,

please have a closer look at your CalculationNode(Join_2). Did you come across the element which causes the error?

Kind regards,

Christian

[former_member226419]

Please be specific while posting query. Can you please elaborate what you trying to achieve?