Forum Discussion

jribs's avatar
jribs
Icon for Helper I rankHelper I
5 years ago

SAP BW, Dates as Text, and Incremental Refresh

SAP BW (non-HANA) and Incrementally Refreshing has been giving me a lot of trouble for the past few months. On a positive note it has taught quite a lot.   Here is the issue: In order to incremen...
Need Help
jribs's avatar
jribs
Icon for Helper I rankHelper I
5 years ago

Agreed. I wish I was working with SQL so it was a bit more straight forward. But I'm not sure how it is done in SAP BW or if it is even working. Hoping someone who worked with SAP BW can help out

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi jribs ,

 

I'm curious if this methond, creating a function that converts the date/time value in the parameters to match the text surrogate key of the data source table, could work in your scenario. 🤔

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.