SAP Knowledge Base Article - Public

2739085 - Issues Creating LMS Custom Reports on HANA DB

Symptom

Having issues running Custom Reports in Plateau Report Designer (PRD)? Provide your Report Developer with the code snippet and assumptions below so that they can make the required changes in their client application's logic.

Environment

SuccessFactors LMS (Learning Management System)

Reproducing the Issue

Issues creating any Custom Reports in PRD when LMS is on HANA DB

Cause

PRD needs to use below logic when connecting to HANA DB

Resolution

Assumption :
Learning_Table - name of table element in rptdesign
DataSet_Hana - name of hana specific oda-data-set
DataSet - name of oracle specific oda-data-set

<method name="beforeFactory"><![CDATA[
  importPackage(Packages.com.plateausystems.elms.framework.report.impl)
  importPackage(Packages.javax.servlet.http)
  importPackage(Packages.javax.servlet)

var reportContext1 = reportContext.getAppContext().get("REPORT_CONTEXT");
var session = reportContext1.session;
var hanaDBDialectEnabled = session.getAttribute("CustomReportHanaDBDialectEnabled");

  if( hanaDBDialectEnabled )

{     ds = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("Learning_Table")     ds.setProperty( "dataSet", "DataSet_Hana" );    }
else

{     ds = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("Learning_Table")     ds.setProperty( "dataSet", "DataSet" );    }
]]>

In existing report "HanaDBDialectEnabled" is used, in case of custom report use "CustomReportHanaDBDialectEnabled".

Keywords

HANA DB, Reporting, PRD, Plateau Report Designer, Custom Reports, LMS, SuccessFactors , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions