2269412 - WFA - using a month time model in a query time context shows only last month data

A query has a month time model in the time context but is only showing the last month's data. For example, using the Last Six Months time model in the time context of a query only shows the last month's data.

 

See circled below for an example query.

A month time model is not an aggregate of months. Rather it is each individual month time period. A time context does not have the functionality to aggregate the month time model so it chooses the last month's data from the month time model.

 

There are 2 options:

1. Move the month time model to a row or column (instead of using as a time context)

or

2. Create a composite query to add the months of the month time model together

 

There may also be an option to choose an appropriate year time model as a time context (eg. Last Year if last 12 months is required)

KBA , LOD-SF-WFA , Workforce Analytics & Planning , Problem

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors Workforce Analytics 1511 ; SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1408 ; SuccessFactors Workforce Analytics 1508