Skip to Content
0
Mar 05, 2009 at 11:29 PM

Export from Fact table with own Transformation file fails

26 Views

I'm working with BPC 5.1 and am trying to create a Transformation file to use with the Export from fact table package. The transformation I've created validates and saves without any errors. However, when I run the package with the transformation, the export fails in step 2: Convert data. All the package log says is that it failed - no error messages.

Here are the parameters from my transformation file:

*OPTIONS

FORMAT = DELIMITED

VALIDATERECORDS = NO

ROUNDAMOUNT = 2

SPECIFICMAPPING = YES

*MAPPING

Time = Time

Account = Account

Brokerarea = Brokerarea

Entity = Entity

Product = Product

Saleschnl = Saleschnl

Operator = Operator

Division = Operator(1:2)

My issue appears to be with my mapping section - if I remove that, the export is successful. However, I have the mapping to meet two requirements:

1. Only export some of the dimensions, not all.

2. Add "Division" to the output - this is not a dimension in the BPC Application, but the value needed is contained in the first two characters of the Operator dimension member.

Is what I'm trying to do even possible? Does anyone have any suggestions for what I need to change in my transformation file to get it to work?

Thanks in advance!

Shannon