SAP Knowledge Base Article - Public

2310709 - Some functions cannot be found in Lumira Prepare Room

Symptom

  • Some functions mentioned in "SAP Lumira, desktop edition User Guide" cannot be found in Functions list in Lumira Prepare Room such as abs()
  • Got following error if manually input abs(): "Unknown function: abs. Try rewriting the formula."

Environment

  • Lumira Desktop 1.30

Reproducing the Issue

  1. Open any Lumira report.
  2. Add New Calculated Measure in Prepare Room.
  3. Abs() function cannot be found in Functions list.
  4. Manually input abs() in Formula bar.
  5. Get error:  "Unknown function: abs. Try rewriting the formula."

Cause

All functions list in the "SAP Lumira, desktop edition User Guide" are supported in the Visualize Room, but some of the function are not supported in the Prepare Room. The unsupported functions cannot be found in Functions list in Lumira Prepare Room, such as abs().

Resolution

  • Do not use abs() in Prepare Room.
  • Add New Custom Calculation in Visualize Room and abs() can be found in Functions list.

Keywords

LD, abs, miss, use, Lumira, function, prepare, visualize, 1.30, 1.29, different , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0