Skip to Content

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

Hi,

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

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Jan 31, 2017 at 03:18 PM

    "Fiscyear/Period = 2015001 (this is a valid member in BW staging cube)" - please show screenshot of BW cube records...

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 04:05 PM

    Screen print of Fiscal year / period from staging cube

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 04:11 PM

    Fyi...

    the initial screen print was showing 2015001, however same is the case with 2016001 also.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 05:19 PM

    Try 001.2016 instead of 2016001

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 05:42 PM

    Unfortunately 'no'!

    I have tried - 001.2016,0012016, 012016, 2016.JAN (BPC format, i know it is stupidity, i thought worth a shot ;-))

    It is the case across transformation files and staging cube(s), i have extended my test to other combinations too.

    no luck :-(

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 06:11 PM

    Just tested myself with 2016001 - no issues!

    Selection:

    Validation result:

    May be you issue is the VERY old SP of BPC 7.5??? SP11 is absolutely old...

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 06:25 PM

    I know...that is what i suspect, NW 7.5

    if i go via opening case with SAP it might take some time, I am working on plan B as a work around.

    Thank you so much for your time and effort Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 06:46 PM

    Ya when i say NW 7.5 not the whole product but the version I am working on. sadly!

    anyway it is what it is!

    let me see what i can do.

    Add comment
    10|10000 characters needed characters exceeded