Data Type Mismatch Error in Calculation View

[#1]

Hi, 

I am trying to union a BW table and a ECC table in my calculation view. I am getting the following error,

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario: failed aCalcEngine.createScenario(): The following errors occured: Inconsistent calculation model (34011)nDetails (Errors):n- CalculationNode (Union_1): Datatype fixed12.3(15) of QUANTITY does not match to datatype fixed14.3(17) of attribute QUANT_B in node XXXXXX.n- CalculationNode (Union_1): Datatype fixed11.2(13) of SUBTOTAL does not match to datatype fixed15.2(17) of attribute SUBTOT_5S in node XXXXXXX

I tried creating a target field in the union(with predefined data type). I am not able to find any 'note' or forum discussions regarding this.

Can someone help me with this?

Regards,

Benedict

[lbreddemann]

sumit.gupta : Sorry to tell you this, but besides the point that you resurrected a six-year old thread, you also came up with a way to solve the problem that isn't really good.

With the use of a UDF you do add quite a lot of overhead to every query execution where the converted columns are used. And that for something as simple and straight-forward as a type-cast.

Benedicts original solution - simply casting the columns to the desired data type in a projection - is correct and most effecient (if changing the underlying table is not an option).

I would highly recommend to review your solution and remove the scalar function if it does nothing more than changing the data type via casting.