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