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
- Open any Lumira report.
- Add New Calculated Measure in Prepare Room.
- Abs() function cannot be found in Functions list.
- Manually input abs() in Formula bar.
- 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