SAC Incremental import into a blended model

[former_member1236116]

Hi there!

I have a blended model that get data through OData Services. Model consists of 7 services: 1 (main) + 6 (joins to the main model). Every service has a date field. I would like to refresh the model every day incrementally. Refresh date shoul be from the main model. But it seems to me that delta date option in model settings doesn't work properly. When i set up my date field as delta date it doesn't appear.

I also tried to set up delta date for all services in the main model. Result is the same. No one date did not appears.

Could you be so kind to answer what is wrong and how to refresh incrementally such type model?

Thank's in advance!

[VijayetaSharma]

Hello qehh,

I have seen these kind of issues while connecting other DS via Odata service. One reason is that for delta function to work, SAP should recognize your field as date field and not as string. Unfortunately when you use Odata date field is converted into embedded string instead. This restricts use of these fields as per date dimensions. Hence one is not able to use these field for date hierarchy setup, filtering of date field, use for delta setup etc.

Here is a knowledge base article walk you through this restriction and possible solution.

2638695 - Date Time Fields Have Format Edm.String in OData

Don't forget to up-vote and accept, if it helped. :)

Thanks,

Vijayeta.

[former_member1236116]

Hi vijayeta.sharma!

Thank you for the answer.

All date fields has Edm.Date Time type.

When i set up delta refresh for a single model it's working ok. But the main issue that i can't set up delta update for a blended model.

[VijayetaSharma]

Hi qehh,

I tired to recreate the scenario at my end. Dont think we can create delta on these fields. One way to tell if the field is compatablle with delta function would be to check for incremental icon next to the field during query creation in SAC.

Thanks,

Vijayeta