Agentry how to restrict particular complex table in initial load

[Former Member]

Hi Expert,

In Agentry application how to restrict/disable particular complex table while initial load?

Is there any possible to get that particular complex table records whenever we want?

Thanks,

Vijay

[former_member197782]

Hi Vijay,

The complex table data download may differ from device to device means the platform.

In ATE, the CT with huge data download would not take much time it will get downloaded in 2-4 Mins max.

But the same cannot be downloaded in iPad, it will definitely consume much time depends on the amount data is it is getting.

The CT data download based on the filters configured in CT MDO and the indexes maintained in Agentry editor.

If you want to improvise the performance of CT download in initial sync, please try to apply filters on MDO.

For delta sync, try modifying the TABLE_CHECK & TABLE_REFRESH parameters for particular complex table.

Before modifying these parameters, please analyze the frequency of master data update for CT in ECC. According to that you can set up the value.

NOTE: Applying filters will reduce the no.of records to download, but this will again depends on the business requirement.

Hope this helps!.

Thanks,

Roopa.

[Former Member]

Hi Roopa,

Thanks for the clarification.

Vijay.

[sudhiranjan_lenka]

Hi Vijay,

Please find my comments below.

In Agentry application how to restrict/disable particular complex table while initial load?

     :- Use staging table for that CT and clear the staging table before doing an initial transmit.

Is there any possible to get that particular complex table records whenever we want?

    :- In the config panel there is a field Table_check for that complex table. Instead of hard-coding this field use rule(Use rule option) which will decide the CT need to be checked or not while transmiting.

Please let  me know your exact business requirement, will try to help you out.

Thanks,

Sudhir.

[Former Member]

Hi Sudhir,

Thanks for your response.

where I need to use rule for CT? I mean which config panel SAP or SMP Admin?

Business requirement : We have bulk data downloading using Complex Table. It is taking 10mins to download the data. So we need to reduce time to download.

So please provide your suggestions.

Thanks,

Vijay

[Former Member]

Vijay,

Complex table setting is in SAP configpanel.

Login to your SAP Configpanel -> Select Mobile Data-> Select your application(left side) -> Parameters tab -> search for particular CT table and modify TABLE_CHECK parameter to 160/720 based on your requirement.

This setting means all the time it will not reload the value of the CT table.

Ajitesh

[Former Member]

Thanks Ajitesh,

What is the different between 160 & 720?

Thanks,

Vijay

[Former Member]

There is different variable

-1 = never,

0 = everytime,

1 week = 168,

1 month = 720

So, while mobile device call this CT Bapi this entries will be check and compare in java based on the result it will fetch to mobile.

Ajitesh

[prashanthi_vangala2]

Hi Vijay,

Which platform are you using? Does this CT hold the master data which needs to be downloaded?

Does it take 10 mins to download the data during initial transmit or on every transmit?

- If you want to reduce the time on initial data download, you have to check if you can configure additional filters on this CT to reduce the records or if nothing can be improved because of the amount of data , you would want to consider to pre-built the client with the CT's already downloaded and distribute the pre-built client.

- If you want to reduce the time on delta download or do not want to check for this CT on every sync, you can set the TABLE_CHECK and TABLE_REFRESH parameters as Ajitesh mentioned.

TABLE_CHECK -> what it does is based on the parameter it checks if there is any new/modified/delete data on this CT.

TABLE_REFRESH -> what it does is based on the parameter it refreshes the data entirely on the CT.

-shanthi

[Former Member]

Thanks for the detailed response.

Regards,

Vijay