SAP Knowledge Base Article - Public

2568599 - Ability to cast data types in calculated columns in Online Report Designer

Symptom

  • ORD: Ability to cast data types in calculated columns
  • ODS/ARB - allow calculated columns to output a 'number' column as 'text'
  • Condition contains different formula type as the return value.
  • It would be very helpful if it is possible to utilise a calculated column in the ORD to “cast” a data type.
  • For example, There is afield “Global Grade” configured in as text field (which is actually containing numeric values).
  • User wants to do some numeric conditional logic (greater than/less than etc. in If Else Statement) using “Global Grade” field
  • User may thought maybe they could just use it in a calculated field with a Numeric data type output and it would cast it as numeric, but this doesn’t allow User to compare the numeric values as the field's data type in Text.

Environment

  • Online Report Designer
  • Advance Reporting
  • Calculated Columns

Reproducing the Issue

Create a Calculated Column in ORD
Select a Field whose Data Type is Text but contains Numeric/ Integer Value
Try to apply Conditional Logic in Calculated Column
It throws an Error Message - "Condition contains different formula type as the return value"

Calculated Column.png

Resolution

This issue was reported as enhancement. Enhancement Ticket number - WFA-2825, WFA-2677.
However, both Enhancement Tickets are in Closed Status.
"Unified Query Designer" in Report Center will replace this issue reported in above mentioned enhancement ticket.
"Unified Query Designer" tool is under construction and there is no communication from Product Management regarding the Release Date of this feature.
NOTE - Support has no document/ idea regarding this new tool until this is announced by Product Management in release note in future.

Keywords

  • Online Report Designer
  • ORD
  • Calculated Column
  • Data Type
  • If Else Statement
  • Conditional Logic
  • Greater Than and Less Than
  • Cast
, KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Product Enhancement

Product

SAP SuccessFactors HXM Suite all versions