Symbols can not be used in BPC

[former_member605329]

Hi people!

I have a question to do because I have a problem with one member in SAP BPC when i try to send a package for taking data from BW.

What type of symbols in BPC can not be used??

My problem is that I have a ID member that start and end with asterisk (*) and when i try to skip all of them with a conversion file, BPC doesn't erase these member.

This is part of the conversión file that i used:

External              Internal

*ACV*                 *SKIP

*ESM*                 *SKIP

*ESMI*                *SKIP

*                          js: %external%.replace(" ","").replace(*-+.,"")

Thanks for the support and for help me!!

[bishwajit_das · Accepted solution]

Hi,

As an asterisk (*) stands for ANY character, while a question mark (?) stands for any SINGLE character, so (*) won't work.

You could have used something like this:-

External              Internal

?ACV?                *SKIP

?ESM?                *SKIP

?ESMI?               *SKIP

Regards,

Bishwajit

[former_member605329 · Accepted solution]

Thanks for the answer

I put the question mark (?) in the conversion file but it doesn't work yet

After your answer, I thought that the solution is to put this sentence:

External       Internal

"*ESM*"       *SKIP

But it doesn't work....

Regards,

Jose Blesa

[Former Member · Accepted solution]

Hi Jose,

In your Set selection button - selection tab, find customers in your cube then you can specify something like below. it will skip all the * members.

Andy

[bishwajit_das · Accepted solution]

Hi Jose,

If you find no options to SKIP these members, you can use ROUTINE BADIs which can be called using Transformation file ( -> OPTIONS - > STARTROUTINE /  END_ROUTINE =.)

Do find the link for How to write routines in BPC :-

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50c39fa1-6f95-2d10-2a95-b594de8e1...

Regards,

Bishwajit

[former_member185511]

bro no neeeeed

always look for ABAP alternate due to flexiblity and for future need

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50c39fa1-6f95-2d10-2a95-b594de8e1...

u can create a customization table for the members to be excluded. you can use wildcards, direct ID anything.

"My Mama always said, 'Script logic was like a box of chocolates; you never know what you're gonna get. Always go for ABAP'"
(Tom Hanks, Forrest Gump (1994))

[bishwajit_das]

Hi Bilen Cekic,

Please go through earlier posts, the ABAP option has already been recommended.

Kindly avoid repetition!!

Regards,

Bishwajit

[former_member185511]

calm down champion. 

[bishwajit_das]

Its ok...if you share yours " box of chocolates"

Wishing you Merry Christmas...

Regards,

Bishwajit

[former_member186338]

Do you really have a member like *xxxx* ? May be it's better to correct (remove) this member on the BW side?

Vadim

[former_member605329]

Hi!

It is true. I'm with you. But i can not change this mistake....

Any idea?

Thanks for the advice

Regards,

Jose Blesa

[former_member186338]

"But i can not change this mistake...." - But the person responsible for BW can

You can't skip this member, but you can convert it with javascript to some dummy member!

Vadim

[former_member186338]

Something like:

js: %external%.toString().substring(0,1)=="*" ? "DUMMY" : %external%.toString().replace(/[\ \-\+\.\*]/g,""))

Vadim

[former_member605329]

Hi Vadim

First of all, thanks for help me.

I tried with your last sentence, but it is not working. I don't know why you wrote DUMMY in the sentence, can you explain me, please?

I need to erase the asterisk in three members in the ID of 0CUSTOMER dimension. I don't know if i need to put DUMMY or "_" or " ". But if i try to *SKIP the members writing for example. *ESM* in EXTERNAL column and *SKIP in INTERNAL column , BPC doesn't erase and accept the data.

Dimension: 0CUSTOMER

0CUSTOMER       COUNTRY

*ESM*                     US

*ESMI*                    US

*ACV*                     ES

When I try to running all the package that i did, BPC specified that its not valid transaction data.

People responsible BW want not change this symbols.

Thanks so much for help me

Regards

Jose Blesa

[former_member186338]

What do you want to do with data coming with members *XXX?

With my code, if you create DUMMY customer - the data will be loaded to this DUMMY customer...