cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Skip dimensions when exporting transactional data to file

Former Member
0 Likes
419

Hello,

I need to customize a transformation file for exporting  transactional data to file.

BPC cube is made of 10 dimensions, I want to have only 4 in the output file.

I have *MAPPING section looking as follows:

ACCOUNT=ACCOUNT

VERSION=VERSION

INTCO=INTCO

TIME=TIME

SIGNEDDATA=SIGNEDDATA

I expect to see these five columns in my output file. However, when I run DM Package (based on /CPMB/EXPORT_TD_TO_FILE process chain), I have all dimensions in the output file (all 10 instead of expected 4).

Please advise how can I have only a specific set of dimensions in the output file and skip all other dimensions?

Thank you,

Valery

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Googled a bit more and found solution:

adding

SPECIFICMAPPING=YES

to the *OPTIONS worked like charm.

Answers (0)