A problem when Loading transaction data with user define dimension

[#1]

Hello, Expert,

I have just create one new dimesion that get information from infoobject 0SEGMENT of BW into the dimension SEGMENT.

When I load transaction data,I validate transformation file, I see the error:

I check on BW, I can see this infoObjects.

and I go to Package edit, go to edit, I go to Modify script ---> Constants,

I see that Only 9 constant dimension is displayed in that like :

Name                                             Value

%ACCOUNT_DIM%                         ACCOUNT

%CATELOGERY_DIM%                    CATELOGERY

....

....

but I didn't see:

%SEGMENT_DIM%                         SEGMENT  ----> Missing this line is root of problem?

If yes, Please tell me how can I add this line on list of constant?

DO you know what can I do?

Thank you very much for you help

Best regards

Chinh Pham

Message was edited by: Pham Chinh Thi

[Former Member]

Hi,

Are you executing the standard DM package for loading transaction data from BI to BPC?

Are you executing the /CPMB/LOAD_INFOPROVIDER or /CPMB/LOAD_INFOPROV_UI?

Can you please share the advanced script of the DM package you are using?

[Former Member]

Hi Nilanjan,

Thank you for your reply,

I am executing /CPMB/LOAD_INFOPROV_UI,

Actually, I am not modify anything in DM Package, but I see like this:

#################

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

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

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",0,{"Append","Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"0","1","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

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

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

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

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

###########################

but I goto section : "Constants" in the left of dialog Modify script

I didn't see the constant for SEGMENT dimension.

Do you see that it is unsual?

Thanks

Chinh Pham

[Former Member]

Hi Pham,

some time ago you were working on the elimination of Internal profit. did you manage to get very far? Was the data taken from Product costing?

Really need some help

[email protected]

Kind Regards

Lucy

[Former Member]

Hi Pham,

I am not sure if you have found the solution or not, if you are still looking for a solution for this problem, then pelase click on "Rejected List" on the above "Validation Status" dailog box and you will be able to see the reason as to why the validation is failing.

If the above action does not solve the problem please share the "Rejected List" screen shot. Also, share the transformation file.

Regards,

Kalyan.

[Former Member]

At this time, I checked the "rejected list" but can not see nothing.

I can not share for you any sreen shot because I found the other solution. I follow one line in IFRS starter Kit document that separate entity for each segment if one more entity belong to one segment