Thread manufacturer spins its future in the cloud

Play Thread manufacturer spins its future in the cloud
Sign in to queue

Description

Coats, the world's leading industrial thread manufacturer, has made the Microsoft cloud the linchpin of its strategy to transform its business for a data-driven age. Coats is moving all its datacenter assets into Microsoft Azure, including its production SAP HANA systems, to gain elasticity, vastly improve performance, and lower costs.

Embed

Download

Download this episode

The Discussion

  • User profile image
    Radhey

    Hi There,

    Thank You so much for this blog. It helped me lot. I am a Technical Recruiter by profession and first time working on this technology was bit tough for me, this article really helped me a lot to understand the details to get started with.

    Hi there, I'm trying to build a query that identifies changes on item group this year. <a href="https://asha24.com/sap-hana-certification-training">SAP HANA training USA </a>
    I've got the data from table AITM and so far the query looks like below. The issue that I'm having is that the UpdateDate is picking up the whole table changes (and not only the item group code changes). Like I said as a result I want to see all the items that had the item group changed in the current year. Does anyone have any idea on how to get it?
    Thank you!

    SELECT DISTINCT
    T0."Code", T0."Name", T0."GroupCode", T1."GroupCode" , T0."UpdateDate"
    FROM (select "Code", "Name", "GroupCode", "UpdateDate" FROM AITM) T0
    INNER JOIN (select "Code", "Name", "GroupCode", "UpdateDate" FROM AITM) T1 ON T0."Code" = T1."Code"
    WHERE T0."GroupCode" <> T1."GroupCode" AND
    DAYS_BETWEEN( T0."UpdateDate", CURRENT_DATE) <= 80


    Anyways great write up, your efforts are much appreciated.

    Cheers,

    Radhey

Add Your 2 Cents