Skip to Content
Jan 30, 2017 at 08:40 PM

BPC NW 7.5 Transformation validation -Time value in selection is not in required format

98 Views Last edit Jan 31, 2017 at 03:10 PM 2 rev


System - BPC NW 7.5, SP 11

Weird situation, at least looks like!

I have a transformation file and I am trying to validate and process it after making the selection in 'Set Selection' for the time period Fiscyear/Period = 2015001 (this is a valid member in BW staging cube)

i get the below error -

"Time value in selection is not in required format for querying"

Error: Validate with data file failed

any other selection for other fields works fine, but not for time.

I have seen couple of threads on the same topic but no formal closure or solution. One of the thread discussed about Convert process in "/CPMB/LOAD_INFOPROVIDER" process chain. does this have anything to do with the step in the process chain?

Appreciate your inputs