2349252 - Error when using Shared calculated column in LMS

SAP Knowledge Base Article - Public

2349252 - Error when using Shared calculated column in LMS

Symptom

Error when using Shared calculated column in ORD Leaning LMS:

Environment

SuccessFactors HCM Core
ORD - Online Report Designer

Reproducing the Issue

  • Create calculated column using Subdomain Schema (SDS) : "Item Progress" and Save as "Item Progress Calc".
  • Create a query using the Subdomain Schema (SDS): "Learning Item Assignment and History"
  • Go to Edit > Calculated Column > Shared calculated > select "Item Progress Calc" and click on use the selected Shared Calculated Column 
  • The system returm an error message such as below: 

Error :

The formula uses column "Item Progress Calc" from table "label.Component" in SDS "Item Progress".

This is not part of the current query. Use the SDS "Item Progress" in query then try re-adding the shared calculated column "Item Progress Calc"

ErrorLMS Calc.png

Cause

Using a shared calculated column from different Subdomain Schedma.

Resolution

Only use shared calculated column from the same subdoamin schema 

Such as : Shared Calculated Column from SDS "Item Progress" in a query based on the same SDS "Item Progress"

Keywords

  • Calculated Column
  • ORD
  • Online Report Designer 
  • LMS in ORD
, KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core 1602