SAP Knowledge Base Article - Public

2996854 - Filter of Date Range type doesn't work when creating model connecting to SuccessFactors in SAP Analytics Cloud (SAC)

Symptom

Filter of Date Range type doesn't work when creating model connecting to SuccessFactors in SAC

Environment

  • SAP Analytics Cloud 2020.21.8 (SAC)

Reproducing the Issue

  1. Login SAC and create model based on import SuccessFactors connection.
  2. In the query, there is default filter in it.
  3. If choose the type Effective As Of Today, the filter value is displayed successfully in the model page.
  4. If choose the type Date Range, the filter value is empty in the model page.

Cause

This behavior is by design.

Resolution

In SuccessFactors "Effective as of" field is not available as a reportable field and only acts as a filter field so we cannot add it to the report. 
"Effective as of" field is a filter field which defines the scope of data in the Report and is only applicable if we are fetching data as of “a particular” date.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, success, factor, successfactor, successfactors, filter, query , KBA , LOD-ANA-ADM , SAC Administration , Problem

Product

SAP Analytics Cloud 1.0