BPC 10 Standard Export Functionaliy (Trans./Conv. file help)

[Former Member]

Hi all,

I have 2 questions about transformation and conversion file which I need for the export of transactional data to file:

1. Is it possibile to extract the property of a dimension member ?

eg.

Master Data DIM 1

DIM1	Property
A	green
B	blue
C	yellow

Transactional Data Output File

DIM1	DIM 1 Property	DIM2	…	AMOUNT
A	green	X		10
A	green	Y		15
C	yellow	Z		20

2. In the output file I want to merge two dimension member in one; so in the mapping section of the transformation file I have this:

OUTPUTFIELD=DIM1+*STR(_)+DIM2

And I want to skip the record based on the value of DIM2 but I can't. In the conversion file I tried this:

Value of DIM2 I want the record to be skipped = GGG

External	Internal
*_GGG	*skip

But it doesn't work.

Thanks,

Michele

[Former Member]

you can probably fix your issue and avoid using the * by putting an IF THEN statement in your transformation file where you do the concatenation.

[Former Member]

Hi Michele,

The standard package doesn't cater for your requirements, what you can do is by using end routine in your transformation file, and use BADI to do what you are required to do.

Andy

[bishwajit_das]

Hi,

Standard BPC Export of transactional data to file will not allow:-

1. Exporting PROPERTY

2. SKIP during export is possible but may not be joining.\

If you have some complex logic to export you can use BADI to export the transaction data as a flat file.

Regards,

Bishwajit

[Former Member]

Hi Bishwajit,

what do you mean by:

2. SKIP during export is possible but may not be joining.\

Regards,
Michele

[bishwajit_das]

I meant joining of dimensions is not possible during export....but SKIP can be used if you want to filter out some of your dimension members.

Regards,

Bishwajit

[Former Member]

Actually the join works. It's the skip that doesn't work. I mean it works in this simplified case:

external	internal
GGG	*skip

working

But if I use an "*" in the external field it doesn't filter out anything:

external	internal
*_GGG	*skip

not working

Regards,

Michele

[bishwajit_das]

You can choose the members while passing the values into the prompt for the Export DM package.

It could be a based on some property(which u can create)

Or else, you have to maintain the member ID in the conversion file to SKIP.

Regards,

Bishwajit

[former_member186338]

Hi Michele,

Please provide FULL conversion file!

Vadim

[Former Member]

Hi Vadim,

here it is:

Regards,

Michele

[former_member186338]

Only one line? And *_NA is equivalent of *_GGG?

Have to work...

Vadim

[Former Member]

Yeah only one line:

eg

DIM1	DIM2	JOIN (in the output file)
XXX	NA	XXX_NA	this must be skipped
YYY	ROL	YYY_ROL
ZZZ	VOL	ZZZ_VOL

What is wrong?

Thanks,

Michele

[former_member186338]

What if:

*_NA*

[former_member186338]

Just tested the same!

Works fine with condition like *_NA

Vadim

[Former Member]

I just tried again but no way.

I put another line in the conversion file just to verify that something works and it works this part and it skips correctly but the line with the "*" doesn't work.

Regards,

Michele

[former_member186338]

Then please, provide full real text of your transformation file, BPC core SP level, BW SP...

Have to repeat - in my test it's working fine for *_XXX, where XXX contain only alphanumerical characters.

Vadim

[former_member186338]

Sample:

Result:

Without *skip:

Vadim

[Former Member]

System:

-BW 7.31 SP10

-CPMBPC 8.01 SP04

Transformation:

Conversion:

as I said in the previous post the second line in the conversion works, but not the first.

Regards,
Michele

[former_member186338]

Try to upgrade to the recent SP.  In my case for CPMBPC 800 SP14 everything is working fine!

Vadim

[Former Member]

Unfortunately I can't do that.

Anyway thanks to everyone for helping out.

Regards,

Michele

[former_member186338]

By the way, for export you have to use special parameter for delimiter:

OUTPUTDELIMITER=;

And validate transformation for export!

Vadim

[Former Member]

I had that too, I took it out because I was desperately trying to make it work by copying your transformation file .

Regards,

Michele

[former_member186338]

There is nothing specific with my transformation and conversion file Skip is simply working.

Vadim