Unable to activate Calculation View by Table User Defined Function

[#1]

Hi Experts,

I am using Table UDF in a projection node in a calculation view. I have below errors when try to activate it. But if I run the Table UDF in SQL console as SELECT * FROM ...(the Table Function name) I don't have any issues.

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

Mapped source attribute h_rank is missing in node _SYS_SS2_RETURN_VAR_(calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (h_rank))

The following errors occurred: Inconsistent calculation model (34011) Details (Errors):

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (h_rank): Mapped source attribute h_rank is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (tree_size): Mapped source attribute tree_size is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (parent_rank): Mapped source attribute parent_rank is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (h_level): Mapped source attribute h_level is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (is_cycle): Mapped source attribute is_cycle is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (is_orphan): Mapped source attribute is_orphan is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (node_id): Mapped source attribute node_id is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> inputs -> input (ztf_function_area_hierarchy) -> mappings -> mapping (parent_id): Mapped source attribute parent_id is missing in node _SYS_SS2_RETURN_VAR_.

- calculationNode (finalProjection) -> attributes -> attribute (h_rank): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0. - calculationNode (finalProjection) -> attributes -> attribute (tree_size): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0.

- calculationNode (finalProjection) -> attributes -> attribute (parent_rank): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0.

- calculationNode (finalProjection) -> attributes -> attribute (h_level): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0.

- calculationNode (finalProjection) -> attributes -> attribute (is_cycle): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0. - calculationNode (finalProjection) -> attributes -> attribute (is_orphan): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0.

- calculationNode (finalProjection) -> attributes -> attribute (node_id): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0. - calculationNode (finalProjection) -> attributes -> attribute (parent_id): Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0.

Thanks,

Yufei

[yufei_zhao · Accepted solution]

Hi all,

It was because the fields are case sensitive. Changed all fields names to upper case and then the calculation view works.

Thanks,

Yufei

[Gunter · Accepted solution]

Thanks for that answer! Helpful!

[former_member638754 · Accepted solution]

Hello,

Thanks for sharing. I am facing the exact same issue :).

However I have a doubt. Did you make the fields upper-case only in the CV or in TF as well?

Thank you 🙂

[yufei_zhao · Accepted solution]

Hi, when define the table function, make sure you use all upper case for the return table.

[former_member638754 · Accepted solution]

Yes I got it. Thank you 🙂