Skip to Content
0
Former Member
Sep 30, 2010 at 06:11 AM

transformation file errors(bpc cube to bpc cube)

17 Views

Hi friends,

I'm trying to load bpc cube data to other bpc cube. Created transformation file with following options & mapping sections.

Simply i've to move from cube A to cube B(A, B are internally created transaction cube when creating BPC applications)

Cube A having around 12 dims and cube B having 7 dims. In mapping i mentioned only 7 dims because target is having 7 dims.

I think it not required to mention about other dimension in A.

*OPTIONS

FORMAT = DELIMITED

HEADER = NO

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

SELECTION=Time,2009.JUL;Category,10

*MAPPING (Target dim = source dim)

ACCOUNT=ACCOUNT

Category=Category

Entity=Entity

InputCurrency=InputCurrency

LOB=LOB

Time=Time

CIRCLE=CIRCLE

*CONVERSION

When i tried to validate and process transformation, system telling "Errors occured while loading data from other cube".

Do i add any other things/options?

thanks,