Skip to Content
0

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

Jan 30, 2017 at 08:40 PM

61

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Vadim Kalinin Jan 31, 2017 at 03:18 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ellora Dobbala Jan 31, 2017 at 04:05 PM
0

Screen print of Fiscal year / period from staging cube


time.jpg (29.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Ellora Dobbala Jan 31, 2017 at 04:11 PM
0

Fyi...

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 31, 2017 at 05:19 PM
0

Try 001.2016 instead of 2016001

Share
10 |10000 characters needed characters left characters exceeded
Ellora Dobbala Jan 31, 2017 at 05:42 PM
0

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 :-(

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 31, 2017 at 06:11 PM
0

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...


fisc.png (9.5 kB)
valid.png (41.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Ellora Dobbala Jan 31, 2017 at 06:25 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

The issue is not BPC 7.5, but the very old SP of BPC 7.5! SAP will recommend upgrade...

0
Ellora Dobbala Jan 31, 2017 at 06:46 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I can recommend to test SP14 - something was corrected for /CPMB/LOAD_INFOPROV_UI

1