Transformation File for Transactional Data Load from /CPMB/ object Fails

[johannes_knaub4]

Dear Folks,

we are running on BPC 10.1 on HANA Standard Version.

As a startng Point, we migrated BPC 7.5 MS Data into a BPC NW Environment, lets call ist "HIST".

Now we trying to import Data from "HIST" into "NEW" Environment.

Thereby, we are facing an issue in the transformation file with following statement:

DIM1"NEW" = *IF(DIM1HIST (1:2) = *STR(AB) THEN DIM1HIST; DIM2HIST)

We have worked with similar Statements for BW Objects in BPC context, and it worked fine. But with /CPMB/... Objects, it seems to be differently.

The error Message is "Unexpected ' ' at position...", but it does not really make sense, as also the space before "Then" is "unexpected", and deleting all spaces results in an error message too.

Does anyone see a syntax error or similar?

Thanks

Johannes

[Former Member]

Hi Johannes,

Could you please list all the dimension names of HIST and NEW environment for a particular model you are trying to load data? Also give the screenshots of the error and transformation file.

[former_member186338 · Accepted solution]

Just tested the same with standard environmentshell copy:

CATEGORY=*IF(/CPMB/QDD88BR(1:2)=*STR(Ac) THEN /CPMB/QDD88BR; /CPMB/QDD88BR)

No issues!

P.S. *STR(Ac) - first 2 characters from "Actual"

[Edim]

Hi Johaness,

did you solve it? I have exactly the same issue. Is it concerned to the SP version?

Thanks in advance,

Edim

[former_member186338]

Please open a new question and provide full info!

[former_member376695]

Done. The question title is 'Unexpected ' ' at position XX in transformation file. *IF THEN formula'

Thanks everyone for your answers

[former_member186338]

"Done" ? Sorry, I don't see a new question in this tag!

[former_member376695]

Sorry, the question is with tag 'SAP BusinessObjects Planning and Consolidation for Public Sector'. I was not able to open it in this tag (maybe I did something wrong)

The question number is 233890

thanks

[former_member186338]

Please edit question and select correct tag! I will not answer questions with incorrect tags...

[former_member376695]

Done. Sorry about the inconvenience

[johannes_knaub4]

Do you see any difference between your and my statement?

Any Idea why this happens?

Could it be related to installation or SP27 on Office 2010?

[former_member186338]

"Could it be related to installation or SP27 on Office 2010?" - to my mind the probability is low...

But you can always test it - uninstall SP27 and install previous.

P.S. I am performing my test also on SP27 🙂

[johannes_knaub4]

Hi Vadim,

the Transformation File looks like this:

[former_member186338]

Can you show the screenshot of the transformation file?

In the error I can see:

*IF(CPMB/D2DRHHX(1:2)

Missing "/" before CPMB

[former_member186338]

P.S. It's not related to EPM SP!

[johannes_knaub4]

Hi Vadim, Hi Priyanka,

thanks for your answer, unfortunately this is a typing error in this example.

actually the complete statement is like this:

FUNCTIONAL_AREA = *IF(/CPMB/D2DRHHX(1:2) = *STR(IP) THEN /CPMB/D2DRHHX; /CPMB/D2DF21G)

Whereas

/CPMB/D2DRHHX = BUSINESSPARTNER in HIST

/CPMB/D2DF21G = ACCOUNT in HIST

The error message is

[line 19] Unexpected ' ' at position 23 in the mapping formula [*IF(CPMB/D2DRHHX(1:2) = *Str(IP) THEN...

Position 23 would be the space before "="

removing the space results in Error in Position 24 which is the space after "="

removing this results in Error in Position 28 which is the space before "THEN"

removing this results in Error Unexpected "IP"

So not really helpfull.

Any idea, could it be EPM SP (we are on SP 27 Patch 1) related?

Comment:

The Transformation File looks ok, if I replace the Statement for Functional_area, it works as it should.

Best regards

Johannes

[former_member186338]

*IF(DIM1HIST<incorrect space!>(1:2) = *STR(AB) THEN DIM1HIST; DIM2HIST)

[former_member186338]

P.S. Please read help here:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm?frame...