Date Function Error

[Former Member]

Hello,

I am trying to calculate Goods movement date and used DATE Function "Between" to find out the dates between BUDAT and Current Date/System Date(used date function NOW().

between(BUDAT,AGEING_DATE)

Validate syntax doesn't show any error, however while activating view I am getting below error:

Message :

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Analytic View (CV): nnAttribute 'aging_day' is missing in node finalAggregation(CalculationNode (finalAggregation) -> attributes -> calculatedAttribute (GOODS_MOVEMENT_DATE) -> expression)nnThe following errors occured: Inconsistent calculation model (34011)nDetails (Errors):n- CalculationNode (finalAggregation) -> attributes -> calculatedAttribute (GOODS_MOVEMENT_DATE) -> expression: Attribute 'aging_day' is missing in node finalAggregation.n- CalculationNode (finalAggregation) -> attributes -> calculatedAttribute (GOODS_MOVEMENT_DATE) -> expression: Attribute 'budat' is missing in node finalAggregation.nnDetails (Warnings):n- cubeSchema: Default language not set. Use 'en'.nnnn<?xml version="1.0" encoding="utf-8"?><cubeSchema version="3" operation="createCalculationScenario"><calculationScenario name="Inventory_Aging/AV_INVENTORY_AGING_PER_SITE" schema="_SYS_BIC"><dataSources><olapDataSource name="dataSource" schema="_SYS_BIC"

Any inputs are highly appreciable.

BR

Vijaya

[Prabhith]

Hi @Vijaya Lakshmi,

Could you please check this part of the error message in detail:

Error:Deploy Analytic View (CV): nnAttribute 'aging_day' is missing in node finalAggregation(CalculationNode (finalAggregation

BR

Prabhith

[Former Member]

Hello Prabhith,

I have created a calculated column "AGING_DAY" and assigned function "now()".  This function validiation is success.

The other function "between"(BUDAT, AGING_DAY), this is also validation is success.

While activating the view I am getting error.

[Former Member]

Hi,

There is a data type mismatching, wich resulted in above error, rectified by self.

BR

Vijaya