Skip to Content
author's profile photo Former Member
Former Member

Script Logic Checker says "RECORD WRITE BACK" but no record in the request?

Hi Experts,

I got a weird problem. I try to implement a pretty simple script logic. We work on 7.5NW, SP04. When I run the logik in the Logik tester everything works fine (execute (simulate). When I execute it in the logik tester, it even says: record written back. But there are no records. Not in the report, not in the request.

It is also weird that in the section "data write back" on the very bottom of the analysis text, the tester does not specify the dimensions but only name them?

Did anybody ever had a similiar issue? This drives me crazy. Help! 😊

Regards,

Cora

LGX:

*XDIM_MEMBERSET ENTITY = entity_a
*XDIM_MEMBERSET MATERIAL = material_a
*XDIM_MEMBERSET PLANT = plant_a
*XDIM_MEMBERSET RPTCURRENCY = EUR
*XDIM_MEMBERSET SHIP_TO = Dummy
*XDIM_MEMBERSET SOLD_TO = Dummy
*XDIM_MEMBERSET TIME = 2011.JAN
*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN S_ACCT
*IS P1001
*WHEN P_DATASRC
*IS UPLOAD
*WHEN CATEGORY
*IS 30

*REC(EXPRESSION=(%VALUE%*[S_ACCT].[M1001]/[S_ACCT].[M1002]),S_ACCT=S1005)

*ENDWHEN
*ENDWHEN
*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------
LOG:

LOG BEGIN TIME:2010-10-07 23:49:05
FILE:\ROOT\WEBFOLDERS\xxxxxx \ADMINAPP\Sales\TEST.LGF
USER:xxxx\xxxx
APPSET:xxxxx
APPLICATION:Sales
[INFO] GET_DIM_LIST(): I_APPL_ID="Sales", #dimensions=11 
CATEGORY,ENTITY,MATERIAL,MEASURES,PLANT,P_DATASRC,RPTCURRENCY,SHIP_TO,SOLD_TO,S_ACCT,TIME

#dim_memberset=8 
ENTITY:3188,1 in total.
MATERIAL:10000152,1 in total.
PLANT:2411,1 in total.
RPTCURRENCY:EUR,1 in total.
SHIP_TO:Dummy,1 in total.
SOLD_TO:Dummy,1 in total.
TIME:2011.JAN,1 in total.
MEASURES:PERIODIC,1 in total.

REC :(%VALUE%*[S_ACCT].[M1001]/[S_ACCT].[M1002])

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

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:
CATEGORY	ENTITY	MATERIAL	PLANT	P_DATASRC	RPTCURRENCY	SHIP_TO	SOLD_TO	S_ACCT	TIME	SIGNEDDATA
1  RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :187.00  ms.


SCRIPT RUNNING TIME IN TOTAL:0.84 s.
LOG END TIME:2010-10-07 23:49:05

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 07, 2010 at 10:54 PM

    Hi Cora,

    First, in your *XDIM part you don't specify Dimensions S_ACCT, P_DATASRC and CATEGORY. What ranges do you expect them to have?

    Second, if resulting records are exactly same as records in the cube - nothing will be actually written back, i.e. if [S_ACCT].[M1001]/[S_ACCT].[M1002] =1 or this is not the first time you run that script nothing will be written back. Can you check if you already have such record in your Application?

    Regards,

    Gersh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 12:32 PM

    Thank you very much. You are exactly right. I had a data problem. The system calculated ZERO.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.