Skip to Content
0
Apr 17, 2012 at 09:07 AM

epm10: Logic and Transfert between APP

14 Views

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.