Skip to Content
avatar image
Saurabh Shiral

How to create a ranking logic based on composite provider?

Dec 19, 2016 at 06:52 AM | 111 Views

Hello Experts,

I have a scenario where, a composite provider (union) is created based on historical adso and hana view. Now I have data where for few document numbers, multiple line items are created as it is present in both info-providers but I need to sort this data based on 'date' and display only the latest document.

I have tried using Virtual Provider, but I am not allowed to create a transformation (and a routine) based on this composite provider. Is there any other way to achieve the same ?

Thanks,

Saurabh

BW SAP HANA Data Warehousing
SAP HANA studio | SAP HANA | adso | composite provider | sap bw on hana
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 13, 2017 at 08:06 AM

    Hi Saurabh,
    you could:
    a) Create a HANA calculation view which would be Union like the one in composite provider and use rank, then use as a source for composite provider
    b) Calculate rank after loading it from composite provider (for example calculate it in Query)

    Regards,
    Mateusz.

    Add comment
    10|10000 characters needed characters exceeded