Error activation calculation view in hana studio

Hi, I have created a cube type calculation view that only has a projection of a calculated view.

image1.png

I have created two restricted columns, con la siguiente definition:

When I activate the view it gives me the following error.

Message :

Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed:

Invalid attribute value '' for attribute 'aggregationType'(scenario -> cubeSchema -> calculationScenario (PoC_SAC/C_COMPRASMAT) -> calculationViews -> aggregation (finalAggregation) -> keyfigures -> restrictedKeyfigure (Importecompra_Y1) -> aggregationType)

The following errors occurred: The scenario XML is not valid (2112)

Details (Errors):

- scenario -> cubeSchema -> calculationScenario (PoC_SAC/C_COMPRASMAT) -> calculationViews -> aggregation (finalAggregation) -> keyfigures -> restrictedKeyfigure (Importecompra_Y1) -> aggregationType: Invalid attribute value '' for attribute 'aggregationType'.

- scenario -> cubeSchema -> calculationScenario (PoC_SAC/C_COMPRASMAT) -> calculationViews -> aggregation (finalAggregation) -> keyfigures -> restrictedKeyfigure (Importecompra_Y2) -> aggregationType: Invalid attribute value '' for attribute 'aggregationType'.

<?xml version="1.0" encoding="utf-8"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createCalculationScenario" version="3"><calculationScenario name="PoC_SAC/C_COMPRASMAT" externalScenarioName="PoC_SAC::C_COMPRASMAT" schema="_SYS_BIC"><dataSources><calcScenarioDataSource name="B_COMPRASMAT" schema="_SYS_BIC" view="PoC_SAC/B_COMPRASMAT" resolveType="mergeScenarios"><variableMappings/><attributes><allAttribute/></attributes></calcScenarioDataSource></dataSources><calculationViews><projection name="Projection_1"><debugInfo nodeName="Projection_1"/><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Sociedad"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Sociedad_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Division"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Division_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Ejercicio"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Documento"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Periodo"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Cldocumento"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Cldocumento_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Tipo_doc"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Subtipo_doc"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Proveedor"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Prov_Ciudad"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Grupo"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Grupo_nombre"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Prov_Pais"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Mercado"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Importecompra"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Contcompra"/></viewAttributes><inputs><input name="B_COMPRASMAT"><mapping source="Sociedad" target="Sociedad"/><mapping source="BUTXT" target="Sociedad_texto"/><mapping source="Division" target="Division"/><mapping source="GTEXT" target="Division_texto"/><mapping source="Ejercicio" target="Ejercicio"/><mapping source="Documento" target="Documento"/><mapping source="Periodo" target="Periodo"/><mapping source="Cldocumento" target="Cldocumento"/><mapping source="Cldocutext" target="Cldocumento_texto"/><mapping source="Tipo_doc" target="Tipo_doc"/><mapping source="Subtipo_doc" target="Subtipo_doc"/><mapping source="Proveedor" target="Proveedor"/><mapping source="Prov_Ciudad" target="Prov_Ciudad"/><mapping source="GRUPO" target="Grupo"/><mapping source="GROUP_NAME" target="Grupo_nombre"/><mapping source="Prov_Pais" target="Prov_Pais"/><mapping source="MERCADO" target="Mercado"/><mapping source="IMPORTECOMPRA" target="Importecompra"/><mapping source="CONTCOMPRA" target="Contcompra"/></input></inputs></projection><union name="Union_1"><debugInfo nodeName="Union_1"/><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Sociedad"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Sociedad_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Division"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Division_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Ejercicio"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Documento"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Periodo"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Cldocumento"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Cldocumento_texto"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Tipo_doc"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Subtipo_doc"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Proveedor"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Prov_Ciudad"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Grupo"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Grupo_nombre"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Prov_Pais"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Mercado"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Importecompra"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="Contcompra"/></viewAttributes><inputs><input name="Projection_1"><mapping source="Sociedad" target="Sociedad"/><mapping source="Sociedad_texto" target="Sociedad_texto"/><mapping source="Division" target="Division"/><mapping source="Division_texto" target="Division_texto"/><mapping source="Ejercicio" target="Ejercicio"/><mapping source="Documento" target="Documento"/><mapping source="Periodo" target="Periodo"/><mapping source="Cldocumento" target="Cldocumento"/><mapping source="Cldocumento_texto" target="Cldocumento_texto"/><mapping source="Tipo_doc" target="Tipo_doc"/><mapping source="Subtipo_doc" target="Subtipo_doc"/><mapping source="Proveedor" target="Proveedor"/><mapping source="Prov_Ciudad" target="Prov_Ciudad"/><mapping source="Grupo" target="Grupo"/><mapping source="Grupo_nombre" target="Grupo_nombre"/><mapping source="Prov_Pais" target="Prov_Pais"/><mapping source="Mercado" target="Mercado"/><mapping source="Importecompra" target="Importecompra"/><mapping source="Contcompra" target="Contcompra"/></input></inputs></union><aggregation name="finalAggregation" defaultViewFlag="true"><debugInfo nodeName="Aggregation"/><inputs><input name="Union_1"><mapping source="Sociedad" target="Sociedad"/><mapping source="Sociedad_texto" target="Sociedad_texto"/><mapping source="Division" target="Division"/><mapping source="Division_texto" target="Division_texto"/><mapping source="Ejercicio" target="Ejercicio"/><mapping source="Documento" target="Documento"/><mapping source="Periodo" target="Periodo"/><mapping source="Cldocumento" target="Cldocumento"/><mapping source="Cldocumento_texto" target="Cldocumento_texto"/><mapping source="Tipo_doc" target="Tipo_doc"/><mapping source="Subtipo_doc" target="Subtipo_doc"/><mapping source="Proveedor" target="Proveedor"/><mapping source="Prov_Ciudad" target="Prov_Ciudad"/><mapping source="Grupo" target="Grupo"/><mapping source="Grupo_nombre" target="Grupo_nombre"/><mapping source="Prov_Pais" target="Prov_Pais"/><mapping source="Mercado" target="Mercado"/><mapping source="Importecompra" target="Importecompra"/><mapping source="Contcompra" target="Contcompra"/></input></inputs><viewAttributes><viewAttribute name="Sociedad"><descriptions><description>Sociedad</description></descriptions></viewAttribute><viewAttribute name="Sociedad_texto"><descriptions><description>COMPANY_CODE_NAME</description></descriptions></viewAttribute><viewAttribute name="Division"><descriptions><description>Division</description></descriptions></viewAttribute><viewAttribute name="Division_texto"><descriptions><description>Division_texto</description></descriptions></viewAttribute><viewAttribute name="Ejercicio"><descriptions><description>Ejercicio</description></descriptions></viewAttribute><viewAttribute name="Documento"><descriptions><description>Documento</description></descriptions></viewAttribute><viewAttribute name="Periodo"><descriptions><description>Periodo</description></descriptions></viewAttribute><viewAttribute name="Cldocumento"><descriptions><description>Cldocumento</description></descriptions></viewAttribute><viewAttribute name="Cldocumento_texto"><descriptions><description>Cldocumento_texto</description></descriptions></viewAttribute><viewAttribute name="Tipo_doc"><descriptions><description>Tipo documento</description></descriptions></viewAttribute><viewAttribute name="Subtipo_doc"><descriptions><description>Subtipo_doc</description></descriptions></viewAttribute><viewAttribute name="Proveedor"><descriptions><description>Proveedor</description></descriptions></viewAttribute><viewAttribute name="Prov_Ciudad"><descriptions><description>Prov_Ciudad</description></descriptions></viewAttribute><viewAttribute name="Grupo"><descriptions><description>Grupo</description></descriptions></viewAttribute><viewAttribute name="Grupo_nombre"><descriptions><description>Grupo_nombre</description></descriptions></viewAttribute><viewAttribute name="Prov_Pais"><descriptions><description>Prov_Pais</description></descriptions></viewAttribute><viewAttribute name="Mercado"><descriptions><description>Mercado</description></descriptions></viewAttribute><viewAttribute name="Importecompra"><descriptions><description>IMPORTE COMPRA</description></descriptions></viewAttribute><viewAttribute name="Contcompra"><descriptions><description>Contcompra</description></descriptions></viewAttribute></viewAttributes><keyfigures><keyfigure name="row.count" datatype="fixed" length="18" isVisible="false" aggregationType="count"/><restrictedKeyfigure name="Importecompra_Y1" aggregationType="" baseAttribute="Importecompra"><restriction>("Ejercicio" = '$$IP_YEAR_1$$')</restriction><descriptions><description>Importecompra</description></descriptions></restrictedKeyfigure><restrictedKeyfigure name="Importecompra_Y2" aggregationType="" baseAttribute="Importecompra"><restriction>("Ejercicio" = '$$IP_YEAR_2$$')</restriction><descriptions><description>Importecompra_Y2</description></descriptions></restrictedKeyfigure></keyfigures><unitConversionInfos/><calculationNodeHints countStarAttribute="row.count"/></aggregation></calculationViews><variables><variable name="$$IP_YEAR_1$$" sqlType="VARCHAR" typeMask="64" usage="optional"/><variable name="$$IP_YEAR_2$$" sqlType="VARCHAR" typeMask="64" usage="optional"/><variable name="$$language$$" typeMask="512" isGlobal="true" usage="optional"/><variable name="$$client$$" typeMask="512" isGlobal="true" usage="optional"/></variables><descriptions><description>C_COMPRASMAT</description></descriptions></calculationScenario></cubeSchema>

Apparently you must not like something about the definition of calculated columns, but I can't identify what it is. Could you help me?