epm10: Logic and Transfert between APP

[Former Member]

Hi experts,

Does someone can help me please.

I wrote that logic, that seems to be very simple, but any data are written I suspect a trouble in the select statement...

*SELECT (%SOURCEACCOUNT%,[ID],TACCOUNT,"[SALES]='Y'")

*XDIM_MEMBERSET TIME=2012.01

*XDIM_MEMBERSET TACCOUNT=%SOURCEACCOUNT%

*DESTINATION_APP = Finance

*SKIP_DIM = Product

*WHEN TIME

*IS "2012.01"

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

*COMMIT

Error in UJKT :

LGX:

*XDIM_MEMBERSET TIME=2012.01

*XDIM_MEMBERSET TACCOUNT=PL010,PL020,PL100,PL110,PL120,PL200,PL300

*DESTINATION_APP = Finance

*SKIP_DIM = Product

*WHEN TIME

*IS 2012.01

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\DEMO \ADMINAPP\Sales\TEST.LGF

USER:BI_1

APPSET:DEMO

APPLICATION:Sales

[INFO] GET_DIM_LIST(): I_APPL_ID="Sales", #dimensions=9

AUDITTRAIL,CATEGORY,COUNTRY,CUSTOMER,MEASURES,PRODUCT,RPTCURRENCY,TACCOUNT,TIME

#dim_memberset=2

TIME:2012.01,1 in total.

TACCOUNT:PL010,PL020,PL100,PL110,PL120,...7 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 204.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :29.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 4  RECORDS ARE GENERATED.

UJK_EXECUTION_EXCEPTION:Data records rejected when writing to the cube

Tks for your help,

Rgds,

Olivia.

[Former Member]

Hi Olivia,

Please ensure that you match the dimensions using the SKIP, ADD, and RENAME statements.

Hope this helps.

[Former Member]

Hi,

Tks for your reply.

I finally solved this by myself 🙂

Tks,

Rgds,

Olivia.

[Former Member]

Hi Olivia,

I'm having a similar problem like you. Could you mind sharing what fix that u did?

Thanks for you help.

Regards

[Former Member]

Hi Muhammad,

- Could you please share your logic first ?

- Did you try it through BPC for Excel by launching your package ?

If Yes, do you have log to share ?

In my case, it was working in Excel, not with UJKT Transaction.

Hope it helps,

Regards,

Olivia.

[Former Member]

Hello Olivia,

Here's my code:

*XDIM_MEMBERSET ORG_COST_OBJECT = %ORG_COST_OBJECT_SET%
*XDIM_MEMBERSET GROUP_ACCOUNT = %GROUP_ACCOUNT_SET%
*XDIM_MEMBERSET DOCTYPE = %DOCTYPE_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET VERSION = %VERSION_SET%
*XDIM_MEMBERSET CURRENCY = %CURRENCY_SET%

*DESTINATION_APP = SPEND_FINANCE
*SKIP_DIM= ORG_COST_OBJECT
*ADD_DIM BUSINESS_AREA=ORG_COST_OBJECT:BA
*ADD_DIM FUNCTIONAL_AREA=ORG_COST_OBJECT:FA
*ADD_DIM FINANCIAL_OWNER=ORG_COST_OBJECT:FO
*ADD_DIM PROFIT_CENTER=ORG_COST_OBJECT:PCTR
*ADD_DIM ORG_SUB_MRU=ORG_COST_OBJECT:MRU
*ADD_DIM COST_CATEGORY=ORG_COST_OBJECT:COSTCAT
*ADD_DIM COST_POOL=ORG_COST_OBJECT:CP
*ADD_DIM COUNTRY=ORG_COST_OBJECT:ISO_DESC

*WHEN TIME
*IS *
*FOR %LTIME% = $TIME_TGT$
*REC(FACTOR = 1, TIME = %LTIME%, VERSION = $VERS_TGT$)
*NEXT
*ENDWHEN

No, I just run it in UJKT. Not in Excel yet.

[Former Member]

Hi Olivia,

I ran in DM package and had the same error.

LOG BEGIN TIME:2012-05-07 06:32:53
FILE:\ROOT\WEBFOLDERS\FPS\ADMINAPP\SPEND_OPS\COPY_OPS_TO_FIN.LGF
USER:21697767
APPSET:FPS
APPLICATION:SPEND_OPS
[INFO] GET_DIM_LIST(): I_APPL_ID="SPEND_OPS", #dimensions=7
CURRENCY,DOCTYPE,GROUP_ACCOUNT,MEASURES,ORG_COST_OBJECT,TIME,VERSION

#dim_memberset=6
ORG_COST_OBJECT:AE00001087,1 in total.
GROUP_ACCOUNT:UNKNOWN,1 in total.
DOCTYPE:7Z,1 in total.
TIME:2012.01,1 in total.
VERSION:FLASH_NOV,1 in total.
CURRENCY:AED,AED_INUSD,AFN,AFN_INUSD,ALL,...262 in total.

REC :%value%*(1)
REC :%value%*(1)

CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 575.62 ms. 1  RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :178.92 ms.
2  RECORDS ARE GENERATED.
CALCULATION END.

ENDWHEN ACCUMULATION: 2  RECORDS ARE GENERATED.
LOG END TIME:2012-05-07 06:32:56

/CPMB/MODIFY completed in 0 seconds
/CPMB/DEFAULT_FORMULAS_LOGIC completed in 4 seconds
/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

SELECTION = /FPS/SPEND_OPS/PRIVATEPUBLICATIONS/21697767/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:DOCTY...
TIME_TGT = /FPS/SPEND_OPS/PRIVATEPUBLICATIONS/21697767/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:TIME|...
VERS_TGT = /FPS/SPEND_OPS/PRIVATEPUBLICATIONS/21697767/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:VERSI...

[Message]

--------------------------------------------------------------

RUN_LOGIC:Data records rejected when writing to the cube

model: SPEND_FINANCE. Package status: ERROR

[Former Member]

Hi Muhammad,

In your case, I try the following :

- Without any FOR / NEXT to simplify the logic and trace the problem

- Try adding a FOR for your Version Dimension

- Try by replacing your _SET Dimension in your X_DIM_MEMBERSET, except your TIME Dimension

For each, in UJKT, see if the result well translates all dimension...

Please, could you also share your result of your UJKT-T ?

Rgds,

Olivia.

[Former Member]

Hi Olivia,

Seems like is data issue..

I tried to hardcode values first and its working..

I noticed that some values in the properties are small caps as actually they should be huge caps like the in the dimension.

Thanks!

[former_member210696]

What about the dimensions in source and target application. Are they same?

You will have to ensure the correct mapping of dimensions between two applications, for which you might have to use keywords like *SKIP_DIM, *ADD_DIM, *RENAME_DIM, etc.