on 12-19-2016 6:52 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.