HI EXPERT

[Micheal-sorial]

I am use lookup to retrieve data from model to another in debugger I see correct data but in report data don't appear until I enter any number and save to data retrieved appear 

[Former Member]

Hi Michael,

1. try build a new report with all base members that matches your data record in debug

2. check data access profile and make sure you have read access

Andy

[Micheal-sorial]

thnx for reply

but my access data is admin for all data

I want explain my issue not in logic script coz I retrieve my target data right but this data not update in the epm report until I put any value in the cell data retrieved  in it and press save the data I put it don't save but the data I wont retrieve it appear

[former_member186338]

Please do not violate forum rules:

4. Avoid slang. ...

Vadim

P.S. Your issue is absolutely not clear without samples!

[Micheal-sorial]

my issue is that the data does not appear in the report only after I change anything in the report and click save in this case only the data I call it in script logic appears correct

LOG FILE.txt.zip

[former_member186338]

Your script code is wrong!

*REC(EXPRESSION = LOOKUP(DESTPLANT2),DEGPC_REFIN = QUNTITY)

will run only if you already have some record for this intersection! You have to use push, not pull!

Please post script (not lgx) and explain the logic you want to achieve...

And please read:

Vadim

Please close your previous open discussions!

[Micheal-sorial]

HI Vadim

what did you mean (use push ,not pull)

[former_member186338]

"what did you mean (use push ,not pull)":

EXPRESSION = LOOKUP(...) - PULL

*XDIM_MEMBERSET DEGPC_PROD=...

...

EXPRESSION=%VALUE%, DEGPC_PROD=target - PUSH

Please post script (not lgx) and explain the logic you want to achieve...

Please close your previous open discussions!

Vadim

[Micheal-sorial]

thnx Vadim

this logic file

LOOKUP Q 23-3.txt.zip

[former_member186338]

Use script in the model MEGPC_OPER

Use *DESTINATION_APP to push data to the target model!

And I can recommend to implement RUNLOGIC_PH badi to clear data in destination cube before pushing data from source cube.

Hope it's clear...

Vadim

[former_member186338]

P.S. Not related to the solution, but this code in LOOKUP is absolutely incorrect:

*FOR %LOOP_DEGPC_PROD%=%PROD%

*DIM LOOKOPER:DEGPC_PROD="%LOOP_DEGPC_PROD%"

*NEXT

*FOR %LOOP_DEGPC_FINALSIT%=%P%

*DIM LOOKOPER:DEGPC_FINALSIT="%LOOP_DEGPC_FINALSIT%"

*NEXT

*FOR %LOOP_DEGPC_TIME%=%TIME%

*DIM LOOKOPER:DEGPC_TIME="%LOOP_DEGPC_TIME%"

*NEXT

Same label for the same dimension repeated - meaningless

[Micheal-sorial]

this code loop for many dimension in variant lookoper but I an not used this variant in my code

[Micheal-sorial]

I think I can't used destination _app coz must specific member for *add_dim and I do not want that

[former_member186338]

Please, try to understand the basic things:

By default WHEN/ENDWHEN loop process ONLY existing records (transaction data mode).

You can switch it to master data mode with:

*WHEN_REF_DATA = MASTER_DATA

But it will be terribly slow! Not recommended..

And DESTINATION_APP will do the job! Please explain your issue with specific member, not clear!

Vadim

[former_member186338]

Anyway, even not used - it's incorrect! You can have only single line with particular label and particular dimension in lookup.

[former_member186338]

Sorry, but absolutely not clear!

What do you mean by lookup? What do you mean by debugger? Which report you are using? Screenshots...

Vadim

[Micheal-sorial]

thnx for reply

lookup syntax

debugger (ujkt)

report I creat it in epm add in

[former_member186338]

Show full text of your script and UJKT log! And the report screenshot. Impossible to help without this info!