Could you help me regarding this invalid data within xth_data ??.

[former_member187400]

Dear All,

Could you kindly share me your experience to solve this case please .. ?

I have a problem when i'm using exit function. The data transfered to xth_data variable is invalid (not same like what displayed in layout).

The exit function belong to Level: Input Production .

In one planning area, I have 2 level:

1. Level: Input Production

It has char:

cal_year, cal_month, category, machine, market, mill, version

KF: Amount Sales, Capacity.

2. Level: Input Capacity Machine.

It has char: cal_year, cal_month, Machine, Mill, version.

KF: Capacity.

The steps to trigger the error:

A.

I Input 5 Records in the level: Input Production.

=> the xth_data is still valid (data transfered to xth_data equals to data displayed in the layout).

B.

I Input 90 Records in the level: Input Capacity Machine.

C.

I have exit function in the planning level: Input Production. This objective to do some calculation for Amount Sales.

But why in this point, the xth_data has the invalid data ??? I mean, i can see the abundant data within xth_data ???

This data is beyond what we see in the layout at Planning Level: Input Production.

Why can it happen ?

Could you kindly help me to figure out this please .. .

Best regards,

Niel.

[Former Member · Accepted solution]

Hi,

when we build layout, we restrict each characteristic either in the level or layout, so that we can identify one record. But when we create an exit function in the level, this will have all the data as per the level selections. But layout will have more restricted data. So you will see more data in xth_data than layout data.

Ex: say level is restricted to all periods from 1 to 12.

but one data column in the layout is restricted to only january..

so you will see only jan record in the layout.

But if we create an exit function in the same level, xth_data will have data for all periods. This data is not invalid data as you said. If you want to do manipulations only on the data that is displayed in the layout, you have to loop over xth_data only for those records which are in the layout. There will be some differentiating characteristic definetely.

Hope this is clear.

Bindu

[former_member187400 · Accepted solution]

Hi Bindu,

Tks a lot for your response ..

So from your response, i need to filter it if i want to get the data that equals to what i see in the layout .

Could i make it in init function bindu ?

And other questions,

When i'm debugging, the number of subset in xth_data is different, when i modify field to be changed.

e.g.

If i fill 3 or 0 characteristic in "field to be changed", the data will show up 1 records.

But if i fill in all characteristic, the data will show up more than 1000 records.

Could you kindly explain me why it can happened ? Especially if i modify the characteristic within "field to be changed" ..

What's the relationship between field to be changed with xth_data ??

Still need your help bindu ..

Regards,

Niel.

[Former Member · Accepted solution]

Hi,

You can change only those records in the exit which are been displayed in the layout. For this first we shud recognize those records and loop over xth_data only for those records.

Say level has one characteristic char1 which is not restricted.

But in the layout it is restricted by a variable var1. So in the layout you are planning for var1. and u want to do calculations in exit only for var1 of char1.

For this read the value of var1 in init fm, loop over xth_data in exit fm where char1 = var1 and do the manipulations only on these records.

General practice is if we are changing any of the characteristic inside exit code, you should keep this char in fields to be changed otherwise it throws up error.

Bindu

[former_member187400 · Accepted solution]

Thanks a lot all for your responses.

Rewarded point has been forwarded as my appreciation to you all.

Regards,

Niel.