Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Appendix B

This appendix contains information on the calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator, and the calculated field patterns that are not supported.

Calculated Field Patterns for RapidDecision Data Source

Supported Calculated Field Patterns

The calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator are as follows:

Unique Expressions
TRIM(DataModel[COMPANY.COMPANYLEVEL01CODE])&" - "&TRIM(DataModel[COMPANY.COMPANYLEVEL01]
DataModel[PAYMENT_TERMS.DISCOUNTPERCENT]/100.0
DataModel[FACTS_DETAILS.GLPOSTEDCODE] = ("P")
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] = "AA"
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] IN ("AA", "BA")
DataModel[FACTS.RDTRANSTYPENUMID] IN (1,2)
DataModel[ACCOUNT.ACCOUNT] >= "4000" && DataModel[ACCOUNT.ACCOUNT] <= "4999.99999999"
TRIM(TRIM(DataModel[SOFACTS.ITEMNUMBER03]))
TRIM(CONVERT(DataModel[PAYEE.ADDRESSNUMBER], STRING))&\"-\"&TRIM(CONVERT(DataModel[PAYEE.ALPHANAME], STRING))
CONVERT(DataModel[FACTS.ORDERNUMBER], STRING)
SUM(DataModel[APFACTS.DISCOUNTAVAILABLE]) - SUM(DataModel[APFACTS.DISCOUNTTAKEN])

Unsupported Calculated Field Patterns

The calculated field patterns that are not supported for RapidDecision data source-based reports in the Angles for Oracle Generator. are as follows:

Expression, expression containing a keyword, expression with a keyword, or date calculated fields
Expression SUM(1) is not supported
Expressions containing @Select, @Prompt, @Variable, or meta are not supported
Expression with related keyword is not supported
Expression with (CASE keyword is not supported
Expression with SUM(( keyword is not supported
Expression with SUMX keyword is not supported
Date calculated fields such as Calculated Fields.Yesterday, Calculated Fields.Today, Calculated Fields.Tomorrow, Calculated Fields.PY Today are not supported

Published:

Appendix B

This appendix contains information on the calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator, and the calculated field patterns that are not supported.

Calculated Field Patterns for RapidDecision Data Source

Supported Calculated Field Patterns

The calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator are as follows:

Unique Expressions
TRIM(DataModel[COMPANY.COMPANYLEVEL01CODE])&" - "&TRIM(DataModel[COMPANY.COMPANYLEVEL01]
DataModel[PAYMENT_TERMS.DISCOUNTPERCENT]/100.0
DataModel[FACTS_DETAILS.GLPOSTEDCODE] = ("P")
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] = "AA"
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] IN ("AA", "BA")
DataModel[FACTS.RDTRANSTYPENUMID] IN (1,2)
DataModel[ACCOUNT.ACCOUNT] >= "4000" && DataModel[ACCOUNT.ACCOUNT] <= "4999.99999999"
TRIM(TRIM(DataModel[SOFACTS.ITEMNUMBER03]))
TRIM(CONVERT(DataModel[PAYEE.ADDRESSNUMBER], STRING))&\"-\"&TRIM(CONVERT(DataModel[PAYEE.ALPHANAME], STRING))
CONVERT(DataModel[FACTS.ORDERNUMBER], STRING)
SUM(DataModel[APFACTS.DISCOUNTAVAILABLE]) - SUM(DataModel[APFACTS.DISCOUNTTAKEN])

Unsupported Calculated Field Patterns

The calculated field patterns that are not supported for RapidDecision data source-based reports in the Angles for Oracle Generator. are as follows:

Expression, expression containing a keyword, expression with a keyword, or date calculated fields
Expression SUM(1) is not supported
Expressions containing @Select, @Prompt, @Variable, or meta are not supported
Expression with related keyword is not supported
Expression with (CASE keyword is not supported
Expression with SUM(( keyword is not supported
Expression with SUMX keyword is not supported
Date calculated fields such as Calculated Fields.Yesterday, Calculated Fields.Today, Calculated Fields.Tomorrow, Calculated Fields.PY Today are not supported

For an optimal Community experience, Please view on Desktop
Powered by Zendesk