loading bw infobject with hierarchy to bpc dimension

[michele_medaglia5]

Dear Bpc Friends

I have the infoobject 0costelmnt and I am running in BPC the package for loading the master data

If I run the package without specify the hierarchies in the tab I have a warning (see below)

If I run the package for loading the master data but I specify the hierarchies in the tab I have a failed (see below)

FAILED

Task name MASTER DATA SOURCE:

An exception with the type CX_SY_RANGE_OUT_OF_BOUNDS occurred, but was neither handled locally, nor declared in a RAISING clause

Subfield access (offset = 0, length = 25) to a data object of size 0 outside valid limits.

model: COSTS. Package status: ERROR

WARNING

Task name MASTER DATA SOURCE:

No records are returned from 0COSTELMNT

Record count:                                                 0

Task name TEXT SOURCE:

Record count:                                             72181

Task name CONVERT:

No 1 Round:

End routine is called in convert

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 0

Task name MASTER DATA TARGET:

Submit count: 0

Task name TXT DATA TARGET:

Submit count: 0

model: COSTS. Package status: WARNING

[Former Member · Accepted solution]

Hi Michele,

Please provide screen shot of your transformation file, selection screens.

Andy

[michele_medaglia5 · Accepted solution]

Hi

I have tried to process the transformation file with file and it is ok

If I run the package that call the transformation file I have the error above reported

thanks

Michele

The transformation file is:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

ENDROUTINE=Z0CZ_BADI_PA_SOP_FR_BPC_004

*MAPPING

ID=*STR(CE_)+ID

SOURSYSTEM=0SOURSYSTEM

CO_AREA=0CO_AREA

CODE=ID

CATEGORY=0CSTELMNTYP

RATETYPE=*STR(AVG)

SCALING=*STR(Y)

ACCTYPE=*STR(EXP)

*CONVERSION

CODE=CF_BI_M_02_CE.xls!CODE

Conversion file

27FR00*

*

Package

PROMPT(MASTERSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject 0COSTELMNT and the selection",,)

'PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})

'PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

'PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)

'PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%TEMPNO4%,%INCREASENO%)

INFO(%TEMPNO5%,%INCREASENO%)

INFO(%TEMPNO6%,%INCREASENO%)

INFO(%TEMPNO7%,%INCREASENO%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,0)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,0)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\PA_SOP_FR_10\COSTS\DATAMANAGER\TRANSFORMATIONFILES\TF_BI_M_03_COST ELEMENT.xls)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,COST_ELEMENT)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,COST_ELEMENT)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,2)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,0)

TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,COST_ELEMENT)

[Former Member · Accepted solution]

Hi Michele,

You have an endroutine, you need to see what the end routine is doing.

Andy

[michele_medaglia5 · Accepted solution]

yeah but the endroutine work well when I process the transformation file with data

why I have the error when running the package?

what that error could mean?

[Former Member · Accepted solution]

Do you have a empty member in your info object?

[michele_medaglia5 · Accepted solution]

I don't think so

I am loading again in BW the master data

[michele_medaglia5 · Accepted solution]

Hi

I have ran the process chain that run the bpc package and it works

thanks